0
What else can I help you with?
What shortcut is available in Microsoft Excel to add numbers in a column?
You can add an entire column by using =sum(a:a) for example, which would sum all amounts in column A. Also, holding down the Alt key while hitting the equal sign right below a column of numbers will sum that column
Which is the correct process for selecting an entire column?
Click on the letter at the top of a column or put the cursor in any cell in the column and press and hold the Ctrl key and then press the space bar.
Can you move datasheet columns by dragging the field name left or right?
No. Insert a blank column where you want the old column to be (otherwise you will overweight existing data) Highlight the entire column to be moved, then right click and choose cut. Click on the new blank column and then right click and choose paste.
Can you format an entire column once?
You cannot format an entire column at once
What keyboard shortcut can be used to spell check the entire document?
The 4 words in the lower left hand corner, next to the check, below where you type, is where you will find the button.
How do you produce the sum of a column by using the auto sum function?
Assuming you're using Microsoft Excel, select the entire column by clicking and dragging with the mouse, then press the AutoSum button (looks like Σ).
Can you reference an entire column or an entire row in a function argument by listing only the column or only the row?
yes
In Microsoft Excel if you want to hide a column of one part of the page how do you keep the other part visible?
Select only the column you want to hide. All of the other columns will be visible. Your question is not clear, so if you mean how do you hide a part of a column and not the entire column, then just change the font color to white in the range you want to hide.
How do you delete an entire row or column in Excel?
Click on the row or column header you want to delete. Then right click and pick Delete.
Write the shortcut keys to select entire row and column?
Shift - Spacebar selects the current row. Ctrl - Spacebar selects the current column. As a way of remembering which is which, think of C for column and Ctrl. Note that if more than one cell is selected when using these commands the rows or columns of the selected cells will be selected, not just the ones relating to the active cell. This also means that if you do one after the other, in any order, the entire worksheet will be selected.
What symbol lets you select an entire column?
Just click the column header (where the column letter is).
What is the easist method to select a column in Excel?
Click on the letter at the top of the column; that will select the entire column.
