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. Sending an email directly from an Excel spreadsheet
  2. Lookup cell reference
  3. Excel open CSV Issue
  4. Intermittent issue Excel 2003
  5. vlookup formula
  6. Limited xls file validity
  7. Exc. 07 Spell Chk
  8. Year and Percentages
  9. Summing Number Of Occurences Of Non-numeric Data
  10. vlookup or pivot or match/index ??
  11. Excel defined names
  12. Free Online Excel Help?
  13. Cell must have other color by changing value what do I wrong
  14. Vlookup help to match invoice and credit note numbers
  15. Rearranging Names in cells i.e. Guy, Robert to Robert Guy using a Macro
  16. Two sums of column based on conditional split
  17. Macro; open workbook 1, then workbook automatically opens?
  18. 2003/2007 compatability
  19. Percentage increase for column
  20. Backlog and Burndown sheets
  21. Pivot Table Help
  22. is there a way to fill one field to adjust the spreadsheet
  23. 25,000 entries, how to find increments of 50
  24. Excel drop down list validation
  25. Error in IF formula
  26. Primavera & Excel 2007/Vista
  27. Comparing two workbooks of data
  28. Enable using keyboard shortcuts or macro's while using a protected sheet?
  29. Multiple Auto filters set, is there a fast way to set them all back to "(All)"
  30. Using LARGE & Keeping the Source Format
  31. Return Text in Adjacent Cell
  32. Can excel do this for me?
  33. Copy column values from one sheet to another
  34. VB Script Problem ?
  35. Automatically insert new row for new info
  36. Find Missing Numbers
  37. Possible to output last word in a text cell that contains several words?
  38. Adding Filter Buttons to a Pivot Table
  39. Scrolling
  40. Conditional Formatting subtotals
  41. Cells/colum
  42. take data from an excel spreadsheet and us it to fill in forms on other word document
  43. Can Validation for this sheet
  44. Rollover Behavior
  45. Text Case issue
  46. Row AutoFit Question
  47. Auto-filter?
  48. Checking Worker Availability
  49. How do you add a trend line of 45 degrees?!
  50. Multiple cell fill
  51. Want to Learn Formulas ?
  52. Advanced Edit
  53. An Excel file is missing
  54. Saving worksheet as a CSV (comma delimited) doesnt work. Ideas?
  55. By typing specific text into cell A1, it will know what goes in cell B1
  56. Excel Thumbnail
  57. Import from Access
  58. Formula to return in which range of values most nbrs fall !??
  59. add 15 minutes to time in cell
  60. Formula updation to various cells.
  61. Rotating Chart Objects
  62. Padding the end of each row
  63. Tab Wrapping?
  64. Advanced Filter problem
  65. Resizing Checkboxes?
  66. Past as Value Not Blank
  67. Excel Critical Path Schedule setup question
  68. excel text box
  69. vlookup did't work
  70. Move to Second Last Row (Macro)
  71. Removing outline of the cell when pasting in Word
  72. Don't want text for selected cell to show up in formula bar.
  73. Where Do I Post Code
  74. Same worksheet appears every time the workbook is opened
  75. How to print on 1/4 sheet? (4.25" x 5.5")
  76. Have excel 97 - should I update ?
  77. Positioning of data labels on a chart
  78. Screen froze!!!
  79. Splitting cells from one column to two columns
  80. Excel periodically selecting all cells
  81. Vlookup or Lookup
  82. Formula Assistance
  83. Possible To Remove Duplicates In A Column
  84. Excel enter text on its own
  85. SUBTOTAL don’t add up when using Paste Special Value for time values
  86. Excel New File Opening Problem
  87. sorting data (including checkboxes)
  88. Excel Not Calculation/Referencing
  89. hide cells based on conditional formating
  90. countif criteria
  91. how to make an * appear before and after the scanned numbers
  92. remove leading space in cell?
  93. Moving data from 2 rows to 3 separate columns
  94. Insert Blank Row After Date Break
  95. conversion to .csv problem
  96. Dividing a cell
  97. Printing Labels at Top Of Every Page
  98. Printing Problem / Extra Column
  99. convert rows to columns?
  100. Referencing for a Range
  101. Scroll Wheel in Excel 2007 (not working with formulas)
  102. Macro to change text properties
  103. Calculating time differences
  104. Pivot table data formating.
  105. XLdynamic.com
  106. How to format concatenated text?
  107. Change the default size of columns in Excel
  108. Explain cross posting etiquette
  109. Maintain formula integrity when deleting rows.
  110. new member question
  111. OFFSET, MATCH, MAX,or LOOKUP combination formula (maybe)
  112. Is this formula possible
  113. Date Formula reflecting Day to Date
  114. Automatic cell resize of some cells
  115. value seperators as dots
  116. Formatting Lists
  117. Formula Assistance
  118. Continuous Date Columns
  119. Difference in days including weekends but excluding Holiday Range
  120. days outstanding
  121. geometry formulas.
  122. Convert .xls to .xlp
  123. Currency on toolbar
  124. Slow responding while formating or preview
  125. How To Minus & Add A % On Spreadsheets
  126. Percentage difference in an Olap Pivot
  127. Exporting excel table to xml
  128. formula to remove numbers out of a cell.
  129. Subsets
  130. Sheets cut off at column "IV"
  131. formula to remove numbers out of a cell.
  132. Help please
  133. Sendkey Questions
  134. Excel 2003 spreadsheet not working in Excel 2007. :(
  135. Anyway to format a locked sheet?
  136. logic for creating a Scheduling Template
  137. tab to specific cells
  138. comparing two tables
  139. Change cell value based on cell color?
  140. using multiple criteria to sum in one cell
  141. Time format
  142. Significant Figures
  143. Adding Time: Adding individual cells works, but SUM doesn't
  144. Billing/Commission
  145. amend text in cells depending on date
  146. How to add listbox to table in excel?
  147. SUMPRODUCT Problems
  148. Excel Removal of Strings
  149. Converting mm/dd/yyyy into yyyy/mm/dd
  150. "The disk is full" error.
  151. Excel Function Problem
  152. Combining duplicate companies and data
  153. Cannot find an install add-in for Pdf?
  154. Insert problem when sheet is protected.
  155. counting data in cells
  156. How can I find how many I have?
  157. matching #s that start with zero
  158. Excel as Excel Data Source
  159. Conbine tab data
  160. adding accounts from multiple row
  161. Linking Data from Excel in Word - Question
  162. New Database Qry Help
  163. Using Validation List from diferent worksheet
  164. Help with inserting a leading zero
  165. default startup workbook
  166. vlookup problem
  167. Better Report Manager solution than Microsoft's Report Manager add-in?
  168. Date Difference Countdown (Days to go & Passed)
  169. Standardizing Phone Numbers
  170. How do you get rid of blanks in a drop down list?
  171. How do you link the ComboBox value to the graph input?
  172. Removing Macros and out-of-workbook dependencies
  173. Fill Handle Questions
  174. Application.sendkeys help
  175. Conversion question
  176. the colours to be changed when rows are added or deleted
  177. Pivot Table Error
  178. Refresh data when printing?
  179. combining rows containing text
  180. Patse Special option incorrect
  181. grouping of some specific dats files into one worksheet
  182. Sum by date
  183. Change dates by 2 years
  184. Problem with Sumproduct
  185. Need cells to automatically populate
  186. Sumproduct function with wildcard - Excel 2000
  187. Automate import web data
  188. Erase some grouping actuators
  189. Formula assistance
  190. Day Month Year In Different Columns
  191. Remove some sort of anchor (?)
  192. Converting date to weekday
  193. Help removing "+" sign from cells
  194. File Creation Date
  195. Filter by Selection in Excel 2007
  196. Formatting
  197. Cannot use Right click in excel 2000
  198. Find and Return a Value
  199. Formula assistance
  200. leave tracker
  201. output difference between 2 cells
  202. How to graph from checkbox and dropdown selection.
  203. Counting few among many.
  204. Can I populate a ComboBox this way?
  205. Duplicate cells on another worksheet
  206. Picking up the name of the sheet
  207. Selective filtering
  208. Find all possible numerical combinations
  209. Removing Hyphens From A List of Numbers
  210. Unwanted symbol in file - Please help
  211. formula question
  212. changing by factor of 000's
  213. Sections?
  214. Make an image non-draggable/non-stretchable
  215. Copying cells but just the values, not the formulas!
  216. Importing text from web (1-0 = date?)
  217. Hyperlinks on Excel Spreadsheet
  218. When posting in the forum, random spaces appear in the text/formulas.Why?
  219. How to Cross Reference Cells
  220. filter help
  221. Reportmanager
  222. Emailing A Worksheet
  223. How do you enter in a '+' or any other sign without it turning into a formula?
  224. import/export calendar info between Outlook and Excel
  225. How do i tab within cell text?
  226. Can you copy conditional formatting to a different worksheet?
  227. If Sum formula multiplied by percentage
  228. Rounding Issue when viewing csv file
  229. SUM GLITCH, What can I do?
  230. Operation on different lines
  231. Vlookup(Mid - Error ???
  232. Data Formula or Macro
  233. cells and colours
  234. Calculated field of Pivot Table
  235. Adding consecutive numbers, but not otherwise
  236. Need Help With Excel Macro Code.
  237. Excel Macro Problems
  238. macro & formula question
  239. Multiple digital signatures?
  240. Scheduling
  241. What do the ' ' stand for like in 'Basic data'!C$12
  242. Conditional Formatting
  243. Unable to reset the colour palette
  244. Conditional Formatting - more than 3 variables
  245. {xxxx} formula?!
  246. Importing sheets into master sheet
  247. Adding prefix text to cell value
  248. Cell reference of a lookup
  249. SUMif Function
  250. Big spreadsheet & Memory