PDA

View Full Version : Microsoft Excel Misc

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]
  1. excel macros
  2. Viewing Spreadsheet Data
  3. change histroy printing
  4. Re: Autosave
  5. Autofilter question
  6. Tracking Number of Times You Print a Spreadsheet
  7. Showing names assigned to phone numbers
  8. Using mathmatical functions on ranges that have #NA
  9. Menus Do not work
  10. Scan documents directly to excel
  11. Tab key moves me way too far over!!
  12. Find Worksheet by name in any open workbook
  13. Removing hyperlink from multiple cells in Excel
  14. Excel Keyboard shortcuts
  15. How do I insert a check mark into a cell?
  16. Excel-custom.DIC
  17. Password Protection
  18. Formula Wildcard and/or Remaining Value
  19. IF statements
  20. automatic solver function
  21. Excel 02 gridlines uneven FIXED
  22. Re: Modeless in 97
  23. Re: delete columns / upon hitting enter, return cursor to next row column A
  24. Wrap Text will no longer autofit
  25. Can you add or merge two text into one
  26. Data collection
  27. solver add-in
  28. what is plus sign in'=+(a1/b1)'?
  29. Formula Help
  30. Formula Help
  31. Re: color printing
  32. Cell Margins
  33. Re: color printing
  34. Re: color printing
  35. Re: Formula Help
  36. Updating Excel spreadsheet with code.
  37. Re: Formula Help
  38. Building a Master To Do List
  39. How to convert from small to all caps
  40. conversion of *.wdb file to excel (or access)
  41. Displaying Degrees Minutes Seconds
  42. Re: Excel 2002 gridlines are uneven when printing to HP4
  43. Re: Can You Sort By Suffixes?
  44. Comments Again
  45. Comments
  46. finding active cell
  47. Help with HELP
  48. Re: open new Lotus file
  49. Re: "unable to read" excel file
  50. Re: Tab Order Problem
  51. Re: Index / Match ?
  52. How to replace symbol ?
  53. *.xls file is saved from 5 up to 60 minutes !!!!??????
  54. Comment Boxes
  55. Index / Match ?
  56. User Forms
  57. Re: open new Lotus file
  58. Data-Exchange between Excel and Word-Documents
  59. Re: Menus in excel - share special menu with others
  60. Compare 2 Excel docs
  61. Re: Get data from particurar cells in many worksheets and put it to acolumn in a new
  62. Formula help....
  63. Re: "Unable to read file" Please, I need help!!
  64. password
  65. Does Excel 97...
  66. re-organizing data in spreadsheet
  67. Importing large text file into Excel - limited
  68. Solver Add-in
  69. Re: multiple Hyperlinks
  70. Re: Get data from particurar cells in many worksheets and put it to
  71. Re: Excel 2000-breaking the link to another worksheet
  72. Re: "unable to read" excel file
  73. Re: Linking to Custom File Properties?
  74. Comments in protected sheets
  75. Re: didnt save a file............
  76. Re: Pivot
  77. Re: Search Methods
  78. Re: Manipulating Excel spreadsheets for use on the Web
  79. Re: formating cells to recognize commonlyused words
  80. macro propagate
  81. Combination graph
  82. If E9 Is red then place tommorrows date in A11
  83. Multiple Excel Files do not open in Alphabetical Order
  84. freeze user
  85. non-rectangular name - definition?
  86. How to add fonts?
  87. macro status indicator
  88. Exporting a text file to a excel work sheet
  89. Re: Can't Open Large Excel File
  90. Re: copy and past Rows with exception of Hidden Rows
  91. Re: copy and past Rows with exception of Hidden Rows
  92. copy and past Rows with exception of Hidden Rows
  93. unwanted shutdown
  94. Thick column lines
  95. Formula Bar?
  96. Multiple instances
  97. Re: Auto save
  98. Creating an "Empty" Cell
  99. Unable to print landscape
  100. Stuck on Select
  101. Re: referenced cells
  102. Cell Values
  103. Re: Reducing the Size of a Spreadsheet
  104. Let me try to explain this better
  105. Re: Reducing the Size of a Spreadsheet
  106. Re: Reducing the Size of a Spreadsheet
  107. Duplicate
  108. Re: excel article
  109. multiple splits
  110. help with conditional formula for a group of values
  111. Whats wrong with this formula?????
  112. EXCEL and OLAP (Analysis Services)
  113. derivatives of data
  114. Tracking Changes
  115. Re: referenced cells
  116. Count Formula
  117. Mortgage calculator
  118. Excel does not start
  119. Lock Row as Header
  120. how to generate an Excel file in VB?
  121. Excel 2000-breaking the link to another worksheet
  122. Scroll in Excel
  123. Converting Word document to Excel
  124. Lock Row as Header
  125. Re: Automate Opening Excel
  126. Auto updating a chat
  127. Can't Delete Rows
  128. rows
  129. too many copies of the same files in word and excel
  130. Lock Row as Header
  131. Text Method "Overwrite" problem
  132. Disabled Macro File
  133. Re: Lost Excel Sheet by not saving...can it be retrieved?
  134. Re: Converting Word document to Excel
  135. Re: .csv files
  136. Query refresh message on Excel
  137. Excel Passwords
  138. Choosing from a list
  139. Re: Delete name on worksheet to copy
  140. Time Conversion
  141. Excel and Sun Accounts
  142. Re: mkdir question in VBA
  143. Text import drops commas and periods
  144. Starting Macro Recorder
  145. Inserting filepath and filename
  146. Re: Can You Sort By Suffixes?
  147. Copy whole number value ONLY
  148. Formatting cells difficulty
  149. Printing large worksheet onto HP Designjet 800 plotter
  150. Parameter queries in Excel
  151. Re: Inserting filepath and filename
  152. Trouble with time formats
  153. Titles
  154. Any more than a 100% is just excess
  155. Simple conditional formula
  156. Re: Lost Excel Sheet by not saving...can it be retrieved?
  157. Sorting Addresses
  158. Re: Lost Excel Sheet by not saving...can it be retrieved?
  159. Removing the Macro message when opening a worksheet
  160. Re: Some code required
  161. Formula Help
  162. script export to csv file
  163. Problem with Excel files being locked by Administrator
  164. Stuck in Select Mode
  165. Hiding VB code & Securing Code
  166. Option Button protection on spreadsheet
  167. Excel-Grouping with protection of worksheet?
  168. Excel copy and paste
  169. Sort on Cell Colour
  170. Excel macro's
  171. Re: Excel to Access
  172. Help needed with lookup and filtering
  173. Customizing Menu (Right Click Menu)
  174. creating sorted copy of table on second sheet
  175. Assign Macros to Toolbar Problem
  176. Floor function
  177. Saving a picture from excel directly to a file
  178. bad behaviour of command bar buttons
  179. Looking for a loan calc spreadsheet, one that if you make an extra payment, it will calculate into the duration
  180. run-time error 53 when starting Excel
  181. Need to add up some cells in an certain way
  182. Re: Complex header
  183. Re: Excel Border Printing Problem
  184. Re: colored cells not visible on monitor
  185. Re: Invoice not printing in color
  186. data display being cut off
  187. Re: Repeat cells/rows at bottom
  188. Re: Comma delimited files
  189. excel/word
  190. Re: Fractions as Decimal via DDE
  191. Pull down list - drop down arrow
  192. Demo of Newsgroup Solution Capabilities
  193. Re: filename link
  194. Re: dead links
  195. Re: Send this Sheet
  196. Re: import Lotus via batch file
  197. Office 97 and 2000 files get saved as temp.
  198. Formulas not being copied down - until cell is clicked into
  199. Problem Date Formatting
  200. Re: Creating a Clear Button within my Excel file
  201. customize a calculated field in a Pivot table
  202. Re: Please help
  203. Removing a link that can't be found with FIND.
  204. inserting a tab mark
  205. Re: Average of a cell range
  206. m/d/yyyy h:mm date conversion to yyyymmdd ???
  207. Scrolls too fast.
  208. hour of maximum
  209. Number formating
  210. What is Unicode Format while saving xls File
  211. Re: font size
  212. Dead Links
  213. Re: sorting while maintaing certain styles
  214. Re: pull down list
  215. shared workbook
  216. Re: Calculation
  217. Tabs work incorrectly in excel
  218. Templates that were in Excel 97
  219. Re: pull down list
  220. Excel VBA Adjustment To Insert Rows Code
  221. howto define definitions for cells - listbox?
  222. Dates Change to 1996 When Pasted
  223. Subtotals keys on second row instead of first
  224. Excel XP Bottom Double Border Problem
  225. Re: Zero doesn't equal zero.
  226. Re: Can't find file
  227. Re: Excel VBA Adjustment To Insert Rows Code
  228. Use Excel Spreadsheet to Update Access
  229. Converting Coordinates in Excel
  230. Re: Excel VBA Adjustment To Insert Rows Code
  231. Excel 97
  232. Address Labels
  233. Slow to Open
  234. Unable to Read File
  235. Re: Format Painter keyboard shortcut
  236. Re: duplicates
  237. Multiple Instances of Excel
  238. hyperlink to excel worksheets
  239. Calling out an empty cell in an IF statement
  240. Printing Grid lines
  241. Re: Need Excel Tips
  242. tweak macro code - use "Find"
  243. Re: formula
  244. Delete External Links
  245. secondary "x" axis
  246. Regression with Binary Decision Variables
  247. Re: Send this Sheet
  248. MCSE or MCSD?
  249. visual basic macro needed for excel
  250. Cannot open excel file
  251. Send this Sheet
  252. length of spaces
  253. secondary "x" axis
  254. Re: Cursor Placement
  255. replace "#DIV/0!" errors with blanks
  256. replace "#DIV/0!" errors with blanks
  257. Macro to find parts of words
  258. Excel to Notepad
  259. V Lookup EZ Tutorial anyone?
  260. Corrupt File?
  261. Add label to selected XYscatter datapoint
  262. how change grid on (print) for all worksheets in workbook at once?
  263. Running Calculations per day
  264. Integration with MapPoint
  265. Excel 97 Workbook opens behind initial blank Workbook
  266. Re: switching axis
  267. Re: Excel 2000 Crashes on exit
  268. Re: Colors on worksheet don't display
  269. switching axis
  270. Re: big question
  271. OLAP cubes from CSV files
  272. Re: Creating a Clear Button within my Excel file
  273. "A document with the name is already open." error message
  274. Too many cell formats error
  275. Spreadsheet Solutions
  276. Importing CSV files problem
  277. copying sheet within workbook
  278. Excel Printing
  279. Limited number of characters in a cell
  280. excel pivot tables
  281. Re: Average of a cell range
  282. Re: Average of a cell range
  283. Finding duplicate records
  284. excel sum formula
  285. Formatting
  286. Changing font case in a selected column
  287. Analysis Toolpak
  288. Assign Macro to Toolbar Problem
  289. How one can becom an MVP.
  290. Other symbols for delimiter other than TAB
  291. Making rows fixed so when you scroll down you still see top rows.
  292. Date Sort
  293. Sort results incorrect?
  294. Excel XP Bottom Double Border Problem
  295. format significant figs.
  296. 32,767 Significant Digits of Precision, with Number Formatting
  297. Protecting sheets & workbooks
  298. Screen Updating
  299. Re: CSV delimiter in non-English OS
  300. passwords
  301. Counting Rows in Excel
  302. Re: Command Line Restoration
  303. Re: Acrobat
  304. Re: Automatically formatting dates.
  305. Re: date conversion from m/d/yyyy to yyyymmdd
  306. Re: Astonshing interpretation of tab delimited input file
  307. Force complete recalculation?
  308. Re: Comment boxes
  309. Special characters in excel
  310. Re: Excel 2000 Files Menu
  311. More than 255 Charaters
  312. Function question
  313. Re: Currency Style Button on Formatting Toolbar
  314. Re: puzzled
  315. is it possible to auto rename worksheets
  316. Re: Excel Will Not Save
  317. Hour counter
  318. Re: Pivot Tables showing "old" data
  319. Re: Fonts in Excel 2000
  320. Re: Problem with Macro's
  321. Universal templates?
  322. Analysis ToolPak - Excel 97 - doesn't work
  323. Re: Open Excel File problem
  324. Re: date conversion from m/d/yyyy to yyyymmdd
  325. Concatenating Date Field with Text Field
  326. Re: date conversion from m/d/yyyy to yyyymmdd
  327. Re: date conversion from m/d/yyyy to yyyymmdd
  328. To Sort WorksheetTabs
  329. Re: Pivot Table Field
  330. where is the bottom of my worksheet?
  331. Populating a ComboBox from VBA with 2 columns
  332. Sort Tabs
  333. Re: Comment boxes
  334. Random Number Generation Question...
  335. Large text in Excel
  336. Re: Totals of different catagories
  337. Excel 2000 file lost from screen
  338. =IF(L8+1>TODAY(),"",L8+1) to skip weekends and holiday
  339. converting pdf to excel
  340. Re: Goto Blank Cell returns an area? (Causes Access problems)
  341. Save as authentication?
  342. RE: Excel File Opening Problem
  343. modifying the Enter key function
  344. Re: Excel wont' prompt for password
  345. Re: macro for assigning name range
  346. Re: macro for assigning name range
  347. Re: Proper function
  348. Re: Link Workbook by Named Range
  349. system variable representing object or subroutine name?
  350. Re: Link Workbook by Named Range
  351. Re: Breaking WB Links in Excel 97
  352. Re: Printing in excel
  353. Re: Custom Formatting of Data
  354. Re: Acrobat
  355. Re: select and drag: sequencing numbers doesn't work
  356. Re: Split Cells
  357. Track Changes in Excel 2000
  358. Re: Proper function
  359. 8192 rows limit when opening wk1 files ?
  360. Re: Proper function
  361. automatic data transfer
  362. Names in Workbook
  363. Re: Rounding up to next 50
  364. Re: Tab Order Problem
  365. Re: Rounding up to next 50
  366. Converter for Excel 2002
  367. Opening a file off a disk
  368. macro for selecting last 3 sheets in a workbook
  369. RE: Lotus 1-2-3 to Excel
  370. Rounding
  371. Trouble Sorting in Excel
  372. Re: adding confidence interval on regression line?
  373. Re: Excel dates
  374. Re: Fonts in Excel 2000
  375. Re: Visual Basic for Pocket Excel
  376. Re: Omit data point in chart
  377. Re: red formula
  378. Re: recently used file list
  379. select and drag: sequencing numbers doesn't work
  380. Data Sort & Maintain Link Positions
  381. Hiding "FALSE" values
  382. Control of comments location when converted to HTML
  383. Split Cells
  384. need opposite of MODE function in Excel
  385. Re: Excel rows space
  386. Re: puzzled
  387. Re: Finding text in a cell, then selecting cells below until a blank cell is found.
  388. Excel File will dissapear from the screen when the restore window is clicked
  389. Problem savin in a Network Drive
  390. Re: Need Excel Tips
  391. Re: wrong year
  392. Re: puzzled
  393. Re: Macro to update a macro
  394. Re: Fonts in Excel 2000
  395. Re: Fonts in Excel 2000
  396. Re: Error in formula with Rounding
  397. Re: Functions question
  398. Re: puzzled
  399. Re: Date Range: Ignore Old Days
  400. Re: Date Range: Ignore Old Days
  401. Re: it is not work
  402. Re: Functions question
  403. Re: Error when summing columns
  404. Re: Adding columns and deleting empty rows?
  405. Re: it is not work
  406. Re: WB slow to open 100+ check boxes
  407. Error when summing columns
  408. Re: it is not work
  409. Re: Check mark boxes in Excel 2002
  410. Changing columns to rows
  411. Quit Excel problem
  412. Question: Cell formula or macro to write result of one cell to another cell
  413. Question: Macro overloading, passing variable number of arguments
  414. Question: OPEN return status
  415. Excel, HTML-Export and Images
  416. Change Format from Minutes(Time) to Number
  417. Re: where is FAQ?
  418. Writing data to Specific Cells???
  419. odc data source
  420. Re: where is FAQ?
  421. Re: where is FAQ?
  422. Re: where is FAQ?
  423. Re: where is FAQ?
  424. missing rows
  425. Problems generating an html link based on worksheet values - SOLN
  426. Problems generating an html link based on worksheet values
  427. Upcoming Support Webcasts
  428. moving to cell Y if cell X has value Z.
  429. Excel table macro
  430. Re: formula question for range of cells
  431. Re: How to draw neat spiral?
  432. formula problem
  433. Re: FInd the unknow
  434. Re: FInd the unknow