ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rename rows/ in an Excel Spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/15888-rename-rows-excel-spreadsheet.html)

ramacano

Rename rows/ in an Excel Spreadsheet
 
Can I rename the rows/columns in my Excel Spreadsheet so that when I scroll
across or down in a large table I can still see my headings?

Gordon

ramacano wrote:
|| Can I rename the rows/columns in my Excel Spreadsheet so that when I
|| scroll across or down in a large table I can still see my headings?

Go to Window-Freeze Panes

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk



JulieD

Hi,

No you can't rename them, but you can click in cell A2 and choose window /
freeze panes to keep row 1 displayed when you scroll down (to remove this,
choose window / unfreeze panes)

Cheers
JulieD
"ramacano" wrote in message
...
Can I rename the rows/columns in my Excel Spreadsheet so that when I
scroll
across or down in a large table I can still see my headings?





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

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