| 2. | What do I need to know before using Excel? (Terms, Window concepts, File structure, mouse usage) |
| 3. | How to speed up or optimize slow Excel VBA sheet? |
| 4. | How to suppress the popup message in Excel? |
| 5. | How to find external links in Excel Spreadsheet? |
| 6. | What is causing #REF error in Excel Spreadsheet? |
| 7. | Why isn't VLookup Working? (numbers vs. characters in data, relative references) |
| 8. | How to VLookup on two or more fields? |
| 9. | Where is x function in Excel 2007? |
| 10. | How do I determine why spreadsheet is so large? |
| 11. | Spreadsheet only allows 65K rows what can I do to go past this limit? |
| 12. | How to recover a corrupted Excel Spreadsheet? |
| 13. | How do I make VBA code wait x seconds? |
| 14. | How do I find the last used cell in a spreadsheet? |
| 15. | How to maintain multiple versions of an Excel Spreadsheet |
| 16. | How to get next row on filtered data in Excel? |
| 17. | How to get unique items in a list using Excel? |
| 18. | What does the % character or other characters mean in Excel? |
| 19. | What are the most important Excel VBA shortcuts to know? |
| 20. | How to get data from the Internet into an Excel spreadsheet? |
| 21. | Charting Questions |
| 22. | How do I create a status bar? (Estimating completion time) |
| 23. | How do I access a database from Excel? |
| 24. | How to select a column if a cell is merged? |
| 25. | How to detect if autofilters are turned on in Excel? (signoff sheet) |
| 26. | Sorting Questions |
| 27. | How to sort on category type data? |
| 28. | Pivot Table Questions |
| 29. | How to keep heading columns from moving in Excel? |
| 30. | How to word wrap data in Excel? |
| 31. | What is Option Explicit in Excel? |
| 32. | What does DoEvents do in Excel VBA? |
| 33. | How to automatically run code when Excel file is opened? |
| 34. | How to convert a column letter into a column number and vice versa? |
| 35. | How to create a new sheet? |
| 36. | How to log data to a file from Excel spreadsheet? |
| 37. | How to log errors to a sheet with active workbook? |
| 38. | How to determine if an Excel sheet exists? |
| 39. | How to debug or step through a formula in Excel? |
| 40. | How does security work in Excel VBA? |
| 41. | How to tell user to Enable Macros in Excel sheet? |
| 42. | How to add a hyperlink to an Excel Spreadsheet? |
| 43. | How to add hours to a date? |
| 44. | How to get rid of ### in a cell? |
| 45. | How to get rid of #N/A? |
| 46. | How to get rid of #REF |
| 47. | How to Concatenate or Combine data in an Excel spreadsheet? |
| 48. | How to show Excel Formulas when viewing spreadsheet? |
| 49. | How to switch between two or more active Excel spreadsheets? |
| 50. | How to hide gridlines? |
| 51. | How to hide column and row headers? |
| 52. | How to detect how many items are displayed when filters are turned on? |
| 53. | What are the most important functions to be familiar with? |
| 54. | How to select a column when a merged field exists? |
| 55. | How to prevent an infinite loop? |
| 56. | How to not hard code columns in VBA? |
| 57. | I have a cell that is blank with an if and the blank is showing as a 0, =if(isblank(e5),"",e5) or format as custom number |
| 58. | How do I display a message box without the code stopping? |
| 59. | How do I two spreadsheets to see the differences? |
| 60. | How do I stop VBA code that's running? |
| 61. | How to prevent user from pressing ctrl+Break |
| 62. | How to password protect an Excel spreadsheet? |
| 63. | How to autosort a spreadsheet, ie keep it in a certain order? |
| 64. | What does RC format mean? |
| 65. | How to prevent code from running the auto_open() routine when opening a spreadsheet in code? |
| 66. | I have a cell displaying a formula of =B1+B2 where B1=2 and B2=3 how come it's not displaying 5? formatted as text) |
| 67. | How to show two sheets from one spreadsheet at the same time (Window NewWindow) |
| 68. | how to use conditional format? |
| 69. | how to use macro with example? |
| 70. | How to prevent Macros from Executing when opening a macro? (hold shift key down) |
| 71. | What is an Excel Function? |
| 72. | What is the syntax for the subtotal function? |
| 73. | I entered 3-2 and Excel converted it to Mar-2, how do I stop this behavior? |
| 74. | What are the most important shortcuts to know in Excel? |
| 75. | How to change row data to column data? |
| 76. | Why isn't copying cells working properly? |
| 77. | What is paste special |
| 78. | What is a hyperlink? |
| 79. | What does Fill do? |
| 80. | How do I copy a sheet from one workbook to another |
| 81. | What is an addin? |
| 82. | How to secure my VBA code so no one can steal it? |
| 83. | Why isn't find working? |
| 84. | How do I find a "?" in Excel? |
| 85. | How do I select all |
| 86. | What is a current region? |
| 87. | How do I select all of the data on a sheet? |
| 88. | How to create sheets from a list of items. List has 10 items, 10 sheets to be created. |
| 89. | How to set tab color (ActiveWorkbook.Sheets(sCurUP31).Tab.ColorIndex = 4 'Green '') |
| 90. | What is a syntax error and how to solve them |
| 91. | How to move down one row? (ActiveCell.Offset(1, 0).Select ) |
| 92. | How to position to the next unfiltered row? |
| 93. | How to determine number of rows when filtered? |
| 94. | How to run an Excel Formula in VBA? application.evaluate or = [=a1+b1] |
| 95. | How to load multiple numbers into one cell and position one on top of the other? |
| 96. | How to replace #N/As with blanks? |
| 97. | What does the pivot table error mean? (when file name has [ ] in it) |
| 98. | In 20 sheets how do I find if there are any columns not wide enough which display ####### (Find All Values #) |
| 99. | How do you view 2 sheets from the same workbook at the same time? |
| 100. | I have a pivot table, how do I find out where the data is coming from (Wizard, Prev, Named Range was on Hidden sheet) |
| 101. | How to understand what a formula is doing in Excel? |
| 102. | Why is the Debug button not available (code was deleted in a sheet) |
| 103. | Why does debug window keep coming up? |
| 104. | Where can I get a free version of Excel (Openoffice) |
| 105. | How do you get the number of rows on a sheet? (Cells.rows.count) |
| 106. | How to toggle the caption on a button when pressing? (show/hide changes sheet) |
| 107. | What to do if you get "Microsoft Excel has encountered a problem and needs to close" dialog |
| 108. | How to create sheets from a list of items? (Sheet name limited to 31 characters) |
| 109. | How to count the number of commas in a cell A1? =count(a1)-count(substitute(a1,",","")) |
| 110. | How to clear filters w/o removing them? |
| 111. | Why don't I see a record when I drop down the filter? (Too many records and the filter doesn't contain all the records) |
| 112. | I entered 7/10 and Excel displaye 10-Jul. How do I get Excel to display 7/10/2009? |
| 113. | How do you prevent VBA code from overwriting the clipboard? |
| 114. | VBA Code not working and I'm going crazy (caused by hidden sheet with same name as other sheet but with a trailing space) |
| 115. | How do I get the last row in a spreadsheet? (macro record goto special last cell |
| 116. | How to tell what the numerical column of BY is? Options General R1C1 reference style |
| 117. | How to remove the crawling ants (moving dashes around cell after cut or copy)? Esc key or vba code Application.CutCopyMode = False |
| 118. | How to avoid using the clipboard in VBA and why you should? |
| 119. | How to avoid hardcoding sheet columns and why you should? |
| 120. | I have a date that looks like an integer 38712, how to make it look like a date? =Text(C2,"mm/dd/yy") |
| 121. | How do you do And and Or conditions in an Excel If statement? |
| 122. | How do you include new fields in an Existing Pivot table? |
| 123. | I'm getting error in Pivot table ... ? cause is [1] vs. (1) |
| 124. | How do you view 2 different sheets from the same workbook at the same time? |