ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i slide months of data under my first column? (https://www.excelbanter.com/excel-worksheet-functions/80507-how-do-i-slide-months-data-under-my-first-column.html)

radio2stu

how do i slide months of data under my first column?
 


Roger Govier

how do i slide months of data under my first column?
 
Hi

To fix just the first column, place your cursor in B1 then
WindowsFreeze Panes.
If you want to fix row 1 as the header row as well, then place cursor in
B2 before freezing panes.

--
Regards

Roger Govier


"radio2stu" wrote in message
...




radio2stu

how do i slide months of data under my first column?
 
cool! now how do i slide the rest of the columns under Col1?

"Roger Govier" wrote:

Hi

To fix just the first column, place your cursor in B1 then
WindowsFreeze Panes.
If you want to fix row 1 as the header row as well, then place cursor in
B2 before freezing panes.

--
Regards

Roger Govier


"radio2stu" wrote in message
...






All times are GMT +1. The time now is 02:24 PM.

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