Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a stationary column
All of my business billing uses Excel. As a spreadsheet grows, I can no
longer see the corresponding names in the first column. I receive my data on an uploaded Excel file where the creator has made the first column stationary. Meaning, as I move to work in columns to the right the names remain in place in the first column. How do I make the first (or any other) column stay in place (visible) on Excel files/sheets I create? -- Thanks for your help! |
#2
|
|||
|
|||
Hi
- move the cursor to the row BELOW your heading / right to the column - goto 'Windows - Freeze Panes' -- Regards Frank Kabel Frankfurt, Germany "Still Learning" schrieb im Newsbeitrag ... All of my business billing uses Excel. As a spreadsheet grows, I can no longer see the corresponding names in the first column. I receive my data on an uploaded Excel file where the creator has made the first column stationary. Meaning, as I move to work in columns to the right the names remain in place in the first column. How do I make the first (or any other) column stay in place (visible) on Excel files/sheets I create? -- Thanks for your help! |
#3
|
|||
|
|||
I thought it must be that simple, but I didn't know the term to look up was
"Freeze." Thanks so much for solving this previously frustrating problem. Diane in California |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |