ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Modify Spreadsheet View (https://www.excelbanter.com/new-users-excel/134276-modify-spreadsheet-view.html)

Maurice

Modify Spreadsheet View
 
I have just imported finance data into a spreadsheet. It went well but there
are columns in the view that have no data. If I could eliminate columns L
to the end the remaining columns would be larger. I also see 'page tabs'
where there is apparently no data as well. Would their elimination allow me
to see more data? Please advise

Gord Dibben

Modify Spreadsheet View
 
Maurice

You cannot eliminate unused columns to make the other columns wider.

You can widen your data columns by just dragging on the column header or
selecting them and FormatColumnWidth........enter a number.

Eliminating the extra sheet tabs will not make the veiwed sheet any larger.

You could set the zoom to something less than 100% but this will make your
cells/fonts smaller and harder to read.


Gord Dibben MS Excel MVP


On Fri, 9 Mar 2007 18:05:03 -0800, Maurice
wrote:

I have just imported finance data into a spreadsheet. It went well but there
are columns in the view that have no data. If I could eliminate columns L
to the end the remaining columns would be larger. I also see 'page tabs'
where there is apparently no data as well. Would their elimination allow me
to see more data? Please advise




All times are GMT +1. The time now is 09:55 AM.

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