Have a question about something in one of my Excel books? Here’s how to get the answer:
- Browse through the comments at the end of this article to see if someone else has already asked your question. You might get the answer without even asking!
- If your question is not asked (or answered), use the Leave a Comment form at the bottom of this post to enter your question. (If the form does not appear, click the Comment link below to display it.)
- Check in once in a while to see if your question is answered. I usually answer questions within 48 hours, unless I’m out of town. To have responses to your question delivered to you automatically by e-mail, along with other Q & A comments submitted for this book, turn on the Notify Me check box at the bottom of the form when submitting your question (step 2). You can unsubscribe to the notification feature at any time.
Please do not use the Contact form to ask me questions. I won’t answer them. I want the questions and answers here, where everyone can see them, so I don’t have to answer the same questions over and over again.
Remember, I can only answer questions that clarify or correct information in my books. If the answer to your question is in my book, I will provide a page number reference to help you find it.
I have Excel version 11.2.3 (2004 for MAc).
What is the correct book I should buy?
Sadly, we did not update my book for Excel 2004. The last version of my Excel for Mac book is Excel X. It’s VERY similar, but you should probably get a book that covers the version you’re using. Sorry, but I don’t have any recommendations.
I cannot get the gridlines to print on my worksheet. I have checked “gridlines ” in print options. but no luck. Any suggestions.
I need to know which version of Excel you’re using and which version of my book you’re consulting to provide assistance.
I have Microsoft Excel 2000, and my book is “Visual Quick Project – Creating Spreadsheets and Charts in Excel” copyright 2005. My question was – I cannot get the gridlines to print on my worksheet. I have checkes “gridlines” in print options, but no luck. Thank you.
This topic is not covered at all in the book you have. That book was written based on Excel 2003 for Windows and Excel 2004 for Mac OS.
I no longer have access to Excel 2000, but my Excel 2000 Visual QuickStart Guide clearly shows a Gridlines option under Print in the Sheet tab of the Page Setup dialog (page 173). If that’s turned on for the sheet you want to print, gridlines on that sheet should print. If they don’t, I’m afraid I don’t know what the problem is.
Good luck!
Hi maria
thanks for your help earlier,
dont know if you know how to run macros in excel i have made them and they are working fine but when i close and openit again it says the security level is set to high so even if i change it to low it still says the same thing and wont let me use the macros it says something about signed certificates dont suppose you have a simple solution so i will always be able to use macros anyway thanks again
jamie
Jamie, I need to know what version of Excel you’re using and what edition of my book you have to answer your question.
Sorry, asked my question in the wrong place i have excel version 2000 xp but only have a book on word quickproject thats how i found out about you and looked you up on the internet and found this amazing website i will ask my question in the write place now, sorry.
Jamie
I no longer have Excel 2000; Excel 2007 is the current version. I did write an Excel 2000 book (seven years ago) and covered that feature on page 212. To my knowledge, however, the warning dialog that you’re probably seeing cannot be disabled in Excel 2000. In later versions, there is a preferences setting to disable it. Sorry I can’t be more help.
Where are the companion files for:
MS Office Excel 2007 Visual Quickstart Guide?
Thank you.
S. Henning’s last blog post: Video Blogging with Viddler and WordPress, Part IV
EXCELLENT question, S! I apparently forgot to put them online. Odd that you’re the first person asking for them.
Here’s the link to where you can find them now:
http://www.mariasguides.com/2007/01/25/excel-2007-visual-quickstart-guide-sample-files/
Thanks for keeping me honest!
Where are the companion files for MS Excel 2001 for macintosh? Thanks!
I no longer have the files for the Excel 2001 VQS. That book is about 7 years old and long out of print.
The files you find here SHOULD work: Excel 2003/2004 QuickStart Sample Files
Maria,
I am not able to locate the sample files to download in support of MS Office Excel 2007 for Windows – Visual QuickProject
Thanks,
Dick
Hi Maria -
I’m using the Microsoft Excel 2007 Visual Quickstart Guide as a refresher & finding it very helpful.(and I paid full price!). I just can’t seem to find Appendix A mentioned on page 9 with a list of the shortcut keys. Please adivse.
Thx,
Vicki
I am a computer beginner. I have Excel, within a suite of programs, but I’ve never used it. Can you tell me how I could use it to automatically generate random numbers, as Ive seen you discuss? I just don’t understand it all. Sorry, Maria; and thank you!
Jeff, unless you have a good understanding of Excel, it’s difficult to explain (beyond my article) how to set up a random number generator. My advice: learn the basics of Excel and come back to the article. I think you’ll be able to put it to good use then. Good luck!