PDA

View Full Version : Excel Discussion (Misc queries)


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 | 

  1. how to select cells that are bold?
  2. Mail Merge issue
  3. Problem with updating external links
  4. Using an IF to combine multiple formulas
  5. Inserting Data
  6. UNIQUE VALUE
  7. Linking Spreadsheets from two files
  8. spreedsheet help
  9. How can I print frozen panes to appear above print selection in Ex
  10. Automatic Notification
  11. vehicle check list templet
  12. Please help me!
  13. need explanation on simple time calculation
  14. Pivot Table dropping items from page item list
  15. Cursor position / Cond. Format
  16. How do I recover from "Access Denied" in Excel?
  17. Single Cell change size
  18. Sources of Excel Tips, Tricks & Code
  19. calculations row by row
  20. format whole row..
  21. Opening Access From Excel
  22. input conditional formulas using VBA Macro in axcel sheet
  23. Importing Text File into Excel
  24. 'Automatic' sorting to printable report
  25. Linking Groups of cells between workbooks
  26. Combining Multiply Worksheets onto one
  27. From Monthly to Quarterly Numbers
  28. unifying two sheets by a common index column
  29. Text Time Coversion Arithmatic
  30. HOW DO I MAKE ADDRESS LABELS OUT OF LIST IN EXCEL DOC?
  31. Need Help changing FORMULA
  32. Displaying an error message if entries exceed 100%
  33. xp should allow home users to read excel
  34. Excel 2000 sheetname equals filename
  35. Sharing read-write Excel 2003 files
  36. Using non standard actions on an Excel 97 pivot table
  37. ? Pivot Table from 3 columns of raw data with headers
  38. Format Cell
  39. Select One Cell or Another
  40. Totalling column in Excel when cells contain forumulas
  41. Moved Excel to another drive
  42. vlookup
  43. How do I stop Book 1 opening with existing files?
  44. On Open Macro
  45. Cells get automatically highlighted
  46. Dates
  47. What FORMULA will count records that CONTAIN certain text?
  48. Dates period from master worksheet to another worksheet
  49. Please help: A way to find multiple rows??
  50. finding a formula
  51. why are the help files now remote?
  52. Convert irregular data to monthly equivalent?
  53. preview on top of spreadsheet?
  54. How do i keep a column stationary but move the rest of the sheet?
  55. dss and excel
  56. hiding application
  57. how can I stop Excel Advancing the year by 1 when I enter a date?
  58. Vlookup
  59. Matching Data in a Row and Display in Column
  60. Converting Data from pdf into an Excel spreasdsheet
  61. something more efficient that =IF, and sytax questions
  62. freeze panes?
  63. need help referencing cell using result of formula
  64. Editing fields in bulk
  65. multiple column match per row
  66. Easy Sorting Question
  67. "60 Minutes" Excel
  68. Silly question about using dates
  69. column changed to numbers
  70. Userform + close button
  71. How do I wrap Excel columns in a printout?
  72. titling columns
  73. Copying formulas to other cells. Keeping references w/o $ sign.
  74. SUMPRODUCT help....
  75. how can i make a measurment with and underscore under the second
  76. In Excel, I want to convert Eastern time to pacific time
  77. Removing Duplicate Pairs(2 Columns)
  78. Making negative numbers show as zero.
  79. Help Using Calendar Function
  80. formula
  81. Color Formats
  82. Forms
  83. formulas
  84. calculate APR using cumulative interest?
  85. .PFO format?
  86. Need help with a formula
  87. How do I avoid copying data from hidden rows/columns?
  88. Conditional Formulas
  89. Formula for end of the week
  90. data form
  91. grey dot in left upper corner of cell
  92. Macro to automatically open a website or send an e-mail in excel
  93. Operations (add, multiply) on all values ($00.00) in a column?
  94. Print a data entry form without the spreadsheet as a background?
  95. Text/Comment Box appears magically
  96. Expanding and Collapsing
  97. Accurately entering digits in a worksheet
  98. how can I sort with header not on row 1
  99. Macro for list
  100. Need to delete all hyperlinks on Excel document
  101. publishing excel to the web
  102. "File Format Not Valid" When Starting Excel. Error Code 0D3F6000
  103. How do i automatically group rows in a pivot table?
  104. Macro code to autosum a dynamic length column
  105. conditional formatting
  106. Updating links
  107. formula using data validation
  108. Arrows moving page, not cells
  109. VLOOKUP on multiple worksheets
  110. Time entries
  111. Show average at front of list
  112. countif maybe
  113. Removing blank cells...
  114. Link in Excel not working
  115. Paste Special
  116. Easy way to count cells within date range
  117. Entering dates
  118. Cell Variables and Ranges
  119. sum wiht an if or vlookup?
  120. Simple Question
  121. Document Properties sent to print when print with office applicati
  122. change 800 to 8.00
  123. copy formula without changing the row.
  124. Print from Excel
  125. I am receiving "prepare for installation" message when I try to .
  126. Matching across multiple workbooks
  127. Problem inserting a picture in Excel that ONLY shows when clicked
  128. Settings are changed when opening workbook on a different computer
  129. Printing multiple worksheets double sided
  130. creating formula to adjust per month
  131. Formula to reference name of sheet tab
  132. Array Formula Help
  133. Add a criteria to an Index and Match formula
  134. Generate column of 1's and 0's randomly
  135. Silly Problem with Variable (2nd attempt)
  136. Splitting data in a single cell that is seperated by commas, then moving to make individual rows
  137. dialog box
  138. "cannot shift objects off sheet" REAL help needed
  139. Conditional formatting
  140. Wildcard for ALPHA only
  141. Opening Excel workbooks from Windows Explorer
  142. Copying and pasting data muiltiple times
  143. Re: Copying and pasting data muiltiple times
  144. Minimum cell height while using AUTOFIT?
  145. Auto generated dates
  146. How do I re-size a comment box using VBA?
  147. VBA to change font?
  148. Preserve format
  149. Can't open an Excel file from Explorer, only from Excel
  150. Copying and Pasting
  151. Vlookup question
  152. how to extract a figure from a database
  153. how do I analyse two spreadsheets for missing data?
  154. Create custom function
  155. How do I get a drop down list to always go to the top of the list
  156. Impossible to apply other kinds of character
  157. Copy>Special>Format: Not for Conditional Formatting?
  158. merging data cells
  159. Text records in Excel
  160. merge sheets
  161. XNPV
  162. Non Blank Cell
  163. replace zeros with nulls
  164. replace zeros with nulls
  165. comments moving randonmly after a save & close
  166. Dashboard
  167. Cells turn 'hot' and execute distant macro button
  168. Entering a number on any sheet one time only
  169. how do i format a cell based on format of a range of cells?
  170. Realtime chart example
  171. Auto fill?
  172. real number
  173. Index/Match Multiple Criteria
  174. Validation to stop workbook closing
  175. password
  176. Converting a Lotus 123 file to Excel
  177. Need help with a formula in inventory
  178. SumProduct question
  179. Formatting
  180. add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22)
  181. Can excel create 4 Y-axis graphs?
  182. Formatting cells
  183. function to extract background color from one cell to another
  184. How to make COUNT indicate ROW
  185. Excel2000: Data validation behaving funny
  186. Help with Formulae please!
  187. fill circle half way
  188. <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
  189. Drop Down List Box, Combo Box
  190. >@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
  191. Excel cannot complete this task
  192. Amnesty for illegal immigrants will not happen this time.....................
  193. how to edit calender control in excel?
  194. Will illegal immigrants get deported?.........Of course not.....................
  195. Illegal Immigration, the Non-Issue of the Week??????????????
  196. Pivot Tbl Calc Field using %'s
  197. Save a workbook but not as "read-only"
  198. Using Autofilter on a Protected Worksheet
  199. average 2 cells (Mileage Divide by Gallons in two cells
  200. I want Excel to always open on Sheet 1
  201. How do I display hyperlink as embedded jump text vice friendly tex
  202. AFTER REPLACING FORMULA WITH VALUES, HOW DO I ADD THE COLUMN?
  203. Order of Pivot Drop-Down (Page Field)
  204. how can I remove a dropdown list from my worksheet
  205. Help please...
  206. internet explorer not able to open site
  207. offset 1 row and return to first column
  208. Can I make an entire column Uppercase?
  209. Using formulas between different sheets in the same workbook
  210. Excel should treat windows independently like Word.
  211. Multi-user collaboration/consolidation examples
  212. Hyperlink
  213. Rounding Down
  214. If formular
  215. Want to insert Excel sheet in Word document - comes out too big.
  216. speech object causes crashes
  217. line trouble...help
  218. countif clarification
  219. Display masking
  220. Macros available everytime
  221. Excel Auto Calculations
  222. Importing from Excel
  223. Formula that will change subsequent cells in a column to match fir
  224. Creating Report from a List in Excel
  225. remedial excel question
  226. remedial excel question
  227. # format issue
  228. Dates with Holidays question
  229. Please help, I'm stuck
  230. "window in taskbar"
  231. copy whole row using a formula
  232. Saving a sheet as a separate file
  233. Sums
  234. Pivot Table & Grand Total Row & XL 2003
  235. How can I have a protected worksheet and have spell check ability
  236. Excel data across sheets
  237. confused on two formulas
  238. Leap year date
  239. Formula
  240. How do i clear a cell using a command button?
  241. enlarge drop-down contents
  242. grouping and sorting data
  243. Shortcut Key for Data-Filter-Show All?
  244. problems to open an excel archive
  245. Incorporating Excel Spreadsheet into Word?
  246. Can I set up a newsletter style column in Excel?
  247. Subtotals including blank rows
  248. Functions and formatting
  249. Formatting
  250. how to hide 0 values in pivot table
  251. cell formatting
  252. operations on entire column
  253. Can't get Cancel to work in message box
  254. Conditional Formatting
  255. Updating Range Names
  256. Deleting a row
  257. Sub-cell List Sorting
  258. application.match
  259. Can I assign a keyboard accelerator for Paste Special/Transpose?
  260. Green Columnar Template in Excel
  261. Inserting cells between cells with text
  262. Date formula problem
  263. Date formula problem
  264. Automatic Saved Date
  265. How to convert text to numbers
  266. Keeping column width in Excel pivot table?
  267. How do I clear a column of data without clearing specific cells?
  268. how do I randomly shuffle a word list in Excel?
  269. Highlightng in Excel
  270. 11 x 17 is not a print option for me
  271. how to convert a figure in words?
  272. Search field?
  273. display issues
  274. COUNTIF
  275. 2 columns with duplicate names and total numbers
  276. Copy data into another worksheet and have it update automatically?
  277. Excel lookup help pls
  278. Help with filenames and paths.
  279. FORMULA DOESN'T WORK
  280. Maintain Format of Pivot Table
  281. How to show the formula and the answer?
  282. How do I get Excel to stop auto-formatting?
  283. How do I set conditional protection to a cell
  284. if-statement
  285. Only count columns if the column next to it is not blank
  286. how do I highlight the current row and column
  287. Pivot Tables -- Auto Refresh
  288. Building a timeclock
  289. How do I place font buttons on the Toolbar
  290. macro commands
  291. how do I import variable data into a word document
  292. make Pivot table show only available values in dropdowns
  293. Finding max from different ranges of data
  294. sum sub levels.
  295. Lookup and offset
  296. sumif with activex input
  297. How to insert a excel table in Power point that is updated alone?
  298. SUM using results from an Adress-formula
  299. countif help
  300. VBA Getting Started
  301. in excel how do you quote a differnt cell
  302. Conditional formating
  303. Setiiing up file name & path as a default setting on all sheets/ta
  304. Sumproduct, If, Sumif, Countif, Match??
  305. MS query error
  306. Filter does not work
  307. Converting QIF to XLS
  308. Bradford Scale
  309. Hiding advanced filter
  310. Does Excel have an item limit when filtering?
  311. "WinForm Application" to act as "RTD Server" using .Net
  312. Auto format rows according to field data
  313. question about excel protection tool
  314. emailing excel files
  315. How do I lock a cell automatically after it has data entered.
  316. how to return non empty cells over several columns
  317. Pivot field dropping one item
  318. what is view option
  319. question about some excel restriction script running on ...
  320. I can't select/edit objects. It says [Group] on the header bar.
  321. question about some excel restriction script running on ...
  322. How to transfer an Excel flowchart to Word without grid lines?
  323. Imported Data - misinturpretted
  324. Error #div/0!
  325. Deleting multiple Macro buttons
  326. Cannot Save As
  327. Changing the Contents of a Cell
  328. Track Changes in Excel as Default
  329. A DDE error has occurred...filename too long
  330. How do I stop IE opening excel workbooks ?
  331. Terrible Excel Ruined My Chances of Graduation
  332. excel to word 2003
  333. counta function can any one explain the example counting 2
  334. please solve my pboblem
  335. I need more than 7 IF conditions...
  336. accidentally click YES to overwrite an existing file
  337. sumproduct failure?
  338. Auto Filter function
  339. Whole Number Conditional Formatting
  340. How to insert and play flash file in excel
  341. Custom Filter
  342. Clearing the Values in a Drop - Down List
  343. copy cell results and not underlying formulas
  344. Excel Backup Location
  345. To allow edit of particular rows and protect other rows from editi
  346. Look up one value and return multiple corresponding values in exce
  347. Comparing two cells
  348. Array
  349. simple equation
  350. Using VB to password protect, but sheet remains visible
  351. how to set active x control
  352. Forgotten password to open .xls file
  353. convert to specific format
  354. recovering deleted excel file from server
  355. iNSERT LEADING APOSTROPHE
  356. average 4 data from different sheets
  357. Cut and paste from Excel to AS/400 application
  358. Stumped - How to report most recent line/row?
  359. Variable sheet and Formula Sheet
  360. References And Lookup
  361. Copying SSNs to new format
  362. shared spreadsheets
  363. column to string
  364. PDF file import
  365. sperating a column in [x y z] to 3 colums x,y,z
  366. How can I calculate commissions that are not percentage based?
  367. Lost my customized toolbars
  368. colors change magically
  369. Linking info to a calendar
  370. How do I find 1 cell value from a 35 Row 12 Column table?
  371. I'm looking for info on the Excel Randomizer feature
  372. Identify duplicate coloum A cells, and merge their row and text in
  373. Calculated Field in Pivot Table Based on Two Counted Fields
  374. page break arrow remain s a cross
  375. How do I format a cell so there can be a zero infront of a # (04)
  376. importing into excel
  377. Saving Data
  378. format saving issues
  379. Finding cells with a specific number of characters
  380. How do I save an excel spreadsheet as a comma-delimited ASCII file
  381. create pairs of addresses?
  382. Time Formulas
  383. Protect/unprotect ALL worksheets in workbook ?
  384. Size of my comments keeps increasing
  385. Why can't I copy anything in my Excel documents?
  386. Refresh scenario information in a pivot table
  387. Data Storage
  388. how to make a menu selection in the same cell?
  389. Chart disappears if you hide rows/colums with data.
  390. Go back to where you were before the Macro
  391. Hiding Rows & Tabs at the same time
  392. Change block range into one column
  393. Copying and Pasting from Web Pages
  394. how do I get the frequency of letters in a column?
  395. Set external cell filter for a range
  396. Question
  397. User form and hiding spreadsheet
  398. unable to copy ss# format in excel
  399. Using Lists/Validation
  400. Userform/macro help
  401. Creating Time Sheet
  402. A Challenge
  403. Calling data from another excel spreadsheet...
  404. Auto-Refresh
  405. Assigned macros change location
  406. Filling in a form from a list
  407. .csv file Multiple columns of data in single Cell
  408. shared monthly invoice
  409. is it possible to get page numbers as a watermark?
  410. Filtering a Top or Bottom 10 result set
  411. base price list compute on to another price list? on excel work sh
  412. Hyperlink function problem
  413. Delete Row based off cell content
  414. Excel sum problem - need help
  415. how do you check and edit spelling on a protected sheet.
  416. footer
  417. Toolbars Buttons Saving
  418. Can one cell hold multiple check boxes (and then sort based off e.
  419. Macro to clear contents of unprotected cells AND drop down boxes
  420. From pricelist to productslist and vice versa...
  421. Excel comments replace author
  422. Convert latitudes and longitudes to decimal
  423. excel cell content cuts off when merged to word
  424. Files saved on CD automatically convert to Read-Only; why?
  425. scrolling though data on an spreadsheet.
  426. Run-Time error '1004'
  427. INSIDER - KNOWLEDGE NEUTRALIZING!!
  428. INSIDER - KNOWLEDGE NEUTRALIZING!!
  429. Coverting string of text into individual sums?
  430. Copy worksheet and keep all formating
  431. Screen position after hyperlinking
  432. Pick list or freeform text
  433. within a formula
  434. Vicious circle (Opening Excel attachment)
  435. hide 0 values in ptable
  436. A Search Engine inside Excel Spreadsheet
  437. want to cut data from vertical cells and paste them horizontally.
  438. Cell Formatting
  439. How can I get the 123, + or - to show on the spreadsheet?
  440. Get header only on first page of multi page excel file
  441. Errors using a new function
  442. Lookup validation data
  443. numbers to text with formatting
  444. Sending pivottables to external users
  445. Having a problem opening an xls file by double clicking after imp.
  446. Change Excel Find & Replace Options Defaults
  447. Check cell
  448. Add the inches symbol after text
  449. truncating text strings of different lengths
  450. Time Sheet
  451. How do I FFT more than 4096 points data set?
  452. rounding a calculation down to the nearest 0.5 - how?
  453. In Excel I need to set up a combo box based on another combo box.
  454. "Count If" 3 criterias are fulfilled
  455. Why does this filter not work properly
  456. Text Import Wizard: File Origin Problem
  457. Preserving Cell Height and column width
  458. Format Problem
  459. Preserving Cell Height and column width
  460. Month from a date
  461. if or statements
  462. cell formatting
  463. Pivot Table Formatting
  464. UK Excel User Conference - July 19-21
  465. Opening a workbook to a chosen sheet?
  466. Why doe this match nor work?
  467. What do i do?
  468. Variable Names in Formulas
  469. Counting dates
  470. Pivot Table - Sum Row Field Contents
  471. Pivot Table - Sum Row Field Contents
  472. how to keep a record of all my music collection
  473. If Statement!!
  474. How do I format excel if cell value is = to 0 then row height = 0
  475. SUMPRODUCT
  476. open to cell
  477. mm:ss to ss
  478. add and subtract multiple text strings.
  479. more than 255 character in one cell
  480. add a value to and then multiply values of multiple codes in one c
  481. Databases
  482. Can't save excel file. The message reads "File is locked" Why is t
  483. Make Changes in Multiple Excel Sheets
  484. Localize Access Report and Excel Template
  485. Forgot the password (to unprotect a sheet)
  486. CSV export from Excel always recognise null values in the last col
  487. I need a template for a payroll check stub
  488. Remote References
  489. Summing values in a range against specific text
  490. delete leading 0
  491. UK Excel User Conference - July 19-21
  492. How do I pull the col. index value as well as row index value
  493. Listing Common Symbols Of 2 Columns
  494. =B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.
  495. Help Command
  496. Microsoft Excel 2000
  497. tabs
  498. Pivottable - Accessing file from network
  499. about fractions
  500. subtract minutes from time
  501. Excel DropDowns
  502. Help with 65536 macro
  503. Tab key moves a whole page across, not a cell - help?
  504. Find duplicate records in Excel 2003
  505. Problem with accessing names across sheets
  506. Replacing dash in item number
  507. Can't tab out of combo box.
  508. How do I copy print formatting to multiple sheets in a workbook?
  509. Value/IsNumber/Brackets..? cell equal to range w/o Average
  510. Formulas won't drag down the column
  511. LOOKUP() misses on last lookup
  512. How do I make a header row appear at top of each page (not cell#)
  513. Rebate incentive - Multiple tier payback - Confusing if Statement
  514. Pivot Table Help
  515. Comment box appears many rows away when trying to edit
  516. How do I type a # (01020) in Excel & have the 1st 0 stay?
  517. Quick key to "merge cells"
  518. How can I setup an Excel Macro to loop?
  519. Importing files
  520. Reducing a size of the shared excel file
  521. How do you find and replace tab characters in a cell in Excel?
  522. How can I remove the tax from a total to get the pre tax value ?
  523. Comments Appearing When Cell Is Selected (Not Hovered Over)
  524. Newsgroup Protocol
  525. formula missing something
  526. Calculating Help
  527. Columns to rows
  528. Linking to named ranges in another workbook
  529. Still stuck on macro...
  530. How can I pull data from a different file from within a formula?
  531. How can I switch between two or more Excel docs with Alt-tab?
  532. cumulative time in excel
  533. Can I change the colors in the fill color chart?
  534. COM add-in's
  535. open .txt download in active instance/window
  536. Control + Home to get to A1 cell
  537. Generate Auto Order Number
  538. Question about hyperlinks in Excel
  539. Sumif of Sumif perhaps?
  540. multiple headers in excel
  541. heading on all pages
  542. Print Area
  543. Turning positive numbers to negative
  544. Data Accuracy
  545. MsQuery Documentation
  546. Excel 2003 has gone crazy!!
  547. Fill Handle
  548. Re: sumif problems
  549. protecting macros for a protected sheet
  550. right border not showing on page
  551. US & Canada Map
  552. Looking for a template..
  553. Need to scramble letters in list of words
  554. Filename.xls [Group]
  555. Autotext in Excel
  556. Open Outlook with generic message
  557. Spell check: advise and advice are used in the wrong context.
  558. Security for Viewing MS Access Databases From Excel Datasource
  559. Working out the date
  560. Turn numbers into letters
  561. Excell Problem when opening file created in another application!!
  562. counting saves
  563. Excel Nonprinting Chars Utility
  564. Unable to download and install the latest update for excel 2003
  565. Excel - returning column headers in a seperate column
  566. small "sum" function usually located @ LR screen is gone
  567. TextBox Format
  568. Pivottable - dynamically changing the range of cells
  569. Max figure help
  570. suppress duplicate leading cells
  571. countif function
  572. How to Create Shared WorkSpace
  573. Inserting Comments In A Shared Workbook
  574. Pivot Table, MS Query and Oracle
  575. resetting last cell
  576. Pivot Table Grouping by Quarters
  577. slowing down
  578. macro security warning when no maco in workbook
  579. Excel 2000 Pivot Table Calculated Fields
  580. Freeze Sections and column in a worksheet
  581. Re: #Value! How do I get rid of it?
  582. Counting items in auto filter - how?
  583. Parse contents of cell
  584. Office2000: Missing Print command in File menu
  585. Need to double-click for data to be recognised as date?!
  586. Using list option for two defferent sheets
  587. How do I use Report Manager in Excel 2003 SP2?
  588. How do I activate the right mouse click in Excel?
  589. Typing in a created excel document
  590. Check Box reference name
  591. help with macro
  592. count them number of cells between values -2 and 2 including 0
  593. convert spread sheet to pdf
  594. Rows and Columns
  595. How to extract input data?
  596. Whites To Be A Minority in the U.S. in decades.
  597. excel how do I calculate income indexed each year for 15 years
  598. Date formatting
  599. Locking down excel for Deployment
  600. keeping a shape constant regardless of changes in variables
  601. Can the author lose access to a document protected with RMS?
  602. Lookup tables with multiple columns
  603. How do I save a Word file as an ASCII format?
  604. Adding the message body to a mailto macro
  605. Can excel read my old lotus 123 files or will I have to recreate?
  606. Exporting to Excel from a program like Oracle
  607. got to be an easier way?
  608. Data Analysis
  609. How to keep formats in pivot?
  610. Percent Complete?
  611. Percent Complete?
  612. coma not separating data
  613. Can I have automatic cell population while using combo list?
  614. Re: Is there a way where I can default iterations
  615. help creating a macro in excel that opens a specific word document
  616. can this be fixed to find for next name
  617. Running Average
  618. excel timesheet nested if statements
  619. Header Rows and Sort Issue
  620. repairing office failed Others are working not excel ?
  621. Excel Restricted
  622. How do I change order of rows in pivot table?
  623. Formula reviewing box disappeared!!!
  624. cannot empty the clipboard
  625. Excel becomes sluggish after print preview
  626. Average Time Format
  627. Excel should allow two or more cell painters set to diff colors
  628. Excel should allow two or more cell painters set to diff colors
  629. How to merge excel and word documents
  630. Stop Recalculating?
  631. shortcut keys for validation
  632. Can't insert worksheet in excel workbook?
  633. Convert numbers into leters
  634. How can I pull data from multiple user workbooks into one?
  635. Diagrams
  636. Change default format for 'Comment'
  637. VLOOKUP in a macro??
  638. Less than/ Greater than logic flipped.
  639. Counting
  640. How can I open from Web Excel Files in a separate Window?
  641. excel database statistical functions (DSUM etc..)
  642. Min Max
  643. Variable in Excel Sum formula
  644. copy paste delete cell contents
  645. Change data in a single column from "last, first" to "first last"
  646. Counting characters
  647. how to change linespace in excel ?
  648. XIRR and negative IRRs
  649. Quick English to VBA
  650. Password Required to View\edit a Sheet in a Workbook with Many She
  651. Counting Cells
  652. Changing certain text within a cell
  653. How do I enter a title in the top row of an Excel worksheet
  654. RE: Excel Workbook file increaseing in size
  655. How Do I Assign a Toolbar Button to a Custom Number Format I creat
  656. Importing Formatted Data
  657. Print question - Calling Dave Peterson!
  658. subtracting value from inventory as it's used
  659. RE: Print question - Calling Dave Peterson!
  660. merging multiple files
  661. Sorting by Groups
  662. Challenge: Unique Values via Formulas
  663. How to use VLOOKUP to copy range to another workbook?
  664. Min Max Editing
  665. Problem opening Excel file
  666. Replace with single tick - formula too long....
  667. Update External Data source from Excel sheet
  668. How to protect some cells, but able to insert rows elsewhere?
  669. ControlTextTip
  670. Conditional Formating
  671. Search and replace chunks of html code
  672. How do i save a 12 digit number in a .csv document in excell?
  673. transposing and linking cells
  674. How do I format cells to accept stones and pounds?
  675. How to duplicate data in excel
  676. Need help setting row height with wrap text.
  677. Automatically change tab colour
  678. Calculating time between values (tricky Problem)
  679. Selecting/Adding data from Multiple Worksheets
  680. Hiding Rows
  681. Saving files with a list of values
  682. change font
  683. how can I see a .xll code.
  684. How to preserve formatting with vlookup
  685. IF/INDIRECT Limitation
  686. how to convert multiple XLS files to CSV?
  687. Date Format
  688. How can i write 2 lines of text in one cell?
  689. little problem with lookup i think
  690. How do I start excel without a CD
  691. Option Button
  692. Opening Excel with text box form fields
  693. Can i print non-contiguous areas on one page??
  694. Hyperlinks breaking when save/reopen file...
  695. Print Array for hidden sheets using VBA
  696. Adding Scale to Chart
  697. why don't buttons in the header dialog box show screen tip?
  698. formulae
  699. Borders using key board short cuts
  700. Less than/ Greater than logic flipped
  701. Word Forum
  702. I need a continuous 30 day calendar to track overtime worked.
  703. Macro to find copy "header" and paste
  704. Is there a template to track invoices billed and received
  705. Copying a Excel workbook to CD
  706. Are excel and Outlook linked??
  707. Text recognition
  708. Calling for pages before they are created.
  709. I can't move my page breaks in Page Break Preview
  710. default font
  711. How do I set up Mail Merge using an Excel template (an invoice) ?
  712. Pasting over hidden columns
  713. Unwanted page breaks
  714. Where did my data go?
  715. Excel file 4MB.Copied sheets to a new file.Now=64Kb-easier way?
  716. I want to convert USD to Euro?
  717. convert date format
  718. Custom Filter not functioning
  719. hOW DO i SUBTRACT COLUMNS IN EXCEL?
  720. RE: Date and Time
  721. RE: convert date format
  722. Can install add-in; missing SKU112.CAP; what is this? How fixed?
  723. Excel worksheet print out
  724. Validating
  725. How to prevent Excel converting imported fractions into dates
  726. Date and Time
  727. hide #N/A in multiple cells
  728. RE: hide #N/A in multiple cells
  729. In EXCEL, how to use INSERT/NAME subcommand CREATE?
  730. excel formual needed
  731. RE: Excel worksheet print out
  732. I have never written a macro
  733. RE: Where did my data go?
  734. Formulas
  735. RE: hide #N/A in multiple cells
  736. Personal.xls
  737. Doc to excel
  738. Automation 2-Part Question...
  739. Scroll bars: how can they be rotated?
  740. hyperlink to sheet in workbook saved as html
  741. How to recover Excel file from corrupted C: drive recycle bin?
  742. Cannot open some of my Excel files shared with Dell Axim.
  743. date format
  744. excel save to web
  745. RE: excel formual needed
  746. RE: Excel worksheet print out
  747. Lock a Cell as Capitols only
  748. RE: date format
  749. Help me out
  750. Protecting spreadsheets
  751. RE: hOW DO i SUBTRACT COLUMNS IN EXCEL?
  752. validation lists from seperate work books
  753. ADO Transfer from Excel to Access
  754. How to get Research button on my standard toolbar?
  755. RE: In EXCEL, how to use INSERT/NAME subcommand CREATE?
  756. Can you merge non-shared workbooks?
  757. Keeping a cell reference.
  758. How do I prevent all excel applications from closing at once?
  759. How to open Excel spreadsheet when forgotten password
  760. RE: Excel Workbook file increaseing in size
  761. Logic of this formula =SUMPRODUCT((A1:A4<>"")/COUNTIF(A1:A4,A1:A4&
  762. How do I average a column?
  763. if?
  764. Help with changing a Macro
  765. How do I remove the gray paint (haze) from my text?
  766. Formula Help
  767. Clip Art / Picture
  768. RE: hide #N/A in multiple cells
  769. message recieved??
  770. Why do i have problems converting Excel to PDF?
  771. RE: excel formual needed
  772. Excel Sheet is not viewing the same in Print Preview
  773. applying borders to cells using keyboard shortcuts in excel
  774. can you link outlook to an excel spreadsheet?? How!!
  775. RE: validation lists from seperate work books
  776. how do i load a dechex macro? and from where?
  777. RE: message recieved??
  778. RE: date format
  779. RE: I want to convert USD to Euro?
  780. Moving from one sheet to another
  781. RE: hide #N/A in multiple cells
  782. xla created in Excel 2003 won't run in Excel 2000
  783. Unwanted page breaks
  784. RE: Moving from one sheet to another
  785. RE: convert date format
  786. RE: Formulas
  787. does formating cells significantly affect file size?
  788. Transfer data from Excel to Access
  789. RE: How to open Excel spreadsheet when forgotten password
  790. RE: Help with changing a Macro
  791. RE: Clip Art / Picture
  792. RE: I have never written a macro
  793. Date Function in Excel
  794. Thousands of possibilities
  795. how to find the gcd of two numbers in ms excel 2000
  796. Report a given number in days:hours:minutes ?
  797. transpose and formulas
  798. dropdown menu or Jump menu
  799. MATCH() irritating feature?
  800. Copy code to a new spreadsheet
  801. need help please....
  802. Sorting Data with External References
  803. How can I lookup a cell that's to the left?
  804. IRR&NPV Financial lease
  805. How do you print just certain columns??
  806. Avoid duplicate number entry when only start and stop numbers given.
  807. Print cell borders with special 'skin'
  808. Pre-1900 dates
  809. Forgot excel file password
  810. Protection
  811. Retrieving Worksheet Name
  812. pivot table primer course
  813. Extracting using seperators
  814. Arrow Keys Acting Wierd
  815. Vlookup
  816. Prevent Copying Data
  817. Pivottable to count non-zeros
  818. Enter Time in cells
  819. Calculating average annual change in real estate value
  820. Email Document
  821. "Random selection between two cells"
  822. getting an excel file to run as an executable
  823. When I add cells the sum is coming up $0.00
  824. RE: When I add cells the sum is coming up $0.00
  825. How do I get "&S" to just be "&S" text instead of strikethrough?
  826. Corrupted Pivot Tables
  827. Copy only new rows
  828. Display result of formula in header?
  829. Splitting text into 2 collumns
  830. how do I change autocomplete sensitivity
  831. Tidyup of IF formula
  832. Data values WON'T DELETE in PivotTable drop-downs
  833. How can I make Outlook Express my primary email for excel?
  834. how to flip a column upside down
  835. moving quarter attendance tracking
  836. Moving contacts from one list to another
  837. Formula or Macro Help
  838. Importing Word doc into Excel
  839. Cool Feature - How do I do it?
  840. Excel Web Page with Hyperlinks
  841. how do i vlookup and move down a cell as well.
  842. copy formulas
  843. Sumhours at end of the week
  844. extracting just numeric value out from alphaneumeric cell
  845. editing an excel 97 file within excel 2003 and saving back as exce
  846. How can I save an Excel file which says it's a Read only to a CD?
  847. Hiding the cursor
  848. Filter
  849. Templates/Forms/Boxes in Excel
  850. Excel 2003--How do I change the color of selected items?
  851. I need an academic school calendar for 2006-2007 with a place for
  852. Totals calculated by date
  853. if statement
  854. Outline Styles
  855. Refresh advanced filter
  856. How can I show in a given cell a lowest number in a column?
  857. Hot key for time?
  858. How can I stop my files keep re-paginating every time I save?
  859. Print Formatig
  860. Faulty Page Tabs
  861. date formulas
  862. Advice on Automating Task
  863. Can rows/columns Automaticly Grow/Shrink?
  864. Sum by date rage using multiple sheets
  865. Graphs and VBA
  866. copy/pasting from document to excel
  867. Average of Unknown Range
  868. COUNT forumula problem
  869. Filtering out old records.
  870. working with conditional and lookups
  871. Simplified Data Entry
  872. How can I fix HYPERLINK(B2,E2) to the resulting text and link?
  873. Weighted Tally qtys
  874. Sorting with AutoFilter
  875. Change Chart Bar or other Colors
  876. Named References
  877. Updating Records from MS Access
  878. blank list
  879. Simplifying formula
  880. Selecting rows based on cell entries
  881. separatate
  882. Word could not parse your query options into a valid sql string
  883. Not sure how to format this if statement
  884. Conditional Formatting
  885. time sheet
  886. Excel
  887. Validation Drop Down Box
  888. Vlookup Col_index_num
  889. I WANT TO CREATE MY OWN SHORTCUT KEYS
  890. Group & Outline and Recalculation
  891. How to choose from a list that includes blanks?
  892. How do I retrieve changes to an unsaved excel document
  893. correction
  894. What is "Problems during load"?
  895. How to import Yahoo historical data directly into spreadsheet?
  896. How do I undo write protected to excel sheet send to floppy disk
  897. prices
  898. [Q] Question on using Excel
  899. name of icon that collapses dialog box
  900. Showing Last value in a cell
  901. Learning Macros
  902. LOOKUP w/ multiple search columns?
  903. Curious operation of Paste
  904. userform that add data in all w/sheets
  905. Do I need to use a Query
  906. Help! Lost Data with Fill Command!!
  907. [Q] Question on using Excel
  908. How to schedule a pivot table in excel 2003?
  909. Using "mailto" function in a macro
  910. Calculation is incorrect
  911. triggering an email alert from within a spreadsheet based upon a d
  912. Coverting seconds into hr:min:sec
  913. Formula
  914. how can i make excel sum up the number of letters i have in a row?
  915. How do I use a vertical look up to adjust a graph format?
  916. "Add to Favourites" icon
  917. How do I set up "Add to Favourites" icon in Open screen?
  918. 2 row that wont scroll down
  919. why can't I setup a macro to run Pivot Table?
  920. Formulas
  921. can i print out bubble sheets using excel data?
  922. Mystery Cell
  923. australian date format
  924. Conditional formatting
  925. Auto-generating a list of records that meet a pattern criteria
  926. Age calculation
  927. need to retrieve dates from lookup
  928. Need help creating forecasts informed by previous performance
  929. Budget Planner,Allocator
  930. publish
  931. Is there a quick way to delete all the controls in a range?
  932. How do I eliminate every fourth row of data in a large file?
  933. IRR FUNCTION LIMITATION ??
  934. simple i am hoping with macros
  935. Sorting by looking for blanks
  936. Row insertion - lost forumlas
  937. Getting rid of a circular reference error message
  938. Formatting?
  939. Need to insert file modified date of Excel spreadsheet in a cell
  940. Hiding Rows Leaves Labels Blank
  941. Re: Easy IF Function
  942. Security update KB905756 problem with Excel 2003
  943. changing options in delete dialog box
  944. Dashes in my result
  945. Password protect a hidden tab
  946. ANY IDEAS FOR A FORMULA TO KEEP A TEAM BOWLING SCORE
  947. Excel formula
  948. Counting different items in one column
  949. Sum based on date range
  950. How do I combine and match data from 2 sheets
  951. Cell pattern
  952. how do i add a footnote number
  953. How to insert rows after each row of data (800 rows)?
  954. I have a math problem in Excel.
  955. In Excel make the tabs a the bottom stack vertically.
  956. RE: Cell pattern
  957. RE: How to insert rows after each row of data (800 rows)?
  958. First ever task
  959. how to sum inventory, subtracting as it's used
  960. How do I copy text and values from the same workbook onto a different sheet??
  961. spread sheet disappears
  962. Iteration frustration
  963. curing the blocking of cells.
  964. Having two X-axes on same chart
  965. hourly rates
  966. numbers with 0 prefix
  967. Macro to copy, paste in a range and then delete
  968. Excel 2000 ActiveX Control Problem
  969. Updating Excel sheets with a file download?
  970. Data Sort
  971. date is automatically converting
  972. Tab Names
  973. How can I add duplicated items in a list? Help!
  974. How do I copy an absolute column and relative row to the right?
  975. User Form
  976. Ctrl-End (not Ctrl-Ed)
  977. font color for formula answer
  978. Crl-Ed : another way to mess-up and fix
  979. convert columns into rows and columns
  980. Replacing a random string of 5 numbers
  981. In Excel how can I filter multiple columns SIMULTANEOUSLY?
  982. Baseball statistics
  983. Excel Auto-Format cell to email format
  984. using sum(if function
  985. Are you kidding me??? Are you telling me I can't sort format: dddd, mmmm dd, yyyy?
  986. Concatenate
  987. Removing non text characters from spreadsheet
  988. Excel auto recalc is occuring with no change to data. Help!
  989. Toolbar should not load at startup
  990. Percents and Text in one cell - need to add percents only
  991. Updating links to closed workbooks
  992. search algorithm sucks
  993. Excel should allow purging since-deleted PivotTable field values.
  994. How do I stop the User names in comments from appearing?
  995. How do I sum numbers thru specifying the amount from another cell?
  996. How do I get a separator line between buttons on my custom toolbr
  997. Vlookup and left function
  998. Is there any way to have a maco click a command button
  999. Pivot table data
  1000. How to split a value seperated by comma?