ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How we can hide the rows no. 1,2,3,4,.. &Column no. A,B,C,D...AA (https://www.excelbanter.com/excel-worksheet-functions/181307-how-we-can-hide-rows-no-1-2-3-4-column-no-b-c-d-aa.html)

Sandy

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

ryguy7272

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


David Biddulph[_2_]

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





All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com