0
By default all cells are locked but they are still able to be edited until you choose the Tools... Protection... Protect Sheet (or Protect Workbook) menu. So what I do is to select all cells (Control + a) and switch off locking by clicking on the toolbar button that looks like a padlock. I then select the specific cells, rows and columns that I want to lock and lock them using the same toolbar button.
At this point you hide a column or range of columns (or rows) by dragging through the column headers or row labels (the grey boxes with the column letters or row numbers) with the mouse and then right clicking on the column header or row label and selecting 'Hide' from the menu that appears.
When you have done all your editing go to the Tools... Protection... Protect Sheet (or Protect Workbook) menu again. If anybody else is going to be using the workbook give a password at this point or else somebody will undo all of your hard work.
Wiki User
∙ 15y ago
Wiki User
∙ 14y agoPut the cursor into the column you want to hide. Go to the Format menu, pick Column and pick Hide. You can use the menu to restore it. Another way to hide it is to put the cursor in the column and press and hold the Ctrl key and then press 0 (zero). Holding Ctrl Shift and 0 will return it. When unhiding a column you need to have the cursor in the columns nearby, ideally selecting the columns around them.
Add your answer:
Earn +20 pts
How do you keep the title and column labels of a worksheet on the screen no matter where the worksheet is scrolled?
how do you keep the title and column labels of a worksheet on the screen no matter where the worksheet is scrolled
Used to hide an entire worksheet?
hide command
How does an 8-column worksheet differ from a 10-column worksheet?
An 8-column worksheet is standard for the following: Unadjusted Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, and Balance Sheet. The 10-column worksheet has an extra two columns for the Post-Closing Trial Balance.
In which ways can you set the row titles to remain visible as you enter the new figures?
*Split the worksheet into 2 vertical panes, w/ the column containing row titles in the first pane *Hide the columns between the first column and the column for November *Freeze the first column
Can you have two different column widths on one excel worksheet?
Yes. Every column on the worksheet can have a different width, if you like.
What is used to add worksheet column and row titles on a worksheet in excell?
Text
What is a vertical arrangement of information on a worksheet?
column
What happens when you hide a column in Microsoft Excel?
The column disappears from view so you cannot see it. You will notice its heading is missing, so if column H was hidden you would see column G and then column I. The values in column H can still be used in the worksheet by referencing them in the normal way. Hiding columns can be useful for hiding data that you do not want to be seen or that you do not want users to change or that does not need to be seen. It can be used to put in supporting data to a worksheet rather than having it cluttering up the screen by being visible.
What would happen if you autosum the width of column A after you entered the worksheet title?
AutoSum has nothing to do with column width or a worksheet title, so nothing significant.
Does a worksheet column heading start with 1 and appear down the left side of a worksheet?
No, column headings start with A and go across the worksheet. The row headings start with 1 and go down the left.
I have created a worksheet in Excel and only want to print Columns A and G. How do I do this?
To set the area of an Excel worksheet that will be printed select the range that you want to print and go to the File... Print Area... Set Print Area menu. You can also hide columns that you don't want to see on a print-out by right clicking on the column header and selecting Hide.
What is a column of data in a worksheet called?
It is called a column. There is no other official special name.
