How can I jump to an excel worksheet within a workbook?
Q. I have a large Excel workbook. On the first worksheet I list all of my tabs (along with some information). I want to be able to click on a cell (say B1 holds the text Jan) and go to the Jan worksheet in the same workbook.
Asked by vzcowgirl - Sun Jan 13 10:36:25 2008 - - 3 Answers - 0 Comments
A. It's easy enough to do. Highlight the cell that you want to be a link to a different worksheet. Hit Ctrl + K (insert hyperlink). In the "Link to:" section, click on the "Place in this document" button. From here you can set which worksheet to link to. Hope this helps
Answered by SharksRule - Sun Jan 13 10:48:25 2008
Q. I have a large Excel workbook. On the first worksheet I list all of my tabs (along with some information). I want to be able to click on a cell (say B1 holds the text Jan) and go to the Jan worksheet in the same workbook.
Asked by vzcowgirl - Sun Jan 13 10:36:25 2008 - - 3 Answers - 0 Comments
A. It's easy enough to do. Highlight the cell that you want to be a link to a different worksheet. Hit Ctrl + K (insert hyperlink). In the "Link to:" section, click on the "Place in this document" button. From here you can set which worksheet to link to. Hope this helps
Answered by SharksRule - Sun Jan 13 10:48:25 2008
How come my arrow keys no longer work to move cells in an excel worksheet?
Q. I used to be able to press the up, down, left, and right arrows in order to navigate individual cells in an Microsoft Excel worksheet. Now, however, the arrow keys merely move my view of the worksheet; the highlighted cell remains static. Any ideas? Thanks.
Asked by yeroc - Fri Oct 23 13:36:05 2009 - - 2 Answers - 0 Comments
A. You probably accidentally hit the "Scroll Lock" key on you keyboard. Try turning it off.
Answered by jdrumming - Fri Oct 23 13:43:40 2009
Q. I used to be able to press the up, down, left, and right arrows in order to navigate individual cells in an Microsoft Excel worksheet. Now, however, the arrow keys merely move my view of the worksheet; the highlighted cell remains static. Any ideas? Thanks.
Asked by yeroc - Fri Oct 23 13:36:05 2009 - - 2 Answers - 0 Comments
A. You probably accidentally hit the "Scroll Lock" key on you keyboard. Try turning it off.
Answered by jdrumming - Fri Oct 23 13:43:40 2009
How can I unprotect an Excel worksheet without the password?
Q. I need to modify a document in Excel but lost the password that is required to unprotect the worksheet so I can edit it. Is there any way to override the protection or at least copy and paste all the contents into a new blank worksheet? It will not allow me to copy any part of the worksheet whatsoever.
Asked by saraalyson06 - Thu Feb 5 20:36:03 2009 - - 2 Answers - 0 Comments
A. One way I open the protected sheets (And password forgotten) is to copy entire sheet and paste the entire sheet in a new sheet or new workbook. This generally works
Answered by enLightened1 - Sun Feb 8 11:25:02 2009
Q. I need to modify a document in Excel but lost the password that is required to unprotect the worksheet so I can edit it. Is there any way to override the protection or at least copy and paste all the contents into a new blank worksheet? It will not allow me to copy any part of the worksheet whatsoever.
Asked by saraalyson06 - Thu Feb 5 20:36:03 2009 - - 2 Answers - 0 Comments
A. One way I open the protected sheets (And password forgotten) is to copy entire sheet and paste the entire sheet in a new sheet or new workbook. This generally works
Answered by enLightened1 - Sun Feb 8 11:25:02 2009
How do you plug a real time stock price into a Microsoft Excel worksheet?
Q. I have my stocks listed in the excel program but I don't like updating them by hand. I would rather enter a formula so that the worksheet gets updated automatically. Is there anyway to do that?
Asked by STL Biker - Thu Aug 13 09:36:01 2009 - - 1 Answers - 0 Comments
A. This can be done by linking to an external data source. The link below offers step by step advice on how to link it to Yahoo's Finance site. It doesn't mention that you can have it auto update every 1 minute by right click the data selecting data range properties and editing the refresh control. Using that method the quickest it can refresh is every 1 minute. If you need it quicker than that you can record a macro and the following line of code to the end: Application.OnTime Now + TimeValue("00:00:01"), "Refresh" Where Refresh is the name of your Macro This will refresh every 1 second (change 00:00:00 part for any time in hours minutes and seconds.
Answered by Porl_11 - Thu Aug 13 09:52:05 2009
Q. I have my stocks listed in the excel program but I don't like updating them by hand. I would rather enter a formula so that the worksheet gets updated automatically. Is there anyway to do that?
Asked by STL Biker - Thu Aug 13 09:36:01 2009 - - 1 Answers - 0 Comments
A. This can be done by linking to an external data source. The link below offers step by step advice on how to link it to Yahoo's Finance site. It doesn't mention that you can have it auto update every 1 minute by right click the data selecting data range properties and editing the refresh control. Using that method the quickest it can refresh is every 1 minute. If you need it quicker than that you can record a macro and the following line of code to the end: Application.OnTime Now + TimeValue("00:00:01"), "Refresh" Where Refresh is the name of your Macro This will refresh every 1 second (change 00:00:00 part for any time in hours minutes and seconds.
Answered by Porl_11 - Thu Aug 13 09:52:05 2009
How to create a consolidated excel worksheet?
Q. I have 5 data sheets in one excel document, now I need to create a consolidated worksheet that summarizes the data grids from 5 sheets. How do I do it? step-by step instructions please. thanks so much
Asked by Lora - Thu Jul 17 17:26:17 2008 - - 1 Answers - 0 Comments
A. On your summary sheet, to show the total of whatever is in cell A1 on all your sheets, type this into a cell (change sheet names as necessary): ='Sheet 1'!A1 + 'Sheet 2'!A1 + 'Sheet 3'!A1 + 'Sheet 4'!A1 + 'Sheet 5'!A1 Another way to do this is: =SUM('Sheet 1:Sheet 5'!A1) This will add all the data in cell A1 from each sheet that is arranged between sheet 1 and sheet 5. (i.e if you have the sheet-tabs arranged: sheet1, sheet3, sheet5, sheet2, sheet4, then this formula will only total sheet1, sheet3, and sheet5.) To show the total of column B1:B5 from sheet1: =SUM('sheet1'!B1:B5) If that doesn't completely answer your question, just add more details.
Answered by Sarah M - Fri Jul 18 13:18:44 2008
Q. I have 5 data sheets in one excel document, now I need to create a consolidated worksheet that summarizes the data grids from 5 sheets. How do I do it? step-by step instructions please. thanks so much
Asked by Lora - Thu Jul 17 17:26:17 2008 - - 1 Answers - 0 Comments
A. On your summary sheet, to show the total of whatever is in cell A1 on all your sheets, type this into a cell (change sheet names as necessary): ='Sheet 1'!A1 + 'Sheet 2'!A1 + 'Sheet 3'!A1 + 'Sheet 4'!A1 + 'Sheet 5'!A1 Another way to do this is: =SUM('Sheet 1:Sheet 5'!A1) This will add all the data in cell A1 from each sheet that is arranged between sheet 1 and sheet 5. (i.e if you have the sheet-tabs arranged: sheet1, sheet3, sheet5, sheet2, sheet4, then this formula will only total sheet1, sheet3, and sheet5.) To show the total of column B1:B5 from sheet1: =SUM('sheet1'!B1:B5) If that doesn't completely answer your question, just add more details.
Answered by Sarah M - Fri Jul 18 13:18:44 2008
How can I have my web page auto-update when I change something in an Excel worksheet?
Q. I want to be able to link an excel worksheet with my web page so that when I update something in excel it automatically updates my web page.
Asked by John - Thu Aug 27 14:41:27 2009 - - 1 Answers - 0 Comments
A. By having Microsoft ASP and using Microsoft IIS server. But you may not have those available to you, unless you are running in a large corporate environment. Or you could use Microsoft Office Live, and have your Excel workbook online and available from most any Internet access: .
Answered by MaryettaC - Thu Sep 3 15:51:20 2009
Q. I want to be able to link an excel worksheet with my web page so that when I update something in excel it automatically updates my web page.
Asked by John - Thu Aug 27 14:41:27 2009 - - 1 Answers - 0 Comments
A. By having Microsoft ASP and using Microsoft IIS server. But you may not have those available to you, unless you are running in a large corporate environment. Or you could use Microsoft Office Live, and have your Excel workbook online and available from most any Internet access: .
Answered by MaryettaC - Thu Sep 3 15:51:20 2009
How do you make the sheet name appear automatically in a cell in an excel worksheet?
Q. There is a way to make the name of the sheet appear in the header. What I would like to see is the name of the sheet automatically appear somewhere within the worksheet itself. I plan to use this as a template such that there will be worksheets with different names in the future. How can one make the sheet name appear automatically in a particular cell in an excel worksheet?
Asked by homerds - Mon Jul 21 20:59:59 2008 - - 2 Answers - 0 Comments
A. copy&paste this formula =MID(CELL("filename"), FIND("]",CELL("filename") )+1,255) you can do much more (filename, filepath)...see source.
Answered by expletive_xom - Mon Jul 21 21:29:38 2008
Q. There is a way to make the name of the sheet appear in the header. What I would like to see is the name of the sheet automatically appear somewhere within the worksheet itself. I plan to use this as a template such that there will be worksheets with different names in the future. How can one make the sheet name appear automatically in a particular cell in an excel worksheet?
Asked by homerds - Mon Jul 21 20:59:59 2008 - - 2 Answers - 0 Comments
A. copy&paste this formula =MID(CELL("filename"), FIND("]",CELL("filename") )+1,255) you can do much more (filename, filepath)...see source.
Answered by expletive_xom - Mon Jul 21 21:29:38 2008
Copying excel worksheet into powerpoint - how do I keep the formatting?
Q. I am copying a section of an excel worksheet into a powerpoint presentation. When I paste it, all the bold fonts go to regular. I have tried all of the paste special options, and while pasting as a picture does work, it also makes the fonts a bit fuzzy. Any ideas here? (Microsoft Help was not quite as helpful as I'd hoped!) Thanks!
Asked by PopcornJones - Wed Jul 23 11:21:21 2008 - - 3 Answers - 0 Comments
A. Mine is working fine. Highlight your excel spreadsheet using your mouse. Make sure you use your mouse right click, select copy. And then move over to PowerPoint, right click, select paste - see what happens. ***Go to Tools - Options - Edit. make sure your "use smart cut and paste" is selected Also check what you have for "new charts take on PowerPoint fonts". Are you coping a chart??
Answered by NacMac - Wed Jul 23 11:26:16 2008
Q. I am copying a section of an excel worksheet into a powerpoint presentation. When I paste it, all the bold fonts go to regular. I have tried all of the paste special options, and while pasting as a picture does work, it also makes the fonts a bit fuzzy. Any ideas here? (Microsoft Help was not quite as helpful as I'd hoped!) Thanks!
Asked by PopcornJones - Wed Jul 23 11:21:21 2008 - - 3 Answers - 0 Comments
A. Mine is working fine. Highlight your excel spreadsheet using your mouse. Make sure you use your mouse right click, select copy. And then move over to PowerPoint, right click, select paste - see what happens. ***Go to Tools - Options - Edit. make sure your "use smart cut and paste" is selected Also check what you have for "new charts take on PowerPoint fonts". Are you coping a chart??
Answered by NacMac - Wed Jul 23 11:26:16 2008
how can i merge excel worksheets into one master worksheet?
Q. I have an excel file with multiple worksheets. I want to take all the data from each worksheet and copy it into a master. I have tried using the consolidate feature but it doesnt work or I am not doing it correctly. There are no more than 5 columns with data but some rows do not use all 5 columns and that is ok since i will edit it later. I just simply want to merge all the data so i dont have to edit each worksheet.
Asked by hawkeye - Wed Jul 16 19:20:54 2008 - - 3 Answers - 0 Comments
A. CHANGED 7/18/7 The code below will sequentially merge all existing worksheets (except the first) into the first worksheet. If the fourth line is uncommented, then a new first sheet is added before the merge starts. The value for sRANGE must be set to include the maximum number of rows on any worksheet and the maximum number of columns on any worksheet. Blank rows with no merged cells are excluded from the results but could easily be included by changing [If bRowWasNotBlank Then iTargetRow = iTargetRow + 1] to [iTargetRow = iTargetRow + 1]. The remaining code related to bRowWasNotBlank could be removed also if blank rows will always be included in merge results. Merged cells are maintained as such. If there will never be any merged… [cont.]
Answered by Gary E - Thu Jul 17 12:58:27 2008
Q. I have an excel file with multiple worksheets. I want to take all the data from each worksheet and copy it into a master. I have tried using the consolidate feature but it doesnt work or I am not doing it correctly. There are no more than 5 columns with data but some rows do not use all 5 columns and that is ok since i will edit it later. I just simply want to merge all the data so i dont have to edit each worksheet.
Asked by hawkeye - Wed Jul 16 19:20:54 2008 - - 3 Answers - 0 Comments
A. CHANGED 7/18/7 The code below will sequentially merge all existing worksheets (except the first) into the first worksheet. If the fourth line is uncommented, then a new first sheet is added before the merge starts. The value for sRANGE must be set to include the maximum number of rows on any worksheet and the maximum number of columns on any worksheet. Blank rows with no merged cells are excluded from the results but could easily be included by changing [If bRowWasNotBlank Then iTargetRow = iTargetRow + 1] to [iTargetRow = iTargetRow + 1]. The remaining code related to bRowWasNotBlank could be removed also if blank rows will always be included in merge results. Merged cells are maintained as such. If there will never be any merged… [cont.]
Answered by Gary E - Thu Jul 17 12:58:27 2008
How to lock certain column of Excel worksheet to prevent edit while other columns free for edit.?
Q. How to lock certain column of Excel worksheet to prevent edit while other columns free for edit. I am actually making auto calculator program, while user only can key in number in the variable column, where the result column with formular cannot edit
Asked by da_bsg - Tue Apr 28 23:20:06 2009 - - 3 Answers - 0 Comments
A. Check -I don't want to retype -Thiru
Answered by Thiru - Tue Apr 28 23:24:05 2009
Q. How to lock certain column of Excel worksheet to prevent edit while other columns free for edit. I am actually making auto calculator program, while user only can key in number in the variable column, where the result column with formular cannot edit
Asked by da_bsg - Tue Apr 28 23:20:06 2009 - - 3 Answers - 0 Comments
A. Check -I don't want to retype -Thiru
Answered by Thiru - Tue Apr 28 23:24:05 2009
How do I email the current Excel worksheet (only the worksheet, not the whole book) as PDF?
Q. Whenever I try to email a worksheet in Excel 2007 as PDF, I keep getting the entire workbook as PDF.
Asked by Dazed and Confused - Sun Aug 2 02:28:57 2009 - - 3 Answers - 0 Comments
A. I think you can this method. If you want to email the excel file as PDF, First you can convert your Excel to PDF: This Execl to PDF converter can select the worksheet you want to convert, download a free trial version from here: After email, if you want read the file as Excel, you can convert it to PDF back. Hope helps!
Answered by Spring Z - Wed Aug 5 22:06:27 2009
Q. Whenever I try to email a worksheet in Excel 2007 as PDF, I keep getting the entire workbook as PDF.
Asked by Dazed and Confused - Sun Aug 2 02:28:57 2009 - - 3 Answers - 0 Comments
A. I think you can this method. If you want to email the excel file as PDF, First you can convert your Excel to PDF: This Execl to PDF converter can select the worksheet you want to convert, download a free trial version from here: After email, if you want read the file as Excel, you can convert it to PDF back. Hope helps!
Answered by Spring Z - Wed Aug 5 22:06:27 2009
Is there some way to toggle between tabs in an Excel worksheet?
Q. I am working in an Excel sheet with 10 tabs and its a pain to move my hands from the keyboard to the mouse whenever I have to refer to another tab.. It would be great if someone could tell me a keyboard shortcut to toggle between these tabs in an Excel Worksheet(I am using Office 2007)
Asked by Sameer - Wed Apr 23 14:12:25 2008 - - 2 Answers - 1 Comments
A. Yes - try Ctrl + Page up Ctrl + Page Down This will take you to the next or previous tab
Answered by Eric K - Wed Apr 23 14:22:38 2008
Q. I am working in an Excel sheet with 10 tabs and its a pain to move my hands from the keyboard to the mouse whenever I have to refer to another tab.. It would be great if someone could tell me a keyboard shortcut to toggle between these tabs in an Excel Worksheet(I am using Office 2007)
Asked by Sameer - Wed Apr 23 14:12:25 2008 - - 2 Answers - 1 Comments
A. Yes - try Ctrl + Page up Ctrl + Page Down This will take you to the next or previous tab
Answered by Eric K - Wed Apr 23 14:22:38 2008
How do you show math work on an excel worksheet?
Q. For my technology classwork i have to show my work on the excel worksheet. So he wants me to show the work while i am answering questions...how do i show the work in a "cell???" help i get in big trouble if i fail!!!
Asked by Cutedevil333 - Mon Sep 3 11:22:35 2007 - - 2 Answers - 0 Comments
A. Assuming you want to show both the results, and how you got them, at the same time, I would do this: In one column (let's say A), have the calculations that get the answers In an adjacent column (let's say B), show the formulas that are in column A. The way to do this is to go into each formula in A as if you're editing it, - select the whole formula, starting with the = - Edit - copy - go the adjacent cell where you want to show the work, and edit-paste - put a ' before the = so that it's treated as text instead of a formula. You should probably wait and do this at the end, when you're happy with all of your answers, because if you change any formulas, you would have to remember to also change the cells next to them that show the work.… [cont.]
Answered by schmenkman - Tue Sep 4 16:15:16 2007
Q. For my technology classwork i have to show my work on the excel worksheet. So he wants me to show the work while i am answering questions...how do i show the work in a "cell???" help i get in big trouble if i fail!!!
Asked by Cutedevil333 - Mon Sep 3 11:22:35 2007 - - 2 Answers - 0 Comments
A. Assuming you want to show both the results, and how you got them, at the same time, I would do this: In one column (let's say A), have the calculations that get the answers In an adjacent column (let's say B), show the formulas that are in column A. The way to do this is to go into each formula in A as if you're editing it, - select the whole formula, starting with the = - Edit - copy - go the adjacent cell where you want to show the work, and edit-paste - put a ' before the = so that it's treated as text instead of a formula. You should probably wait and do this at the end, when you're happy with all of your answers, because if you change any formulas, you would have to remember to also change the cells next to them that show the work.… [cont.]
Answered by schmenkman - Tue Sep 4 16:15:16 2007
Adding Date and Time to an Excel worksheet?
Q. Hello! How can I add the date and time to an Excel worksheet as a macro without the cursor moving to another cell? I know how to use the Ctrl+; and space and then Ctrl+Shift+; to add the date, but when I do it as a macro it goes either to the left, right or back to the beginning of a row. Thank you all for your help.
Asked by nyclastof9 - Fri Jul 11 13:06:31 2008 - - 2 Answers - 0 Comments
A. The following macro will enter the current date and time in the active cell without moving the cursor. The date and time will be entered as a datevalue, meaning that it will not change every time you open the workbook. Open your workbook Copy this macro to the clipboard Sub Set_DateTime() ActiveCell.Value = Format(Now(), "m/dd/yyy h:mmAM/PM") End Sub Next press ALT + F11 Insert > Module Paste the macro into the Module area to the right Close the VBE and return to Excel Click Tools > Macro > Macros Click 'Options' Enter the letter you wish to use as a keyboard shortcut. I usually use 'a' because it is close to the Ctrl key. Close back to Excel Now, when you press Ctrl + a (or whatever letter you chose) the date and time… [cont.]
Answered by garbo7441 - Fri Jul 11 17:26:47 2008
Q. Hello! How can I add the date and time to an Excel worksheet as a macro without the cursor moving to another cell? I know how to use the Ctrl+; and space and then Ctrl+Shift+; to add the date, but when I do it as a macro it goes either to the left, right or back to the beginning of a row. Thank you all for your help.
Asked by nyclastof9 - Fri Jul 11 13:06:31 2008 - - 2 Answers - 0 Comments
A. The following macro will enter the current date and time in the active cell without moving the cursor. The date and time will be entered as a datevalue, meaning that it will not change every time you open the workbook. Open your workbook Copy this macro to the clipboard Sub Set_DateTime() ActiveCell.Value = Format(Now(), "m/dd/yyy h:mmAM/PM") End Sub Next press ALT + F11 Insert > Module Paste the macro into the Module area to the right Close the VBE and return to Excel Click Tools > Macro > Macros Click 'Options' Enter the letter you wish to use as a keyboard shortcut. I usually use 'a' because it is close to the Ctrl key. Close back to Excel Now, when you press Ctrl + a (or whatever letter you chose) the date and time… [cont.]
Answered by garbo7441 - Fri Jul 11 17:26:47 2008
Excel worksheet to calculate heat loss from home?
Q. I am considering replacing single glass windows to double glazing but can seem to be able to calculate the current heat loss rate from current windows, walls, and ceiling. Anyone have a worksheet with common heatloss factors for windows, walls etc?
Asked by Fredrik - Sun Oct 15 08:56:05 2006 - - 1 Answers - 0 Comments
A. hvac dealers will have a worksheet to calculate heat loss/gain you might have to pay for the service unless you are looking to replace the furnace/ac
Answered by hillbilly named Possum - Sun Oct 15 10:04:17 2006
Q. I am considering replacing single glass windows to double glazing but can seem to be able to calculate the current heat loss rate from current windows, walls, and ceiling. Anyone have a worksheet with common heatloss factors for windows, walls etc?
Asked by Fredrik - Sun Oct 15 08:56:05 2006 - - 1 Answers - 0 Comments
A. hvac dealers will have a worksheet to calculate heat loss/gain you might have to pay for the service unless you are looking to replace the furnace/ac
Answered by hillbilly named Possum - Sun Oct 15 10:04:17 2006
Renaming an excel worksheet with a date?
Q. I would like to write a macro which would insert a worksheet with a date value (current month and year for example) into an excel workbook Is this possible? Many Thanks
Asked by Hayley p - Tue Jan 6 10:34:53 2009 - - 2 Answers - 0 Comments
A. T omake it more flexible why not refer to the active sheet rather than sheet 1 sub Macro1() ' ' Macro1 Macro ' Macro recorded 06/01/2009 by User ' ActiveSheet.Name = Format(Now(), "dd mmm yyy") End Sub
Answered by johncaulfield100 - Tue Jan 6 16:04:56 2009
Q. I would like to write a macro which would insert a worksheet with a date value (current month and year for example) into an excel workbook Is this possible? Many Thanks
Asked by Hayley p - Tue Jan 6 10:34:53 2009 - - 2 Answers - 0 Comments
A. T omake it more flexible why not refer to the active sheet rather than sheet 1 sub Macro1() ' ' Macro1 Macro ' Macro recorded 06/01/2009 by User ' ActiveSheet.Name = Format(Now(), "dd mmm yyy") End Sub
Answered by johncaulfield100 - Tue Jan 6 16:04:56 2009
How to add an active excel worksheet into a powerpoint presentation?
Q. I have created a wheel of fortune game in a Powerpoint Presentation with a active excel score card that adds and subtracts points. How can I actively use the score card while in the middle of the presentation? please help!!!
Asked by donyelle4 - Wed Nov 12 15:40:43 2008 - - 1 Answers - 0 Comments
A. In PowerPoint, select Insert\Object Select Microsoft Excel Worksheet Position and size the worksheet Copy and paste the cells from your original worksheet to the PowerPoint worksheet.
Answered by Cozmosis - Wed Nov 12 16:53:31 2008
Q. I have created a wheel of fortune game in a Powerpoint Presentation with a active excel score card that adds and subtracts points. How can I actively use the score card while in the middle of the presentation? please help!!!
Asked by donyelle4 - Wed Nov 12 15:40:43 2008 - - 1 Answers - 0 Comments
A. In PowerPoint, select Insert\Object Select Microsoft Excel Worksheet Position and size the worksheet Copy and paste the cells from your original worksheet to the PowerPoint worksheet.
Answered by Cozmosis - Wed Nov 12 16:53:31 2008
How do I change the expiration date on an Excel worksheet?
Q. The version of this worksheet appears to have expired. I can't remember how to reset or extend the expiration date. Any help would be great!
Asked by Encuero - Sun Aug 2 14:35:01 2009 - - 1 Answers - 0 Comments
A. You did not specify what version and update level of MS-Excel you are using. More than likely, some VBA code has been added to that workbook which is testing the current computer date against what it thinks the expiration date should be. You can either modify the macro coding to have another date value, or reset your computer's date to something in the past. .
Answered by MaryettaC - Wed Aug 5 17:28:28 2009
Q. The version of this worksheet appears to have expired. I can't remember how to reset or extend the expiration date. Any help would be great!
Asked by Encuero - Sun Aug 2 14:35:01 2009 - - 1 Answers - 0 Comments
A. You did not specify what version and update level of MS-Excel you are using. More than likely, some VBA code has been added to that workbook which is testing the current computer date against what it thinks the expiration date should be. You can either modify the macro coding to have another date value, or reset your computer's date to something in the past. .
Answered by MaryettaC - Wed Aug 5 17:28:28 2009
How can send the chart of accounts from Quickbooks 2007 to an excel worksheet?
Q. I need to reformat the style and layout of the chart of accounts from my quickbooks program. How can I export it to excel? (I need step by step) The typical method that I use for exporting reports doesn't work.
Asked by Brandon F - Fri Dec 21 09:04:48 2007 - - 1 Answers - 0 Comments
A. I'm not sure what exactly you don't like about the typical method of reporting, here's what i normally do. 1. ctrl+a to open chart of account 2. click reports button and choose account listing 3. when the report is showing, click modify report, that's where you change the layout of the data, when done with layout editing, click excel button then click ok, then a worksheet will pop up. if you want to change the presentation style of the data, change it on the spreadsheet, its more versatile to use excel on changing the visual side of the report. Hope this helps.
Answered by AQuestionMark - Fri Dec 21 23:50:11 2007
Q. I need to reformat the style and layout of the chart of accounts from my quickbooks program. How can I export it to excel? (I need step by step) The typical method that I use for exporting reports doesn't work.
Asked by Brandon F - Fri Dec 21 09:04:48 2007 - - 1 Answers - 0 Comments
A. I'm not sure what exactly you don't like about the typical method of reporting, here's what i normally do. 1. ctrl+a to open chart of account 2. click reports button and choose account listing 3. when the report is showing, click modify report, that's where you change the layout of the data, when done with layout editing, click excel button then click ok, then a worksheet will pop up. if you want to change the presentation style of the data, change it on the spreadsheet, its more versatile to use excel on changing the visual side of the report. Hope this helps.
Answered by AQuestionMark - Fri Dec 21 23:50:11 2007
How to use/function protected password on Excel Worksheet in Window Mobiles 6.1? ?
Q. It seems that the new version 6.1 for mobile is lacking the most important issues of all (Business security) Recently bought Samsung Omnia and noticed that the excel sheet cannot be password proteceted like older version of office mobile!! Any help and suggestions will be very much appreciated.
Asked by suthee_16 - Thu Nov 6 04:49:55 2008 - - 1 Answers - 0 Comments
A. Softmaker Office 2008 is the only way I know of doing this...
Answered by excelyogi - Thu Nov 6 16:17:25 2008
Q. It seems that the new version 6.1 for mobile is lacking the most important issues of all (Business security) Recently bought Samsung Omnia and noticed that the excel sheet cannot be password proteceted like older version of office mobile!! Any help and suggestions will be very much appreciated.
Asked by suthee_16 - Thu Nov 6 04:49:55 2008 - - 1 Answers - 0 Comments
A. Softmaker Office 2008 is the only way I know of doing this...
Answered by excelyogi - Thu Nov 6 16:17:25 2008
From Yahoo Answer Search: 'excel worksheet'
Mon Nov 9 00:49:18 2009 [ refresh local cache ]
