Column

Column


A column may refer to any of the following:

  • A column is a vertical series of cells in a chart, table, or spreadsheet. Below is an example of a Microsoft Excel spreadsheet with column headers (column letter) A, B, C, D, E, F, G, and H. As you can see in the image, the last column H is the highlighted column in red and the selected cell D8 is in the D column.

    How are columns and rows labeled?

  • In all spreadsheet programs including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1,048,576). All columns are labeled with letters starting with the letter A and then incrementing by a letter after the final letter Z. For example, after the letter Z, the next column is AA, AB, AC, ..., AZ and then incrementing to BA, BB, BC, etc. to the last column XFD.

  • When working with a cell, you combine the column with the row. For example, the very first cell is in column A and on row 1, so the cell is labeled as A1.

    How can I freeze or make a column that does not move?

  • To keep column 'A' or a set of columns frozen so they do not move as you scroll to the right, use the freeze pane option.

    How to highlight a column using the keyboard

  • To highlight a column in Microsoft Excel using your keyboard, first move to a cell in the column you want to highlight. Then, press and hold the Ctrl key and press the spacebar (Ctrl+Space).


    What is an Operating System? » Computer Shortcut Keys and their Functions » Keyboard Function Keys » Computer Basics - Hardware - Software - Parts


    Short Stories for Kids - Moral Stories – English Short Stories for Children - Moral Stories for Kids - Stories for Kids - Funny Story for Kids - Scary Stories for Kids - Really Funny Short Stories - Bedtime Stories
    Proverb Stories
    Powerful Motivational Quotes for Students » Success Quotes » English Short Stories for Kids

    Cabin Crew Jobs & Career Advice » Secretary Job Description » Receptionist Job Description » Top 100 Interview Questions and Answers » How to Prepare for an Interview » How to Write a CV » How to Choose a Career » Computer Shortcut Keys and their Functions

    Scholarships in Australia » Scholarships in Austria » Scholarships in Belgium » Scholarships in Canada » Scholarships in Germany » Scholarships in Ireland » Scholarships in Italy » Scholarships in Japan » Scholarships in Korea » Scholarships in Netherlands » Scholarships in Switzerland » Scholarships in UK » Scholarships in USA

    Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Scholarships for Study in Africa » Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants Short Stories for Kids - Moral Stories – English Short Stories for Children - Moral Stories for Kids - Stories for Kids - Funny Story for Kids - Scary Stories for Kids - Really Funny Short Stories - Bedtime Stories
    Proverb Stories
    Powerful Motivational Quotes for Students » Success Quotes »Scholarships in UK » Scholarships in USA Scholarships in UK » Scholarships in USA Scholarships in UK » Scholarships in USA Scholarships in UK »

  • Click here to post comments

    Join in and write your own page! It's easy to do. How? Simply click here to return to Computer Basics FAQ.