ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Managing columns (https://www.excelbanter.com/excel-worksheet-functions/179988-managing-columns.html)

KLH

Managing columns
 
How do I cause a certain column to be always to the right no matter what else
may be entered in? Stated differently, can I set up a column to shift over to
the right so that it is always the last one on the sheet?

Don Guillett

Managing columns
 
A bit more explanation as to what is going on?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KLH" wrote in message
...
How do I cause a certain column to be always to the right no matter what
else
may be entered in? Stated differently, can I set up a column to shift over
to
the right so that it is always the last one on the sheet?



KLH

Managing columns
 
My manager has a sheet listing monthly goals for various items. Each month he
wants to enter that month's results and have a column for percentages that
remains to the right. I believe he was hoping to just have it automatically
realign itself there after he inputs the new month's results.

"Don Guillett" wrote:

A bit more explanation as to what is going on?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KLH" wrote in message
...
How do I cause a certain column to be always to the right no matter what
else
may be entered in? Stated differently, can I set up a column to shift over
to
the right so that it is always the last one on the sheet?




Don Guillett

Managing columns
 
A bit more explanation as to what is going on?


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KLH" wrote in message
...
My manager has a sheet listing monthly goals for various items. Each month
he
wants to enter that month's results and have a column for percentages that
remains to the right. I believe he was hoping to just have it
automatically
realign itself there after he inputs the new month's results.

"Don Guillett" wrote:

A bit more explanation as to what is going on?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KLH" wrote in message
...
How do I cause a certain column to be always to the right no matter
what
else
may be entered in? Stated differently, can I set up a column to shift
over
to
the right so that it is always the last one on the sheet?






All times are GMT +1. The time now is 05:41 PM.

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