ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hide columns and rows (https://www.excelbanter.com/excel-worksheet-functions/159510-hide-columns-rows.html)

delete automatically

Hide columns and rows
 
When I get an worksheet done, can I get rid of the row of letters A thru z
and the columns of numbers 1 -100 so we cant see them All I want to see is
the worksheet

Peo Sjoblom

Hide columns and rows
 
You can hide them, there is no way of deleting the columns or the rows, you
can delete what's in them and then hide them


--


Regards,


Peo Sjoblom



"delete automatically" wrote
in message ...
When I get an worksheet done, can I get rid of the row of letters A thru
z
and the columns of numbers 1 -100 so we cant see them All I want to see is
the worksheet




JW[_2_]

Hide columns and rows
 
On Sep 24, 7:30 pm, delete automatically
wrote:
When I get an worksheet done, can I get rid of the row of letters A thru z
and the columns of numbers 1 -100 so we cant see them All I want to see is
the worksheet


Do you mean that you don't want to see the column letters and row
numbers? If so:
Tools--Options--View Tab
Uncheck Row & column headings



All times are GMT +1. The time now is 10:28 PM.

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