ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel worksheet formatting (https://www.excelbanter.com/excel-discussion-misc-queries/197154-excel-worksheet-formatting.html)

Farmer Jeff[_2_]

Excel worksheet formatting
 
How do I eliminate the hundreds of empty columns and rows beyond the data
field in a worksheet?
My data goes columns a to G and rows to 110, and that's all I want to see
and have included when I e-mail the document.
thanks for your help.
Farmer Jeff

Tausif

Excel worksheet formatting
 
Hi,
You cant elminate ;) the hundreds of columns & rows, bt you can def hide them.

Select the H:IV, Right click on the higlighted cells & click HIDE.
Similarly, Select rows from 111:65000, rightclick & hide.

That shld work your requirements I think ?

HTH,
--
Tausif Mohammed


"Farmer Jeff" wrote:

How do I eliminate the hundreds of empty columns and rows beyond the data
field in a worksheet?
My data goes columns a to G and rows to 110, and that's all I want to see
and have included when I e-mail the document.
thanks for your help.
Farmer Jeff



All times are GMT +1. The time now is 10:31 AM.

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