0
What else can I help you with?
What is short key to hide a row or column in MS Excel?
The short key to hide a row in MS Excel is Ctrl key and the number nine. The short key to hide a column is Ctrl key and the number zero. You first need to click on a cell in the column or row that you want to hide.
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.
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 conceal data in excel?
It depends on what you are trying to accomplish. You can hide a column, so it does not appear or you can format the cell contents to be white instead of black.
How do you unhide and hide rows and columns in excel 2007?
Click home tab, click hide and unhide, click unhide sheet. Click home tab, click hide and unhide click hide sheet.
Can you hide columns and rows in Excel?
Yes you can. Ctrl - 9 hides a row. Ctrl - 0 hides a column. Add the Shift key to those combinations and they can be unhidden.
How do you collapse rows in Excel?
There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.
When you decrease a column wight to the column is hidden?
You can hide a column by reducing its width.
How to hide columns of a spreadsheet in Microsoft Excel 2007 with the steps?
To hide columns of a spreadsheet in Microsoft Excel 2007 simply select the columns and click on the hide option.
Can you hide a column by setting the column width to zero?
Yes you can.
What is difference between Delete and Hide Column in Excel?
Delete completely gets rid of a column. Columns to the right of it all move over. So if you deleted column D, column E would become column D. Hiding a column makes it disappear from view, but it is still part of the spreadsheet and can be hidden. If you hid column D, you would still see column C and to the right of it would be column E. You can still use cells in columns that are hidden in formulas.
How do you hide a column in a worksheet?
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.
