LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do I set up a page in excel that will be a list with rows

ToolsOptionsView. Checkmark "gridlines"

Column widths and row heights can be dragged wider/taller or
FormatColumnWidth.....enter a number.

Note: column widths and row heights are a property of the entire column or row.

For printing, FilePage SetupSheet. Checkmark in "gridlines".

You may want to visit one or more of these sites.

Some tutorial sites for basics of Excel........

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord


On Thu, 15 Mar 2007 19:59:24 -0700, Carol
wrote:

Just imagine a piece of notebook paper with the lines and add the columns,
but I need the columns to be varied widths. When I fill in the cells and
print there are no printed lines or columns. In Word if you go to tables and
charts you can choose how many lines and columns and then manually move the
columns width to whatever you need. I'm trying to do the same in
excel....Thanks

"Gord Dibben" wrote:

This is what Excel does.

Prints columns and rows.

You decide how wide and how many.

With the amount of detail posted, it would be difficult to hazard a guess at
what you need done.

Maybe post back with some detail on ranges?


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 17:25:30 -0700, Carol
wrote:

I need to know how to make a list in excel with rows and custom width columns
that will print with rows on lines and columns separated with lines and also
how to set up how many lines and columns like in Word and how to add more
lines if needed.....Thanks...Carol






 
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
Conditional page break if merged rows won't fit on the page. zbprtal Excel Worksheet Functions 1 April 12th 06 08:53 PM
Automatically insert page break every 6 rows in excel doc Icetea Excel Discussion (Misc queries) 1 October 10th 05 11:55 AM
Excel should allow me to repeat bottom rows on every page. Bettina Dixon Excel Worksheet Functions 0 May 12th 05 02:56 PM
I want 20 rows in excel to take up full A4 page Sillygoose Excel Worksheet Functions 1 April 6th 05 05:07 AM
Keep rows on same page in Excel SWeyer Excel Discussion (Misc queries) 3 February 18th 05 05:15 PM


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

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

About Us

"It's about Microsoft Excel"