PDA

View Full Version : Excel Miscellaneous


Pages : 1 2 3 4 5 6 [7] 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270

  1. Function to automatically hit a keystroke
  2. How to create a Macro or function to execute a program
  3. Averaging Times
  4. Saved changes lost, File reverts to previous version
  5. Last Name, First Name - Using Excel To Reverse
  6. Reference tab name in formula
  7. WorkBook Size
  8. Limit a Calendar Userform based on a cell value
  9. cell highlighting problem
  10. Cell accepting only numeric values
  11. SUMPRODUCT * versus ,
  12. Cursor stuck a cross
  13. Angled Borders using Conditional Formating
  14. print options
  15. Value to return if Two Conditions met on Two Files
  16. Excel Timesheet Question
  17. Using the "&" to stick text and values together; How to round the numbers?
  18. Line across top of footer
  19. two part question - combining spreadsheet & text only validation
  20. Unprotect & Protect Multiple works sheets with a Macro
  21. pivot tables attached to Database
  22. Search to Match From Two Different Tabs?
  23. Pull-down list for column value
  24. Not a valid Name Problem
  25. How to transform list
  26. Sort percentage values
  27. Pivot table - weekly report
  28. hyperlink pictures opening in ie7
  29. Sum and Index calculation problem
  30. autolink vertical data horisontally
  31. Find the highest (& lowest) ever value in a cell containing streaming data.
  32. Pick out highest number in column then return a different cell
  33. Page printing order 8, then 1,2,3,4,5,6,7
  34. Using a versatile GETPIVOTDATA function
  35. Centering a hyperlink
  36. Column renaming?
  37. Format a field based on another field
  38. Sumif?
  39. Average
  40. Horizontal lists
  41. bringing in foreign characters
  42. Formula shows result as 0
  43. ctrl-D down a column?
  44. Resizing A Check Box
  45. unlocking a cell to edit it
  46. Excel Mail Merge Challenge
  47. Converting base 10 to base 6
  48. caps to lower case
  49. Index formula won't work in French edition
  50. How to Paste from word without loosing highlighted phrases?
  51. compare cells
  52. Fields switched to date format
  53. Lookup?
  54. Spell Check
  55. Sorting on a portion of a cell
  56. Sum from Multiple Criteria
  57. Trendline - Forecast Option
  58. Cannot see SharePoint lists anymore, what happened?
  59. How to stop text to columns automatically parsing
  60. Show last value in column
  61. date display
  62. Job available for an Excel Expert
  63. Data Validation Defined Names
  64. Auto Sum of Machine Downtime
  65. Multi-line cells to columns
  66. Copy Paste Problem
  67. Sorting problem
  68. Horizontal To Vertical
  69. Pivot Table calculation
  70. Multiplying number of days in a date by a value
  71. Tabulating Survey Results, "Check all that apply", How to do it in Excel 2003
  72. Calculating payments in a month
  73. how can i make a master data sheet?
  74. "Iserror" Question (s)
  75. Resetting Input Cells
  76. Excel 2003...how do I open in 2007??
  77. Customize columns and rows (ABC,123)
  78. MapPoint 2004 and Excel Pivot Tables
  79. Copying Notes en masse
  80. Page Number
  81. Capitilizing First Letter of First or 2nd Word
  82. Instead of adding it count
  83. Auto height formating
  84. single drop box with machine numbers selectible then a drop with diff time choices to
  85. Get highest value for row value
  86. Syntax for using windows scheduler to open a specific spreadsheet
  87. Conditional Formating
  88. excel date diff inside a macro
  89. keep cell referenses i formula
  90. grouping data
  91. distribution of work in excel
  92. Data in wrong cells
  93. Indirect issue
  94. alphabetize sheet.
  95. Accept Numeric Only in Protected Spreadsheet
  96. Random Number Generator
  97. Standarize date formats?
  98. Using Notebook ink tools on a Protected Sheet
  99. Link Excel to PDF Page Locally, or Alternative?
  100. VBA Colour Index Problem
  101. restrict a specific word in any specified column
  102. gross markup formula....
  103. Alphabetized data template
  104. create descending or ascending dates
  105. Lost macro Relative Reference icon
  106. Equation to Provide Result Based on 2 Columns
  107. naming cells
  108. Sumproduct??
  109. File association
  110. Cannot scroll across using freeze panes
  111. Exporting into MS Word - Gridlines
  112. Balance Scorecard
  113. template creation
  114. Time Formatting
  115. File reference in a Macro
  116. Excel Network shraring doen't work
  117. Variable [filename] & Directory
  118. Excel Formula
  119. Annual Leave - Excel 2003
  120. sorting paypal transactions
  121. Finding duplicate numbers
  122. Vbulletin Question (This Forumn)
  123. sort employees by birth month?
  124. Multiple Copies of Multiple Records
  125. Insert Digits Into A Column of Numbers
  126. Creating excel forms (interactive functionality)
  127. Changing Cell Color
  128. How do I add items to a combo box?
  129. Averages
  130. Hyperlink to files
  131. Hyperlink Formula
  132. Count Cells in Another Document
  133. vlookup that lookups in different workbooks
  134. Months, Days from an integer number
  135. Sort by number of characters in cell/column? How please?
  136. scroll lock status check
  137. Excel files will not open
  138. Formatting date a general
  139. How to stop automatically filling when copying
  140. Drop down box using pivot table?
  141. Count if formula
  142. Excel 2007 - PNG images
  143. Sumif / Subtotal(9,) Using Autofilter
  144. Excel 2007 - Conditional Formatting Problem
  145. help me save hours of my life
  146. Button access
  147. Networkdays
  148. Dynamic Table: Text in a Calculated Field?
  149. Transferring text from separate spreadsheet
  150. marking up prices formula
  151. SQL query to display message
  152. Adding a date...????
  153. Convert Mac Excel to PC
  154. ??th day of the year
  155. Dynamically view and alter records
  156. Superimposing graphs
  157. How can I number my rows?
  158. Partly unable to insert rows and cols
  159. Changing Number formats
  160. Saving Excel File As Web Page Problem
  161. WordArt won't resize
  162. Excel 2008 (Mac) row numbering
  163. Custom Drop-Down List
  164. Sort Data Problem per number ref
  165. Passenger Forecasting
  166. Date Appears As Number
  167. combining two columns of data into one.
  168. error message "cannot shift items off sheet
  169. cannot type in the cells
  170. External links not updated after moving entire set of files!
  171. Calculating a bonus check
  172. losing customized color palette
  173. Formatting
  174. Data Validation & Lists
  175. if condition to change cell color
  176. removing blank cells
  177. Generating Invoice Number
  178. NETWORKDAYS formula
  179. Vat Formula
  180. Open-file window off bottom of screen
  181. Excel file opens in read-only mode
  182. Toolbar text in excel vs word
  183. LARGE function
  184. import a csv and not have excel format any values
  185. sum time formats
  186. Sumif or Sum(if(xxx) ??
  187. "N/A" to display, not "0"
  188. substring in excel cell
  189. Web query information
  190. Wildcard search for SUMIF command?
  191. Formula Diffrences
  192. Problem formatting dates in pivot chart.
  193. How can I have excel count cells based on a condition?
  194. Formatting Problem
  195. Excel Cell Matching
  196. Protect range of cells?
  197. Viewing two spreadsheets at once
  198. Spreadsheet Style
  199. Multiple IF statements and conditional locking of cells
  200. Copying the text in a cell to a text box
  201. finding value out of chart
  202. Extracting a Word from a cell that contains a sentence
  203. Why pictures so big in Excel?
  204. Regression - understanding R, Rsquared, Anova
  205. 2 Digit Year Function Excel
  206. If statement to pull values from another spreadsheet / worksheet
  207. Save header in dropdown menu
  208. List Box Validation
  209. Math : cubic area formula?
  210. Stacked Worksheet Tabs
  211. formula too long
  212. copying different values a number of times
  213. index - match formula
  214. Default font size for pivot table drill-down
  215. Excluding the leap year in a date formula
  216. Date Formula
  217. Linking cells
  218. every other line
  219. drop down lists prevent workbook sharing
  220. Average IF
  221. Dummy data
  222. Excel / mailmerge assistance
  223. Can You Fix The Width Of Spreadsheet Converted to A Web Page
  224. How to create a list from data in other sheets
  225. Unbold & use a different font on part of a cell contents
  226. Excel 2007
  227. How do I convert "02/04/2008 03:02PM" to "02/04/2008"
  228. Checks Countif
  229. How can i extract multiple rows over several sheets/workbooks
  230. Converting 2/3 digit numbers to 5 digits with text
  231. How to delete all items A:A from B:B
  232. Error message in Ultimate Add-In for dominicb
  233. Complex Data Replacement
  234. Reverse Frequency
  235. Excel 2003 v 2007 slowness
  236. An "AND" inside an "OR inside an "IF"
  237. Making History Sheet Permanent?
  238. Multiple Fill Color & Font Colour icons on menu bar
  239. Autosort numbers from low to high
  240. Excel will not open spreadsheets
  241. Percentage Question
  242. how to change a column ref but not the row?
  243. How to create a pivot table with multiple name range
  244. If Function!!
  245. How to calculate formulas on my own?
  246. How to transform date like 19500103 to normal format?
  247. Pivot Table Field Values
  248. Non-Documented Functions(Formulas)
  249. "Too Many Formats"
  250. SumIf Error