ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   freezing multiple columns (https://www.excelbanter.com/new-users-excel/63484-freezing-multiple-columns.html)

[email protected]

freezing multiple columns
 
Have a spreadsheet where Column A are items (Monday, Tuesday, etc) and
the last column is the YTD totals. Everything column in between are
the 52 weeks of the year. I need to freeze the first and last column.
I only need to show 4 to 5 weeks at a time in between. Any
suggestions???


Cutter

freezing multiple columns
 

My suggestion would be to have your YTD column in Col A, your weekday
list in Col B and then freeze those 2 columns using Window Freeze
Panes


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=498622



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

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