User`s Manual - University of Wisconsin Oshkosh
Contents
1. Cancel Modify I Alignment General Bottom Aligned Hoi v Font Arial 10 Add v Border Mo Borders M Patterns Mo Shading IW Protection Locked Style dialog box 3 Either accept the Normal default style or select a new style 4 Inthe Style dialog box click OK to apply the style To modify a style 1 Choose Format Style to open the Style dialog box Either accept the Normal default style or select the style you want to modify Click Modify to open the Format Cells dialog box In the Format Cells dialog box make modifications you want and then click OK In the Style dialog box click OK to apply the style Ce E 17 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Formatting Worksheet Tabs To change the name of a worksheet tab 1 Select the worksheet you want to change 2 You have three options for how to rename a worksheet e Choose Format Sheet Rename Format Tools Data Window Help Adobe PDF HT Cells Ctrl 1 C Q E Row gt 5 To 0 Column k Rename GukoFormat Hide Conditional Formatting Style Background Tab color Formatting Worksheet Tabs e Right click the sheet tab and choose Rename e Double click the tab To change the color of a worksheet tab 1 Select the worksheet you want to change 2 You have two options for how to change the color of a worksheet tab e Right click the sheet tab and choose T2. Excel 2003 Formatting amp Printing Spreadsheets Customizing Your Screen Layout User s Manual University of Wisconsin Oshkosh Division of Information Technology Judy Chartre September 2006 CHANGE FON PTY PE AND SIE ccuire ernia 1 ADDING BORDERS AND COLOR 6ivsiscccsscscsssssesecceassocssenessssossssscsssccdecosessnscccsecsscesessens 3 CHANGING COLUMN WIDTH AND ROW HEIGHT ee eeee eene ene 6 MERGE 60 B9 P c M 11 APPLYING NUMBER FORMA TS onairea aaas 11 ALIGNING CBLLC ON LEN DS 5 cssssosseasaesessssstesessannvadsssssessessobosseassiesessessseseasaneseens 12 FIND AND REPLACE FORMA S ccsssosessessstssssssssessesscasessssssusensoctessssusoussenveusessesssveveese 14 AU POP ORIVIA TD er 15 DS DV PO 17 FORMATTING WORKSHEET TABS cccsccssscccrccccccsccccsccrccsessssccccsssccesseees 18 REPOSITION WORKSHEETS IN A WORKBOOK osssooessssssoeessssososeseossosessesooe 19 INSERT AND DELETE WORKSHEETS ccccccsssccccsscscccscscssscccsscssscscssssccees 19 COPY AND PAS LE WORKSHEETS ciccssesccsscssseassesoscesscssnabeaases setaressarssnsssvecsesssaesesesss 20 COPY A WORKBOOK Ceo aS 20 v Ud M PIRUN DU M BEI teet 20 CREATE A HEADER AND A FOOTER
3. Find What line click the Format button to open the Find Format dialog box Number Alignment Font Border Patterns Protection Category General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom General Farmat cells have na specific number Format Find Format dialog box 14 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 4 Inthe Find Format dialog box select the format you want to find in the workbook 5 Click OK to return to the Find and Replace dialog box 6 On the Replace With line click the Format button to open the Replace Format dialog box Alignment Font Border Patterns Protection Category MEn General Format cells have no specific number Format Choose Format From Cell Cancel Replace Format dialog box 7 Inthe Replace Format dialog box select or create the new format you want to apply to the workbook Click OK to return to the Find and Replace dialog box 9 Inthe Find and Replace dialog box click Find Next to locate the first occurrence of the existing format 10 In the Find and Replace dialog box click Replace or Replace All to replace the old format with the new format 11 Click OK to confirm the replacements 12 Close the Find and Replace dialog box a AutoFormat AutoFormat is a predefined group of formats that you can apply to a range of data that includ
4. Format Unhide Conditional Formatting Style Format Tools Data Window Help Adobe POF f cells Ctrl 1 Row Sheet GuboFit Selection AutoFarmat Hide Conditional Formatting Unhide Style Standard width Hint You can access the Hide and Unhide commands by right clicking your mouse after rows or columns have been selected 10 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Merge Cells The Merge Cells command allows you to more easily manage ranges of cells by combining them into one larger cell without affecting other cells in the same column To merge cells 1 Select the range of cells you want to merge 2 Ifyou know you want to merge and center the contents of the selected cells click the Merge and Center button otherwise select Format Cells to open the Format Cells dialog box 3 Select the Alignment tab and check the Merge Cells box Text alignment Horizontal General Indent vertical g Bottom z Justify distributed Text control wrap kext Shrink to Fit lo Degrees Merge cells Right bo lert Text direction Context bul ome 4 Click OK to merge the cells Hint Right click your mouse to access the Format Cells dialog box Applying Number Formats You can apply a number format to cells before or after you enter the numerical data A number format forces the data in a cell to display i
5. In the column heading row point your cursor at the line between the column you want to change and the adjacent column Your cursor will look like this F amp G Cursor 2 Drag to the left or right to adjust the column width as desired HINT If you want Excel to automatically adjust the width to the necessary size of data point your cursor at the line between the column you want to change and the adjacent column and double click your mouse To change column width by selecting the column 1 Select the column you want to change 2 Choose Format Column Width to open the Column Width dialog box x Column width 8 43 Cancel 3 Inthe Column Width field enter a new value for the column width 4 Click OK to change the column width HINT You can right click your mouse and choose Column Width to open the dialog box too Cue Copy Paste Paste Special Insert Delete Clear Contents Format Cells Column Width Hide Unhide Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 To change row height by dragging row boundaries The default row height is 12 75 points 1 point 1 72 inch 1 In the row heading column point your cursor to the line between the row you want to change and the adjacent row Your cursor will look like this Cursor on Row 2 Drag up or down to adjust row height you need HINT If you want Excel to automatic
6. ab Color e Choose Format Sheet Tab Color 3 Select the color from the Format Tab Color dialog box Format Tab Color X Tab calor 4 Click OK to apply color 18 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Reposition Worksheets in a Workbook Reposition worksheets by dragging 1 Click and hold the tab of the worksheet you want to move 2 Drag the worksheet tab to its new position 3 Release the mouse button Reposition worksheets by using the Move or Copy command 1 Select the worksheet you want to move 2 Choose Edit Move or Copy to open the Move or Copy dialog box Move or Copy X Move selected sheets To book Booki Before sheet Sheet Create a copy Cancel Hint Right click the sheet tab and choose Move or Copy 3 From the To book list select the workbook you want to copy the worksheet to 4 From the Before sheet list select the worksheet you want the worksheet you are moving to appear before or to the left of 5 Click OK Insert and Delete Worksheets Inserting and deleting worksheets helps you organize by consolidating related data within and removing extraneous data from your workbooks To delete a worksheet from a workbook 1 Select an existing worksheet 2 Choose Edit Delete Sheet to delete the selected worksheet Hint A quicker way ts to right click on the sheet tab and select Delete To insert a workshee
7. age Breaks You can use Page Breaks if your spreadsheet data is too large to fit on one page either vertically or horizontally To insert a page break 1 Select the row or column that will be the first row or column on the new page 2 From the Insert menu select Page Break To remove a page break 1 Select the row immediately below the page break or the column immediately to the right of the page break 2 From the Insert menu select Remove Page Break Print a Range You may have occasion where you only want to print a specific portion of your worksheet and not the entire worksheet To print a range 1 Select the range of cells you want to print 29 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 2 Choose File Print 3 Under Print What select Selection 4 Click OK to print the range rinker Name gag hp LaserJet 1012 TEN Status Idle mm Type hp LaserJet 1012 ind Printer where DOT4 001 Comment Print to File rint range 4 Opies fe al Number of copies 1 ES Page s Erom le zi rink what y p collate Selection Entire workbook C Active sheet s SEE Preview Cancel Split a Worksheet This is one of several ways you can view data in your worksheet especially if you have several rows and or several columns of data To split a workshe
8. ally adjust the height to the necessary size of data point your cursor at the line between the row you want to change and the adjacent row and double click your mouse To change row height by selecting the row 1 Select the row you want to change 2 Choose Format 5Row Height to open the Row Height dialog box Row height 275 ca Row Height dialog box 3 In the Row Height field enter a new value for the row height 4 Click OK to change the row height HINT You can right click your mouse and choose Row Height to open the dialog box too Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Cue Copy Paste Paste Special Insert Delete Clear Contents Format Cells Raw Height Hide Unhide B now Right Click Options The Hide and Unhide commands The Hide command allows you to hide any row s or column s in a worksheet The rows and columns still exist and data is included in any formulas you may write The Unhide command makes the rows and columns visible again The Hide and Unhide commands do not apply to cells only rows and columns 1 Select the rows or columns you wish to hide or unhide Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 2 Choose Format Row or Column Hide or Unhide Format Tools Data Window Help Adobe PDF a cells Ctrl 1 Row Column AutoFit Sheet Hide uto
9. ccce eene ee eee ee eene eee eee tette eee iienaa 21 SEI PAGE MARGINS erener iriri ee ia be kara XE rao EEEE Ei 22 CHANGE PAGE ORIENTATION scsasccssssssissscsssscstsdsssseccsestacssassssestonssaceadesssssssvotaceasaes 23 INSERT AND REMOVE PAGE BREAKS oeseeeeesssssssssssssssoooocscsccccssssesesssssoocssseseeseseee 23 IRENA A RANGE cicseccescctsscstisseccsnsestassdicsnocsesosdassseeseassesesseatsucsuassbeotdeguvassesessvesanevacsnsesess 23 SPLITA WORKSHEET ero 24 ARRANGE WORKSHEETS wisccssssasssostsasecnecdsansssccnsteoscsanesasssscsvoresessesessontsasesnenensseaseseare 25 FREEZE AND UNFREEZE ROWS AND COLUMNS ssososesecssssssssssssssoosoossseeseseee 25 HIDE AND UNHIDE WORKSHEETS scsscsscsscssssesssctesossssssssovscnsoesdessissedetesenssassscesesoess 26 B Technology Training Staff Judy Chartre Ph 0238 email chartre uwosh edu Sarah Bradway Ph 3334 email bradways uwosh edu Michelle Loker Ph 1154 email loker uwosh edu Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Introduction Formatting and Printing setups allow you to define specific areas of your spreadsheet and make it easier to visually locate data Change Font Type and Size The quickest way to change your font type and size are the boxes located to the far left of the Formatting toolbar 1 Select the cell s where you want to change the font type or size 2 Click on the drop down arrow to make your selections Th
10. e File menu select Page Setup and Header Footer tab or From the View menu select Header and Footer 2 Select a default header configuration or create a custom header a To use a default header configuration select a header style from the header list b Select Custom Header to open the header dialog box c Enter the new header information and format it as needed d Click OK to return to the Page Setup dialog box 3 Click OK to close the Page Setup dialog box Page Margins Header Foaker Sheet Print Print Previews Header name options Custom Header Custom Footer Footer none oT Cancel Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 4 Create a Footer following the previous instructions 5 Select File Print Preview to view your spreadsheet including Headers and Footers Or click the Print Preview button on the Standard toolbar Set Page Margins Margins determine the amount of space between the data in your worksheet and the edge of the paper There are six adjustable margins The right and left margins determine the space at the right and left edges of the paper The top and bottom margins determine the space at the top and bottom of the page The header and footer margins determine amount of space between the header or footer and the body of the worksheet To set page margins using the Page Setup Dialog box 1 From the File menu
11. e such formatting options as font size patterns and alignment To apply an AutoFormat 1 Select the range of cells that you want to apply an AutoFormat to 2 Choose Format AutoFormat to open the AutoFormat dialog box 15 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 AutoFormat E X Jan Feb Mar Total Jan Feb bir Total West amp South o 7 Total 1 185 21 Classic z Jar Feb War Total T FR SF 19 4 T 17 B T g 2d Tota 21 18 f 21 f B Accounting 1 ormats to apply v Number v Border Iw Font wv Patterns Jah Feb Mar Total Jar Feb Mar Torta Classic 3 Jan Feb Mar Total East f 7f FR 5f 13 West 5 4 T 17 south a T g 2d Total 21 158 21 B Accounting 2 v Alignment v width Height AutoFormat dialog box 3 Select the AutoFormat you want to apply 4 Click OK to apply the AutoFormat 16 OK Cancel Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Styles A Style is a collection of individual format options that you apply at the same time to selected cells You can use predefined styles or create custom styles that can include Number Border Alignment Patterns Font Protection To apply a style 1 Select the range of cells you want to apply the style to 2 Choose Format Style to open the Style dialog box Style name E o Style includes vw Number General
12. et 1 Select any cell in the center of the worksheet you want to split 2 From the Window menu select Split to add the split bars to your worksheet 3 Drag the split bars as needed to split the worksheet January February March April Window with Split 24 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Arrange Worksheets Arranging worksheets allows you to view specific elements from multiple worksheets on screen at the same time To arrange worksheets 1 From the Windows menu select New Window to open the entire workbook in a new window 2 Repeat Step 1 until you have a new window for every worksheet you want to view in the workbook 3 Choose Window Arrange to open the Arrange Window Dialog Box Arrange C Tiled C Horizontal Vertical Cascade Windows of active workbook ca 4 Select the options you want 5 Click OK A Expenses January February Office Supplies 150 Travel 87 g Printing 29 3 Worksheets Vertically Arranged Postage amp Freight 45 Telephone 120 Utilities 100 Maintenance amp Repairs 50 0 Total 581 M 4 gt M Sheet1 Sheet2 Sheet3 M 4 gt MN Sheet Sheet2 X Sheet3 Freeze and Unfreeze Rows and Columns Another way to customize your view of a worksheet 1s to force a specific row or column to always appear on screen Freezing and unfreezing rows and columns allo
13. is will only change the typeface and size of the font 3 Youcan add effects such as bold italics underscore and color from buttons located on the Formatting toolbar Other effects can be added to the Formatting toolbar 4 Youcan add effects to your font such as strike through superscript or subscript from the Format menu Format Cells Font 5 Click OK to apply the font style and size selected Number Alignment Font Border Patterns Protection Font Font style Size arial Regular E Tp ALA Courier Mew Tp ALA Lucida Sans Types i md m Underline Color None Automatic Normal Font FFecbs review w Strikethrough Superscript ABe yrs Subscript This is a TrueType Font The same Font will be used on both your printer and your screen You can also change the font type size and effects of only part of data in a cell 1 Select the cell s where you want to change the font type or size 2 Goto the Formula Bar and highlight the specific text you want to format 3 Click on the Format menu Format Cells Font 4 Click OK to apply the font style and size selected Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Hint Right click your mouse to access the Format Cells dialog box too E3 Microsoft Excel Book1 dE File Edit View Insert Format Tools Data Window Help Adobe PDF a 22 es d i Oo xj i j j la Fv Re
14. lect desired alignment option 5 Click OK to apply the alignment or bui 12 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Humber Alignment Font Border Patkerns Protection Text alignment rentation Horizontal General Indent Vertical lo Bottom w Justify distributed Text control Wrap text Shrink to Fit lo Degrees Merge cells Right to left Text direction Context w med CINE Right Indent Fill Justify Center Across Selection 13 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Find and Replace Formats You can find and replace cell formatting in the same manner as cell data To find and replace formats l 2 Find what Within Sheet Match entire cell contents Search ley Rows Formulas Replace All Replace Find All Find Mex Close Look in Choose Edit Replace to open the Find and Replace dialog box Hint Try using your Find button 5 on the Standard toolbar Click Options to expand the Find and Replace options Find Replace Mo Format Set Format M Replace with Mo Format Set Format M Match case Options lt Find and Replace Dialog Box Replace Tab 3 On the
15. ls Click OK to apply the borders Mumber Alignment Font Border Patterns Protection Presets Mane Outline Inside Border Color Automatic The selected border style can be applied by clicking the presets preview diagram or Ehe buttons above AN Border Tab dialog box Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 To add color to cells 1 Select the cell or cells you would like to add c to 2 Use one of these methods to open the Format Cells dialog box e Click on the Fill Color button e Choose Format Cells e Right click your mouse Click the Patterns tab to view options Select the fill color in the Cell Shading area 5 Click OK to apply the color Mumber Alignment Font Border Patterns Protection pel Cell shading Color BEEBE EEE Pattern ul Cancel Patterns Tabdialogbox Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 To add a background to a worksheet 1 Select the worksheet you would like to add the background to 2 Choose Format Sheet Background to open the Sheet Background dialog box 3 Navigate to the background you choose and double click it to apply the background to the worksheet Sheet Background X Laak in 4 My Computer TUSZ a FE a A A Eg Tools My Recent Documents 31 Floppy A1 Local Disk C Removable Disk D My Comp
16. n a particular layout Excel s pre installed number formats include Currency Percentage Accounting Fraction Date Scientific 11 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 To apply a number format 1 Select the cell s which you want to apply the number format 2 Choose Format Cells to open the Format Cells dialog box Hint Right click your mouse to access the Format Cells dialog box 3 Click the Number tab Alignment Font Border Patterns Protection Category Sample 75 Decimal places o Symbol Negative numbers 1 234 1 254 1 254 Currency Formats are used For general monetary values Use Accounting Formats to align decimal points in a column Format Cells dialog box Number tab 4 Select the type of number format you want from the Category box 5 Under the Sample box make selections to specify the format layout 6 Click OK to apply the format Aligning Cell Contents You can align data or cell contents in a variety of ways To align cell contents 1 Select the cell s that you want to align the contents 2 Click one of the Align buttons on the Formatting toolbar alignment select Format Cells to open the Format Cells dialog box Buttons Hint Right click your mouse to access the Format Cells dialog box Click the Alignment tab In the Text Alignment section se
17. name and location or it can be column titles Or it can be both To set a print title 1 From the File menu select Page Setup 2 Click on the Sheet tab 3 In the Print Titles area of the dialog box click the selection button to the right of the Rows To Repeat At Top text box E Your cursor will turn into a bold right arrow 4 On the spreadsheet select the rows you want to print on each page January February March 4n gr FE r Pace Setup Rows 4 Pli IT E 20 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 5 Press Enter to accept this range as your Print Title 6 Repeat the same steps to repeat columns at the left of your data por piar lbs 129 Page Setup Page Margins Header Footer Sheet Frint area Print Print titles Print Preview Rows to repeat at top B 1l s Options Columns to repeat at left s Print Gridlines Row and column headings Black and white Comments Mong Draft quality Cell errors as displayed Page order Down then over C Over then down 7 Inthe Page Setup dialog box click OK to accept the changes Create a Header and a Footer You may want certain other information such as page number date file name etc to appear at the top or bottom of each page To create a header 1 From th
18. ply with Changes End Review B amp p Snagit py window B D gg B GI IV GEIXa38 9 0C I amp x 7i Arial 10 B JI U Qs i 00 z FEE A1 X4 AR H0 ma EE Eee eo ix Fant Font Font style Size Arial reo E E El Albertus Medium F Algerian i Antique Olive Underline Color ee o automatic Normal Font rEffecks Preview Strikethrough Superscript Pa bb Ce Ywzz Iv Subscript This is a TrueType font The same Font will be used on bath your printer and your screen a P BI NH Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Adding Borders and Color Another way to make it easier to visually locate data 1s by highlighting cells with borders and color You can also apply a background to an entire worksheet A background can be a graphic such as a line drawing or photograph To add borders to cells l Useone of these methods to open the Format Cells dialog box Select the cell or cells you would like to add a border to e Click on the Borders button e Choose Format Cells e Right click your mouse Click the Border tab to view the border options select the border style from the Style list on the right side of the dialog box Select the color you want the border to be Use the preset border buttons or specific border buttons to set the border for the selected cel
19. select Page Setup and the Margins tab 2 Determine the margin values as needed 3 Click OK to apply the margins Page Setup E Page Margins Header Footer Sheet Header Print 0 5 Top z Print Preview pions Left Right lon 075 Bottom Footer E Center on page Horizontally vertically To set page margins using the Print Preview Dialog Box 1 From the File menu select Print Preview 2 Click the Margins button if necessary 3 Drag the margin guides as desired Mex previous Zoom Print Setup Page Break Preview Close Help ePIC Ee Ex pe ted Jawan Febria March orice S apples F150 kanl F5 22 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Change Page Orientation Excel has two types of page orientation Portrait data displayed vertically and Landscape data displayed horizontally To change the Page Orientation 1 From the File menu select Page Setup the Page tab 2 Select Portrait or Landscape 3 Click OK to apply the change Page Setup i Page Margins Header Fookter Sheet Orientation S o rientation Print k Ls Portrait C Landscape Mm iesu Scaling Options f Adjusktko 100 4 normal size C Fit to 1 ES page s wide by 1 Fall Paper size Letter Print quality feno dpi First page number Auto Insert and Remove P
20. t into a workbook 1 Select an existing worksheet 2 Choose Insert Worksheet to insert the new worksheet to the left of the selected worksheet Hint A quicker way is to right click on the sheet tab and select Insert 19 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Copy and Paste Worksheets Copying and Pasting worksheets eliminates the need to repeat worksheet development for worksheets that share common characteristics To copy and past worksheets 1 Select the worksheet you want to copy 2 Choose Edit Move or Copy Sheet Hint Right click the sheet tab and choose Move or Copy 3 From the To book list select which workbook you want to copy the worksheet to or accept the default 4 Check the Create a copy box 5 From the Before sheet list select which sheet you want the copied worksheet pasted in front of 6 Click OK Copy a Workbook To copy a workbook from within Excel 1 With the workbook you want to copy open in Excel hold down Shift or Ctrl and click every worksheet tab in the workbook Hint Right click any sheet tab and select Select all Sheets 2 Choose Edit Move or Copy Sheet Hint Right click sheet tab and select Move or Copy Sheet 3 Check the Create a copy box 4 From the To book list select New Book 5 Click OK Set Print Titles When printing your spreadsheets you may want a title at the top of each page This title can be a company
21. uter puptcp pw prive E DVD Drive F Shared on AdcomiSoft Hit File name trek Mw Network Places Files of type all Pictures em mf jpg jpeg fif pe png Y Fl Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Paste Special The Paste Special command allows you to specify how you would like the contents of the clipboard pasted into Excel 1 Choose Edit Paste Special or 2 Right click your mouse to access Paste Special Paste Special Paste t All C Validation C Formulas C All except borders C Values Column widths C Formats Formulas and number Formats C Comments C values and number Formats Operation Mone C Multiply C Add C Divide C Subtract Skip blanks Transpose Paste Link Cancel Paste Special dialog box Changing Column Width and Row Height Another type of formatting 1s changing the width of columns and height of rows You would change these when the data you are displaying does not appear as you want it to Some examples of this might be 7 ourrudy E NWIUITUdy ie 907654321907654 I TIU SHAY dz itiay Column Width needs to be changed Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 To change column width by dragging column boundaries The default width is 8 43 characters in standard font or 64 pixels 1
22. ws you to view specific elements of the worksheet on screen at the same time regardless of how large your worksheet is To freeze rows and columns 1 From the Window menu select Split to add split bars to the worksheet 2 Position the worksheet contents and split bars where you would like them to freeze 3 Choose Window Freeze Panes to freeze the rows and columns To unfreeze rows choose Window Unfreeze Panes to unfreeze the rows and columns 25 Formatting and Printing Spreadsheets Customizing Your Screen Layout September 2006 Hide and Unhide Worksheets You can customize your layout by controlling when worksheets appear You can Hide and Unhide worksheets This could be useful 1f your workbook contains many worksheets and you only want to view the first and last worksheets 1 Select the sheet you want to hide 2 From the Format menu select Sheet Hide To unhide worksheets 1 Choose Format Sheet Unhide to open the Unhide dialog box 2 From the Unhide Sheet box select the worksheet you want to unhide 3 Click OK These two features are also available by right clicking your mouse 26
Download Pdf Manuals
Related Search