ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/261157-spreadsheet.html)

Arthur

spreadsheet
 
1) just creating a simple spreadsheet with names in columns and rows.
entered all that in , but need to choose gridlines . cant find where to
activate them.
2) exel wants to put a page break on my page. dont want any page break on
this page.
3) put header title and footer (page number). excel puts page number at top
also. do not want page number at top; bottom only. what to do.

Gord Dibben

spreadsheet
 
1. 2007...............ButtonExcel OptionsAdvancedDisplay Options for
This Worksheet

1. 2003...............ToolsOptionsView

In those options you will find where to uncheck "show pagebreaks" which will
take care of 2

3. Under Headers/Footers you choose where you want the page numbers.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 12:15:01 -0700, Arthur
wrote:

1) just creating a simple spreadsheet with names in columns and rows.
entered all that in , but need to choose gridlines . cant find where to
activate them.
2) exel wants to put a page break on my page. dont want any page break on
this page.
3) put header title and footer (page number). excel puts page number at top
also. do not want page number at top; bottom only. what to do.




All times are GMT +1. The time now is 05:15 AM.

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