i wanna creat a spreadsheet that does not have formulas but want the grid lines visible...can anyone help me? Also I would like the chart to take the entire page how do i do that?HELP!!!!!
2006-07-31 10:08:48 · 5 answers · asked by shhhhh s 2 in Computers & Internet ➔ Software
Go to File...Page Setup...
Sheet...
then select Gridlines under the Print heading.
When you print it will include the lines.
Even if there is nothing in the cells, you can select a range to print with File...Print Area...Set Print Area.
Goog luck.
2006-07-31 10:17:28 · answer #1 · answered by Mike S 6 · 2⤊ 0⤋
The 2nd answer was correct if you want to view the gridlines on screen, and the 3rd answer was correct is you want to print the gridlines. To make the chart to take the entire page, first select the chart (assuming its current position is within a worksheet.), then right click and select Location in the menu. Select As New Sheet. You can use the default tab name or give it a new one. Then the chart will be in its own tab and take the entire page.
To print the chart on an entire page, all you need to do is to select the chart and print it regardless if the chart is in its own tab or within a worksheet.
2006-07-31 18:33:16 · answer #2 · answered by jxu 2 · 0⤊ 0⤋
Gridlines visible on the screen or when you print?
(On the screen go to tools/options/view and make sure gridlines is clicked, if so then highlight all the cells and right click, go to format and click the type of bordering you want. Selecting a border and color other than white will cause the gridlines to show when you print.
By size of the whole page do you mean on the screen or when you print.?
(To print to one page go to file-page setup then click fit to 1 by 1)
If its grabbing to much go to the view menu and click page break preview and adjust the print area)
2006-07-31 17:16:42 · answer #3 · answered by rweasel6 2 · 0⤊ 0⤋
yah all you do is highlight the area you want and select the format button click on cells then the border tab. then highlight the lines that showinside and outside.
To make it fit the sheet just hit print area and print preview. you can make it larger or smaller as needed. also dont forget to choses if you want it long was or normal. longways is in the landscape view normal id letter
2006-07-31 17:13:38 · answer #4 · answered by staci m 4 · 0⤊ 0⤋
To have visible "grid lines":
Select "all" (Ctrl + A). Go to "format" then click on "cells" then choose the tab across the top that says "borders." You can choose "outline" and "inside" which will make the grid. (See "print preview").
2006-07-31 17:18:04 · answer #5 · answered by am 2 · 0⤊ 0⤋