Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How we can hide the rows no. 1,2,3,4,.. &Column no. A,B,C,D...AA
i rcvd a sheet in which the Row Sl no. i.e; 1,2,3,4,5,6,.....
& column sl no. A,B,C,D,E,F,G,.......AA,AB,...... WAS NOT VISIBLE KINDLY LET ME KNOW HOW TO DO THIS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How we can hide the rows no. 1,2,3,4,.. &Column no. A,B,C,D...AA
Select the little square in the (very) upper left hand corner of the SS.
Click Format Column Width, then type in your desired width, such as 12. Click Format Row Height, then type in your desired height, such as 12. Regards, Ryan-- -- RyGuy "SANDY" wrote: i rcvd a sheet in which the Row Sl no. i.e; 1,2,3,4,5,6,..... & column sl no. A,B,C,D,E,F,G,.......AA,AB,...... WAS NOT VISIBLE KINDLY LET ME KNOW HOW TO DO THIS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How we can hide the rows no. 1,2,3,4,.. &Column no. A,B,C,D...AA
Tools/ Options/ View:
Uncheck: Row & column headers. -- David Biddulph "SANDY" wrote in message ... i rcvd a sheet in which the Row Sl no. i.e; 1,2,3,4,5,6,..... & column sl no. A,B,C,D,E,F,G,.......AA,AB,...... WAS NOT VISIBLE KINDLY LET ME KNOW HOW TO DO THIS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cut rows without cutting hide rows | Excel Discussion (Misc queries) | |||
Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
hide column and rows | Excel Discussion (Misc queries) | |||
Want to auto hide rows in excel when no data in a certain column. | Excel Discussion (Misc queries) |