Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do I reduce the amount of columns in a sheet?

Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means the
horizontal scroll bar is very not sensitive, and not helpful for using only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do I reduce the amount of columns in a sheet?

Hi D_N_A,

Yes, you can definitely reduce the number of columns in your Excel sheet. Here's how you can do it:
  1. Open your Excel sheet and select the column(s) you want to delete. You can do this by clicking on the column letter(s) at the top of the sheet.
  2. Right-click on the selected column(s) and choose "Delete" from the drop-down menu.
  3. A dialog box will appear asking you to confirm the deletion. Make sure to select "Entire column" and click "OK".
  4. The selected column(s) will be deleted and the remaining columns will shift to the left to fill the gap.
  5. Repeat this process for any additional columns you want to delete.
  6. Once you have deleted the desired columns, save your Excel sheet.

By reducing the number of columns in your sheet, you should find that the horizontal scroll bar becomes more sensitive and easier to use. This will make it easier for you to work with your charts and other data.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default How do I reduce the amount of columns in a sheet?

You can't remove the columns (many people asked for more columns than
the 256 limit in earlier versions !!), but what you can do is hide the
columns that you don't need (or set them to zero width).

Hope this helps.

Pete

On May 2, 1:40*am, D_N_A wrote:
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means the
horizontal scroll bar is very not sensitive, and not helpful for using only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How do I reduce the amount of columns in a sheet?

hi
a lot of people wanted more rows than 65536 and more columns than 255 so now
we deal with the problems more rows and colmumns presents. Isn't progress
WONderful!?!?
"be careful of what you ask. you might get it."
i'll get off my soapbox now.
have you tried saving the file as an xls instead of xlsx ie going back to
the fewer rows and columns.????
i don't have 07 so i'm doing a lot of wild guessing now.

regards
FSt1

"D_N_A" wrote:

Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means the
horizontal scroll bar is very not sensitive, and not helpful for using only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default How do I reduce the amount of columns in a sheet?

Pete

The problem with just hiding the columns, is that it doesn't prevent you
scrolling through the hidden columns, and scrolling seemed to be the problem
the OP was complaining about.

An alternative would be to restrict the scroll area of the sheet. This would
require some VBA code to set the scroll area each time the workbook was
opened.

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:Z100"
End Sub

Copy the Code above
Alt+F11 to invoke the VB Editor
Double Click ThisWorkbook in the Project Explorer pane
Paste code into white pane that appears
Alt+F11 to return to Excel

The code will be triggered automatically as the workbook is opened and will
limit you to an area of the sheet from A1 to Z100.
Amend range to suit.
--
Regards
Roger Govier

"Pete_UK" wrote in message
...
You can't remove the columns (many people asked for more columns than
the 256 limit in earlier versions !!), but what you can do is hide the
columns that you don't need (or set them to zero width).

Hope this helps.

Pete

On May 2, 1:40 am, D_N_A wrote:
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means
the
horizontal scroll bar is very not sensitive, and not helpful for using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do I reduce the amount of columns in a sheet?

"D_N_A" wrote:

Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means the
horizontal scroll bar is very not sensitive, and not helpful for using only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A


I have discovered something weird.
In a new clean sheet, the scrolling bar scrolls from A to M.
But in the sheet I worked on and was talking about, the scrolling is from A
to the last column XFD.
When I deleted all of the graphs from my sheet (Only after there was no
graph in it), the scrolling bar suddenly turned normal.
Can someone solve the problem?
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do I reduce the amount of columns in a sheet?

"D_N_A" wrote:

"D_N_A" wrote:

Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means the
horizontal scroll bar is very not sensitive, and not helpful for using only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A


I have discovered something weird.
In a new clean sheet, the scrolling bar scrolls from A to M.
But in the sheet I worked on and was talking about, the scrolling is from A
to the last column XFD.
When I deleted all of the graphs from my sheet (Only after there was no
graph in it), the scrolling bar suddenly turned normal.
Can someone solve the problem?


Plus when I saved the sheets with the graphs as Excel 97-2003 the same
scroling problem occured, only that the scrolling was from A to IV.
Restarting the computer didn't solve the problem.
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default How do I reduce the amount of columns in a sheet?

The scrolling usually involves only what Excel thinks it the used range.
Excel in this case thinks your used range includes all columns.

Select the first column in your sheet that you consider blank. Click the End
button on the keyboard, then hold Shift and click the right arrow. This
selects all columns from the one you selected to the right edge of the
sheet. Right click on the column header and select Delete to delete these
columns, and whatever about them Excel thinks you are using. After saving
the workbook, Excel should now consider only the undeleted columns as the
used range.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"D_N_A" wrote in message
...
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means
the
horizontal scroll bar is very not sensitive, and not helpful for using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A



  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default How do I reduce the amount of columns in a sheet?

D_N_A wrote:
"D_N_A" wrote:

"D_N_A" wrote:

Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means the
horizontal scroll bar is very not sensitive, and not helpful for using only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A

I have discovered something weird.
In a new clean sheet, the scrolling bar scrolls from A to M.
But in the sheet I worked on and was talking about, the scrolling is from A
to the last column XFD.
When I deleted all of the graphs from my sheet (Only after there was no
graph in it), the scrolling bar suddenly turned normal.
Can someone solve the problem?


Plus when I saved the sheets with the graphs as Excel 97-2003 the same
scroling problem occured, only that the scrolling was from A to IV.
Restarting the computer didn't solve the problem.


Consider putting the charts on separate worksheets.

Bill
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do I reduce the amount of columns in a sheet?

Nice Idea, but didn't work, although I saved and exited the program.

"Jon Peltier" wrote:

The scrolling usually involves only what Excel thinks it the used range.
Excel in this case thinks your used range includes all columns.

Select the first column in your sheet that you consider blank. Click the End
button on the keyboard, then hold Shift and click the right arrow. This
selects all columns from the one you selected to the right edge of the
sheet. Right click on the column header and select Delete to delete these
columns, and whatever about them Excel thinks you are using. After saving
the workbook, Excel should now consider only the undeleted columns as the
used range.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"D_N_A" wrote in message
...
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means
the
horizontal scroll bar is very not sensitive, and not helpful for using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A






  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default How do I reduce the amount of columns in a sheet?

On May 2, 2:19*pm, D_N_A wrote:
Nice Idea, but didn't work, although I saved and exited the program.

"Jon Peltier" wrote:
The scrolling usually involves only what Excel thinks it the used range..
Excel in this case thinks your used range includes all columns.


Select the first column in your sheet that you consider blank. Click the End
button on the keyboard, then hold Shift and click the right arrow. This
selects all columns from the one you selected to the right edge of the
sheet. Right click on the column header and select Delete to delete these
columns, and whatever about them Excel thinks you are using. After saving
the workbook, Excel should now consider only the undeleted columns as the
used range.


- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"D_N_A" wrote in message
...
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means
the
horizontal scroll bar is very not sensitive, and not helpful for using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A


There is something that Excel thinks you have as valid data in columns
you believe blank. Scroll bar should normally be only those columns
you are actively using. Are you formatting rows by selecting the
entire row or are you selecting a finite range of cells to format? I
have seen many spreadsheets with lines or shading etc. that goes all
the way out to the limit. I believe this may be the problem.
  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do I reduce the amount of columns in a sheet?

I have selected the names of the columns, so It selected the whole column for
every column from around M untill the end. As I sayd earlier, the problem
appears only when the graphs are in the sheet, and disappears when they all
(and not anything else) are deleted. This is, I believe, the sorce of the
problem..

"Trekman" wrote:

On May 2, 2:19 pm, D_N_A wrote:
Nice Idea, but didn't work, although I saved and exited the program.

"Jon Peltier" wrote:
The scrolling usually involves only what Excel thinks it the used range..
Excel in this case thinks your used range includes all columns.


Select the first column in your sheet that you consider blank. Click the End
button on the keyboard, then hold Shift and click the right arrow. This
selects all columns from the one you selected to the right edge of the
sheet. Right click on the column header and select Delete to delete these
columns, and whatever about them Excel thinks you are using. After saving
the workbook, Excel should now consider only the undeleted columns as the
used range.


- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"D_N_A" wrote in message
...
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that means
the
horizontal scroll bar is very not sensitive, and not helpful for using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A


There is something that Excel thinks you have as valid data in columns
you believe blank. Scroll bar should normally be only those columns
you are actively using. Are you formatting rows by selecting the
entire row or are you selecting a finite range of cells to format? I
have seen many spreadsheets with lines or shading etc. that goes all
the way out to the limit. I believe this may be the problem.

  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default How do I reduce the amount of columns in a sheet?

I've never known charts to have this effect. Does it happen in all
workbooks, or is this one unique?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"D_N_A" wrote in message
...
I have selected the names of the columns, so It selected the whole column
for
every column from around M untill the end. As I sayd earlier, the problem
appears only when the graphs are in the sheet, and disappears when they
all
(and not anything else) are deleted. This is, I believe, the sorce of the
problem..

"Trekman" wrote:

On May 2, 2:19 pm, D_N_A wrote:
Nice Idea, but didn't work, although I saved and exited the program.

"Jon Peltier" wrote:
The scrolling usually involves only what Excel thinks it the used
range..
Excel in this case thinks your used range includes all columns.

Select the first column in your sheet that you consider blank. Click
the End
button on the keyboard, then hold Shift and click the right arrow.
This
selects all columns from the one you selected to the right edge of
the
sheet. Right click on the column header and select Delete to delete
these
columns, and whatever about them Excel thinks you are using. After
saving
the workbook, Excel should now consider only the undeleted columns as
the
used range.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and
Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______

"D_N_A" wrote in message
...
Hi,
I use Excel 2007 Home and Student.
It has a lot of columns (max. number: XFD. you do the math). that
means
the
horizontal scroll bar is very not sensitive, and not helpful for
using
only 3
charts. Can I make the sheet offer me less columns?
Thanks a lot,
D_N_A


There is something that Excel thinks you have as valid data in columns
you believe blank. Scroll bar should normally be only those columns
you are actively using. Are you formatting rows by selecting the
entire row or are you selecting a finite range of cells to format? I
have seen many spreadsheets with lines or shading etc. that goes all
the way out to the limit. I believe this may be the problem.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reduce excel file size by deleting blank rows and columns?? Delta007bhd Excel Discussion (Misc queries) 5 April 4th 23 12:48 PM
I want to actually reduce the number of rows & columns in a worksh Faisal Excel Discussion (Misc queries) 4 April 4th 23 11:20 AM
Externalising a sheet to reduce Workbook size Mike Langensiepen New Users to Excel 2 November 14th 07 02:51 AM
How do I reduce the no. of rows & columns in a worksheet ? Anna Walton Excel Discussion (Misc queries) 2 May 30th 06 05:18 PM
Reduce columns and rows count? murat Excel Worksheet Functions 3 March 16th 05 08:43 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"