ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Excel-Set end column (https://www.excelbanter.com/setting-up-configuration-excel/91174-excel-set-end-column.html)

LBYerino

Excel-Set end column
 
When creating spreadsheet, I need to be able to set the last column that I
need as the end column (with the ability to change or remove the setting, if
necessary.) I waste time when the spreadsheet shifts to the left, thinking I
need more columns.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

Bondi

Excel-Set end column
 
Hi,

You can hide all the rows you don't need. Highlight from your last
column and all the way out to row IV right-click and chose Hide. If you
need them again you can unhide them.

Regards,
Bondi


Heidi

Excel-Set end column
 
How do you do the same for the millions of rows? Is there a way to make a
"bottom" for a form I created?

"LBYerino" wrote:

When creating spreadsheet, I need to be able to set the last column that I
need as the end column (with the ability to change or remove the setting, if
necessary.) I waste time when the spreadsheet shifts to the left, thinking I
need more columns.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup



All times are GMT +1. The time now is 08:47 AM.

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