ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I set up a page in excel that will be a list with rows and (https://www.excelbanter.com/excel-discussion-misc-queries/135127-how-do-i-set-up-page-excel-will-list-rows.html)

Carol

How do I set up a page in excel that will be a list with rows and
 
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

Wood Grafing

How do I set up a page in excel that will be a list with rows and
 
Sounds like you need help with the basics. This is a good place to start:

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

"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


Gord Dibben

How do I set up a page in excel that will be a list with rows and
 
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



Carol

How do I set up a page in excel that will be a list with rows
 
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




Gord Dibben

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






All times are GMT +1. The time now is 02:56 AM.

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