| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help on rows and columns
I have downloaded a workbook from somewhere I don't remember.
It has a worksheet in it which has columns A to I only and rows 1 to 52 only. After row 52 and column I there's just grey space which is also not selectable with the cursor. I want to know, how to do that and how do I unlock the rows and columns? Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help on rows and columns
On Feb 8, 1:03*am, Sahir wrote:
I have downloaded a workbook from somewhere I don't remember. It has a worksheet in it which has columns A to I only and rows 1 to 52 only. After row 52 and column I there's just grey space which is also not selectable with the cursor. I want to know, how to do that and how do I unlock the rows and columns? Please help. The rows are hidden, Select the sheet by clicking on the square at the left top corner of the spread sheet, the hit Ctrl+Shift+0 to unhide the Columns And Ctrl+Shift+9 to unhide the Rows Ctrl+0 will hide selected Columns and Ctrl+9 will hide selected rows You can also use the format menu to hide rows and columns |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
Linear Mode
