Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Excel 2000 column question

I am making a mailing list of sorts with 3 columns of data. How can I make
the page format so that as I'm entering in new data it goes from the bottom
of the first column to the top of the seconds column and etc.? and not carry
on to the top of the next page?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2000 column question

For saving paper when printing?

I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad
first--large tables cause me trouble in MSWord.

If that doesn't work for you, David McRitchie has a macro that will "snake" the
columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Marci wrote:

I am making a mailing list of sorts with 3 columns of data. How can I make
the page format so that as I'm entering in new data it goes from the bottom
of the first column to the top of the seconds column and etc.? and not carry
on to the top of the next page?


--

Dave Peterson
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
Excel 2000 Date Question Steven Excel Worksheet Functions 7 March 21st 06 07:49 PM
Excel 2000 Track Changes Question. kahanad Excel Discussion (Misc queries) 1 December 8th 05 06:08 PM
Excel 2000 Question Troy Excel Worksheet Functions 3 September 26th 05 01:59 AM
Question about XML functionality in Excel 2000/XP aeg42 Setting up and Configuration of Excel 3 May 22nd 05 09:11 PM
Question about XML functionality (add-ons?) in Excel 2000 & 2002 aeg42 Excel Discussion (Misc queries) 0 May 19th 05 02:13 PM


All times are GMT +1. The time now is 08:47 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"