Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding files in the same spreadsheet
Hi Everyone,
I had a spreadsheet of year 2006 and I want to continue to use it in year 2007. I want to hide the figure of year 2006, I mean when I open the file only the year 2007 figure will appear in the spreadsheet. Other things If the auditor need to see the figure of 2006 in anytime I can open it or view the figures. Is there anyways and how? pls thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding files in the same spreadsheet
Hi Mike
Assuming the 2006 information is on a separate Sheet within the Workbook form the sheet with your 2007 data, whilst on the 2006 sheet, choose FormatSheetHide. When you wish to see it again, choose FormatsheetUnhide and select the sheet. If the data relating to 2006 was in say rows 2 to 1000, and your 2007 data started in row 1001, select rows 2:1000 and FormatRowsHide -- Regards Roger Govier "mike" wrote in message ... Hi Everyone, I had a spreadsheet of year 2006 and I want to continue to use it in year 2007. I want to hide the figure of year 2006, I mean when I open the file only the year 2007 figure will appear in the spreadsheet. Other things If the auditor need to see the figure of 2006 in anytime I can open it or view the figures. Is there anyways and how? pls thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding files in the same spreadsheet
Roger,
Thanks so much I got it. mike "Roger Govier" wrote: Hi Mike Assuming the 2006 information is on a separate Sheet within the Workbook form the sheet with your 2007 data, whilst on the 2006 sheet, choose FormatSheetHide. When you wish to see it again, choose FormatsheetUnhide and select the sheet. If the data relating to 2006 was in say rows 2 to 1000, and your 2007 data started in row 1001, select rows 2:1000 and FormatRowsHide -- Regards Roger Govier "mike" wrote in message ... Hi Everyone, I had a spreadsheet of year 2006 and I want to continue to use it in year 2007. I want to hide the figure of year 2006, I mean when I open the file only the year 2007 figure will appear in the spreadsheet. Other things If the auditor need to see the figure of 2006 in anytime I can open it or view the figures. Is there anyways and how? pls thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! Transfering files to Excel | Excel Worksheet Functions | |||
merge csv files into spreadsheet | Excel Discussion (Misc queries) | |||
How to hyperlink pdf files in excel spreadsheet | Excel Discussion (Misc queries) | |||
creating multiple files from a spreadsheet | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |