ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze columns (https://www.excelbanter.com/excel-discussion-misc-queries/244231-freeze-columns.html)

Nydia

Freeze columns
 
I want to freeze column B so when I scroll to the end of my spreadsheet I can
still see what is typed in Column B

Ms-Exl-Learner

Freeze columns
 
Try this...

Just place the cursor in the C2 cell ALT+W+F to do freeze in 2003, for 2007
press ALT+W+F and enter.

If you dont want the 1st row heading then place the cursor in c1 cell and try.

If this post helps, Click yes!

--------------------
(Ms-Exl-Learner)
--------------------


"Nydia" wrote:

I want to freeze column B so when I scroll to the end of my spreadsheet I can
still see what is typed in Column B


Jacob Skaria

Freeze columns
 
Hi Nydia

You can either try freeze panes options or use the Spit option.
XL07: ViewSplit/Freeze Panes
XL03: WindowSplit/Freeze Panes

(If you use the split option you can drag the horizontal split to top so as
to have the vertical one alone..)

If this post helps click Yes
---------------
Jacob Skaria


"Nydia" wrote:

I want to freeze column B so when I scroll to the end of my spreadsheet I can
still see what is typed in Column B



All times are GMT +1. The time now is 11:59 AM.

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