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. Sort multiple columns on all worksheets
  2. Excel rejects XSD from Visual Studio DataSet Designer
  3. vlookup problem
  4. Past Date Calculation
  5. File extensions
  6. Excel header different on multiple computers.
  7. Mixing text and formulas in the same cell
  8. How do I recover replaced file in excel?
  9. Graphing data from multiple worksheets in same workbook
  10. Office 2007
  11. Missing sort ascending or descending when go into "data" "sort"?
  12. Why does my excel to word mail merged doc not merge last entry?
  13. Macro - Excel 2003
  14. How to put Zero in a cell
  15. Excel 2003: Conditional Formatting using "MIN" & "MAX" function
  16. Adding Counter to column for number of identical file numbers
  17. Formula for value of a cell when the cell answer has comma's in it
  18. numbers convert to text??
  19. sorting
  20. converting fractions to decimals
  21. Embed email address into worksheet
  22. How many days the ready stock+expected stock will last as allocate
  23. Counting characters in a cell
  24. Help me please understand this Visual Basic command
  25. XLS to Lotus 1-2-3 Converter for Excel 2007
  26. trying to make a cell either blank or zore value
  27. Email excel spreadsheet - embedded in email
  28. automatically updating a date
  29. Last available column in Excel 2007?
  30. pivot table counting
  31. Need Help sorting/filtering a column
  32. Can't access Print Titles (Excel 2007)
  33. Excel to Word
  34. using values entered in cells to determine a result in another cel
  35. Using more than one column for criteria
  36. Public Function Remarks
  37. finding common numbers
  38. sort numbers
  39. Paste Special throwing an error
  40. All of worksheet's data is not visible (hidden), upon opening file
  41. Hyperlink Codes
  42. if formula return
  43. IF Function Returning Range
  44. If weekend date display previous Friday date
  45. Sorting 2007 data
  46. Transfer Spreadsheet problems
  47. Formula to count occurence between two rows
  48. Monitor goes offline for a few seconds while using Excel spreadshe
  49. Conditonal Formatting
  50. Min in array formula
  51. Font size consitency when using text boxes
  52. Formulas between 2 workbooks
  53. Condtional formatting in Excel
  54. want to erase the 0
  55. Drop box arrow position on cell
  56. Code to hide tabs based on input
  57. comparing 2 columns for matches
  58. Reporting from data into grouped ranges..
  59. Set print area and print it on one page
  60. Auto fit to content
  61. Range-name Behaviour
  62. Conditional Formatting
  63. Multiple formulas in Pivot Table
  64. in excel, i want to show a value over a certain figure
  65. Multiple choices from lists of valid data
  66. Data validation accepts illegal entries when one spreads values
  67. <ASK> How to add columm more than the default columm IV
  68. activate mutiple links
  69. IF,AND,OR
  70. SumProduct
  71. How to change font colour in unlocked cell of protected sheet
  72. Transpose a col to a row?
  73. Excel Huge File.
  74. how to lookup a value for a value
  75. Combing cells and entering them in a different workbook
  76. search text string within array
  77. Find and extract text from cell
  78. Pull down lists
  79. Macros in Excel
  80. Linking files in excel
  81. option buttons
  82. headers and footers
  83. IF Function returning range
  84. Office Assistant
  85. Cannot insert new worksheet
  86. Formula for kanban cycle usage
  87. How can I make multiple hyperlinks active at one time?
  88. UDF vs. Mega-Array-Formula
  89. Combo Box Contents Resize Themselves?
  90. NAME function working in reverse??
  91. Can't copy formulas in a worksheet
  92. Is it possible to convert a .pdf file to an excel template?
  93. IF function using TIME
  94. date converted to days
  95. Excel
  96. For Each VBA to sum
  97. Math Calculation
  98. Input Box Cancel
  99. I mail merge excell into word, but date displays numbers instead
  100. #of days remaining to the EOM
  101. Pivot Tables
  102. Printing code
  103. go to fitst column of next row when enter (or other key) is presse
  104. formula for going to next row first column on enter
  105. Filling Formulas Horizontally
  106. Gridlines are there, then Custom View, gridlines disappear in xl 2
  107. adding data to a page with multiple columns
  108. Opening files
  109. Dissapearing tick box
  110. limiting text entry of columns
  111. Is there a loan amortization schedule with balloon at final pmt?
  112. vlookup with hyperlink in formula
  113. Time formula (difference of predicted and actual time)
  114. Can I change subtotal default settings from count to sum, for exam
  115. changing table cells colours using a master table
  116. Problem installing Excel 2007 Web Data Add-In
  117. Linking Workbooks
  118. Connected from Excel to Access
  119. Sort worksheets by cell content
  120. drop down boxes on left hand side of workbook
  121. Pivot tables: disappearing data fields
  122. Reversing only the vertical axis in a diagram
  123. What do the underlined letters in the drop down menu's mean?
  124. Help
  125. conditional printing
  126. Copying data across worksheets
  127. Import to excel
  128. How to determine the number of weeks at this moment?
  129. The formula result is 76% but the cell shows 0%. Why?
  130. conditional formatting
  131. Why macro runs on the same sheet?
  132. extra data for pivot table
  133. how can i use series autofill when I use autofilter?
  134. conditional formulae
  135. Latest date for each of the year
  136. run macro hyperlink
  137. Lookup across workbook
  138. Calendar
  139. I'm having formula issues
  140. Formula to count
  141. gang remove blank rows
  142. How do I save a 2007 ex file so another party can open with 2003
  143. #N/A
  144. Excel file corrupted when saved or retrieved over network
  145. KEYBOARD ARROWS SCROLL INSTEAD OF MOVE FROM CELL TO CELL!!
  146. monthview object or ??
  147. How do I generate Stem-and-leaf display?
  148. Autofiltering again
  149. Autofilter expert needed.
  150. Fill Colour
  151. Totalling "Yes" or "No"....
  152. How to retrieve the values within cells?
  153. Cursor replaced with cross symbol
  154. Chart Wizard
  155. separation of text and numbers in an unmerged cell
  156. Lost sheets in Excel 2007 compatability mode
  157. reactivate DialogBox
  158. Insert "-" in already fill cell
  159. Extract Some Correctors from a cell
  160. Date Formats
  161. Variable print area via a macro
  162. drop down menu for excel 2007
  163. Too Many Line continuations
  164. Excel 2003 vs. 2007
  165. IF formula with conditional formating help please
  166. how do I mail merge data base from Excel to word
  167. How do I restore cell gridlines lost after coloring a cell?
  168. Automatically open list box on entering the cell
  169. Pls help me out with Share Workbook
  170. date function
  171. WEEKNUM gone...
  172. Hyperlink - reference not valid
  173. Making a Conditional Formula UNConditional
  174. Selective on Name
  175. variable in a chart macro
  176. How to expand data when mailmerging
  177. Hide & Show Rows based on Check Boxes
  178. Assigning a currency symbol on the fly
  179. Protected sheets in a excell spreedsheet
  180. Tab password to view
  181. if font is bold then cell value is number
  182. how do I reset my toolbars they are too small
  183. I need a log/accounting sheet for servicing vending machines
  184. How do you digitally sign your own macros?
  185. Column width of Pivot Table data goes back to default when data refreshed
  186. STOP Auto Calculate
  187. IF statements- HELP needed. Please :)
  188. bar code scanner
  189. Two sets of option boxes? two separate reference cells?
  190. How do I convert dates mm/dd/yy to general and still look the same
  191. Sumif....date in table is greater than compared to date
  192. Filtering question
  193. data validation, totaling values based off dropdown lists
  194. Conditional formating
  195. Using IF Function on Dates
  196. Getting #DIV/O. Can't find a solution
  197. Conditional Formatting - For 1 cell based on contents of any cell
  198. Frustrating options in Excel vs 2003
  199. Unable to view column A in spreadsheet
  200. Hidden Characters?
  201. formulas
  202. Active-X Control ToolBox
  203. Changing Source Data in a Formula
  204. Any advice on combining Excel and Word documents into one PDF?
  205. Excel to Publishing
  206. please help
  207. Copying Workbooks and keeping the formulas only?
  208. Binary integer non-linear programming excel solver
  209. return the 2 diget year value
  210. Display hidden worksheets
  211. Combo boxes Help needed.
  212. Screen flickers and text disappears/moves??
  213. How do I limit entry into only 1 box of 10 choices available
  214. fill color
  215. Using filename retrieved from GetOpenFilename
  216. data valiation, dropdown list question
  217. keystroke to type the Ø symbol
  218. Does anyone have a template for keeping football statistics?
  219. Excel Windowing
  220. Conditional Formatting and IF function help
  221. display contents of preceeding cells consecutively
  222. Screen goes blank
  223. Link control to Excel cell to click a day in month to return date
  224. Excel color scheme
  225. Help With Formatting
  226. Automate Macro
  227. fix rows together
  228. Conditional Formatting
  229. Embedded Obects
  230. Adding a blank row between values
  231. entering formulas in Excel 2007
  232. Conditional Formatting
  233. Hyperlinks in a Pivot Table - can this be done
  234. I have a symbol on my screen I don't know how to get rid of. Help!
  235. Aggregate tables
  236. Difference between three numbers in percentage
  237. Change Text Color in one cell based upon entry in referenced cell
  238. I can't get my formula to do what I want it to do..........HELP!
  239. Why in excel does 41202.80721 get changed to 41202.8072099999
  240. Changing name ranges
  241. Hide cells
  242. Appropriate use of cell reference when creating macros
  243. sumifs formula compairing data on different lines
  244. Combining spread sheets with common fields
  245. how do I change color with 2000?
  246. Excel Protection Help
  247. sumif problem
  248. Automatically put rows containing a number in numerical order
  249. how to automate excel file sending by outlook from within the file
  250. Sorting in Excel 2007
  251. ACTIVECELL LOCATION
  252. Excel helpgroup
  253. Percent of use
  254. Copying a formula down a summary sheet
  255. Changing Data
  256. Pivotting? Transposing? Normal Forming? Crosstabbing?
  257. Excel 2007 crashes on entering data in a specific range of cells
  258. Prevent pivot tables from automatically resizing
  259. Changing font color of protected cells programatically
  260. Help with Conditional Formatting
  261. Need a well formulated spreadshhet
  262. Excel help for hidden columns
  263. How do I reformat a 6-digit date to general & look the same?
  264. sheet tabs disappeared
  265. Difficulty Loading Analysis Toolpack in 08
  266. establishing a logical path for manufacturing
  267. Double Negative in formulas
  268. An error msg in Excel 2007 regarding Linking but no linking in fil
  269. Unexpected message when first opening this 2007 Excel file
  270. freight calculator
  271. Diagnose and repair a problem file
  272. In Excel when I want shortcut to go to last entry
  273. CF for next month/this year
  274. linking many workbooks
  275. Display "macro-free workbooks - VB project message" on closing Exc
  276. Multiple IF Function
  277. Is there a limit?
  278. What excel function can I use in making a form that auto populate
  279. Excel opens two workbooks
  280. Merging Cells
  281. Analysis Toolpak
  282. Data Validation, drop list question
  283. Excell will not show the color palete or highlighted colors.
  284. Changing the range for my drop down menu
  285. Sorting random Data created from a random formula
  286. Multiple case in a spread sheet
  287. how do i sort a data sheet which has images in it also?
  288. Using Excel to autopopulate color..
  289. MOD and Ceiling formula used to round up and down to 49 and 99
  290. Lists
  291. Database problem to be solved... Please help!
  292. Lists on a protected worksheet
  293. Setting up Treasure Hunt spreadsheet
  294. Why would wks files be blocked by my registry policy setting?
  295. The content of my excel worksheet is missing
  296. Selected cells show up as very light gray? Can I darken?
  297. prevent sorting from moving rows/colums out of order
  298. possible to record vba editing as a macro
  299. Import Access Table into Excel. I appreciate your assistance. Thanks!
  300. How can I 'CountIf' alternate cells?
  301. Conditional Drop Down List
  302. Copy command is slow in 2007
  303. Hyperlinks in cells in a protected worksheet not working
  304. Subtotal Question with a twist
  305. count question
  306. Cell Formatting
  307. Picture in Header
  308. single worksheet, multiple pages - subtotal
  309. Display issues in Excel 2007
  310. Saving changes to protected Excel spread sheets within Outlook 200
  311. TextBox on a userform - format to currency & percent
  312. division problems in exel 2007
  313. UserForm TextBoxes - Is there a way to format as currency or perce
  314. Group of column can't be expanded or collapse after I set a protec
  315. plz help
  316. Using Excel 2007 how do I change mouse direction
  317. Between Formula???
  318. Excluding Text combined with numerical value in EXCEL 2003
  319. automatic sorting
  320. Indent based on Entry
  321. Help - Please If, And = #Value!
  322. Formula
  323. Office Open XML Formats
  324. I lost a Spreadsheet : Can I search by the DATE I saved it?
  325. Need a formula about time stamp....?
  326. Wrapping text in cell.
  327. Convert list of events to calendar format
  328. Listing Text From Separate Cells into One Cell
  329. Wrong Directoin
  330. How can i find out the last row when I do autofill?
  331. R1C1 switching automatically.
  332. Pivot Table grouping
  333. Why does the cell turn yellow when entering a number?
  334. matching up columns
  335. Excel error message
  336. absolute cell references
  337. Sort by dropdown list
  338. How do I combine dollars and text
  339. Does excel keep temporary versions of previouse workbooks once i s
  340. Always save as
  341. Inserting rows and adding to total worksheet
  342. IF Statement
  343. If Statement
  344. If And Or Formula
  345. Compatibility Mode Conditional Formatting
  346. Spell Check using All Caps
  347. Change data source for MS Query
  348. Add new order
  349. multiple value in row
  350. Can I import SQL Stored Procedures into Excel?
  351. Slow performance on office 2003 in windows vista
  352. if the value of a cell is between 2 values
  353. Help with pulling data based on latest date for a year
  354. Data points on Line graphs
  355. contents of cells to rows
  356. Changing the order of fields in a query
  357. changing the path behind a button
  358. Delete coloum in VB
  359. Help with LOOKUP
  360. Concatenation
  361. #Num! appears at the end of correct entries
  362. Numbering rows with filters
  363. Pasting current view
  364. MS Excel
  365. Limit to number of opened Read Onlys
  366. How 2 do expand/collapse Groupped Columns after worksheet protecti
  367. Formula for CF to color current month
  368. How can I change two cells (with same info) at once?
  369. why do some cells show up as XXXX's on a shared drive
  370. I have a feeling the order of my formula is out of order....HELP!
  371. Only Cells with positive answer to IF formula
  372. Formula to check if a date is a holiday
  373. Page breaks around every cell (Excel)
  374. link data
  375. Help with a formula: Tammy
  376. Need to find and return value in cell from multiple worksheets
  377. Merging a hyperlinked cell with a non-hyperlinked cell?
  378. rows
  379. Dragging cells
  380. How can I round a number in Excel to the nearest 5000?
  381. convertin html format to number format
  382. Unsave or get a previously saved file - HELP PLEASE!
  383. How to remove row duplicates
  384. Row Height - Auto-Fit
  385. Cell does not expand to fit text
  386. Opening xls files in Excel 2007
  387. Formatting functions in a workbook
  388. maximizing workbook
  389. format a date to text
  390. A conditional lookup question.
  391. Formula result in multiple cells
  392. Using Excel values in Word Mail Merge
  393. Nested IF Statement Help
  394. PivotTables - Calculations based on generated summary data
  395. If And Formula
  396. Cell Format
  397. Moving decimal point
  398. Is it possible to export an Excel 2007 chart as a vector graphic?
  399. Using contents of a cell as the sheet name in another formula
  400. Lost "Mailing" tab across top of Excel - Need to do e-mail merger
  401. Formatting Questions
  402. Displaying Cell Contents
  403. Modifying Tick Marks on Comination Graph
  404. Need help with combining cells to one
  405. Copying worksheet cells into another worksheet using autofill
  406. Color Code Duplicate items.
  407. Why do my arrows and shapes not print where placed in a worksheet?
  408. Excel keeps selecting two cells
  409. Please Help :)
  410. average with zero
  411. pivot table - dragging fields
  412. Formula for interest
  413. Is there any way to create a folder structure for tabs in a workbo
  414. Excel to Excel Mail Merge?
  415. Combining Data
  416. How do I set up an IF formula with multiple qualifiers?
  417. Correct IF formula??
  418. Cell Selection
  419. Paste Special
  420. How calculate a MIN excluding the 0 values
  421. Tab color change
  422. Formula in Conditional Formatting
  423. Formula for annual average from monthly data
  424. 2007 - Open file doesn't appear
  425. average
  426. Customized colours
  427. Counting occurrences with conditions
  428. Formulas
  429. cell values/automatic updating
  430. 2008 East Coast U S Excel User Conference
  431. Average (exclude 1 min & 1 max Value)
  432. Tab Color Changes depending on value of a cell
  433. NAME function
  434. Why can i not delete cells in my workbook?
  435. deleting rows using lists of names from another sheet... please he
  436. Margins do not fit page size
  437. How to convert........
  438. PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ???
  439. Format Cell as custom type but data doesn't display like I custom.
  440. Seperate Alphabet and numbers in a cell
  441. Can I use Excel /Microsoft Office to manage Leases for monthly bil
  442. how do I make a check box larger?
  443. How to calculate Hours between two dates?
  444. Retain Defautl Cell Format in Template
  445. Super & Subscript
  446. Convert Time to Days
  447. Read data from a Row to a Column
  448. Convert hrs to date but 1day=7.5hrs not 24hrs
  449. Help with Date formats
  450. Help with a formula
  451. how can i show/print just populated rows from a list
  452. Paste Special in protected sheet
  453. rounding decimal places
  454. My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns
  455. Combining VLookup and IF statements
  456. audio alert when a shared workbook is saved by any user
  457. Automatically skipping cells when pasting data
  458. No data in MS EXCEL 2003 Normal View
  459. Formulas
  460. Complex search, copy, and move opperation. Please HELP!!!
  461. Looking for @
  462. Drop Down List
  463. Cut some of the data in a cell and move to the neext cell
  464. Tracking Data
  465. Macro for color coding
  466. Writing a formula with a constant
  467. Copy a Formula from a Column to a Row
  468. How do I add "@" into a field without making it concatenate?
  469. Consecituve Numbering
  470. display list or word
  471. Visual Basic Error Run Time Error, Type Mismatch
  472. Conditional Formatting an entire row based on one cell's value.
  473. Create a macro so when I click the icon, the response is the A1 ce
  474. Using Excel PivotTable for a huge DataBase from External Data
  475. Prevent deleting functions
  476. Hlookup help
  477. Creating a special macro
  478. Numbers being Auto Date Formatted
  479. data from one workbook automatically entered into another workboo.
  480. need to retrieve data that was saved in error
  481. Lookup issues
  482. sumproduct
  483. Modify a formula?
  484. vlookup other workbook
  485. Summarizing Forms
  486. reorganizing imported spread sheet
  487. I have an excel file that I can not maximze.
  488. Create my own ticker
  489. Floating a pie chart in my spreadsheet?
  490. how to preview & print a sheet with part of filled & empty gridlin
  491. searches in Excel
  492. linking photo to cell?
  493. Pivot Table - Unique Characteristics
  494. How do I automatically insert rows
  495. Setting Field Size in Excel 2003
  496. Save workbook every 5 minutes in Excel 2007
  497. Conditional Formatting - Excel 2003
  498. reset the scroll on the right side
  499. Format text to general
  500. Excel 2003 Pivot Table
  501. Copy and Paste between workbook
  502. Repeating information throughout a worksheet
  503. Why does "cut and paste" cause #REF! errors?
  504. replacing one number with another
  505. How do I write an excel formula with a text answer ("yes" or "no")
  506. How do I automatically copy/paste ?
  507. Alternative for =countifs (in 2007) for Excel 2003
  508. deleting rows conditional... help!!!
  509. get data from multiple spreadsheets into another
  510. Formulas only calculate a result when there is matching data in ce
  511. If Statement
  512. Excel 2007 Auto Filter Filter
  513. formula to find highest value of a vlookup reference
  514. Strange Page Break behaviour while AutoFilter enabled
  515. Vlookup Problems
  516. Hyperlinking to another worksheet in existing file
  517. creating a loop
  518. Pivot Table ?
  519. Macro to Open Daily Report
  520. SUMIF(S) not available on Excel 2003
  521. Hi, i want to download some other Help assictance other than in ex
  522. Excel 2007
  523. How do anchor a file to a location so no one can shift it?
  524. Data validation list decreases as the user chooses from the list/s
  525. merge and center in Excel not highlighted
  526. Add cells which have common Row and Column headings
  527. Can I change Excel 2007 to 2003? I can't stand the new version.
  528. Justifying Text in a cell
  529. 2 sets of =if strings in excel 2007
  530. Criteria
  531. Formula result not displaying correctly
  532. Combining Text from multiple workbooks
  533. Data Validation - repost
  534. Can I uninstall Microsoft excell without loosing my excel files ?
  535. stop a cell from repeating its value continually across the page
  536. How do I convert text to speech?
  537. exel
  538. I want the 2003 toolbar on my 2007 version. Is that possible?
  539. how to sum "unique" samples
  540. referencing date so you can use A value or B value in a formula
  541. Help, it's late and I am being thick
  542. Getting rid of a VALUE error
  543. Counting number of times a value occurs
  544. Allow only nummeric values
  545. Creating a loop
  546. Deleting rows by specified criteria for duplicates
  547. Data from Web
  548. Clearing numbers in excel
  549. Excel files on the start bar
  550. Protect worksheet but expand and collapse outline?
  551. Excel 2003 - How to print a large worksheet that is actually readable
  552. convert text to date
  553. Printout looks different than screen - Excel 2007
  554. ActiveControl problem
  555. How do I suppress the time in m/d/yy date column?
  556. Only Show Checked Items
  557. Strange autoformat occurrence
  558. Change Excel Template in Excel 2003 Using Vista
  559. summing occurances of text by fiscal month
  560. IF and Vlookup
  561. conditionally formatting comments
  562. Can you create a folder in Excel workbook to hold related sheets?
  563. TIMER
  564. Built In Name Error
  565. outlook calender
  566. Macros in 2007
  567. Excel, insert emails
  568. Emailing individual sheets in workbooks on Office 2007
  569. Using one file to make changes in another file
  570. Macro to Protect the Whole Workbook and Allow Range Edits
  571. cannot insert additonal worksheet -only 14 tabs in file
  572. Is there a way for excel to see if a date is in a specified range?
  573. how do I make changes to the default Excel template?
  574. ADD ITEM TO A DROP DOWN LIST?
  575. Help! Array formula for data that uses words instead of numbers
  576. Custom Views Error Message
  577. Updating formula as tab names change
  578. Excel 2003
  579. Inserting Interactive Excel Form into PowerPoint
  580. Calculation of future dates
  581. Gather data from multiple excel files into one master excel file
  582. Merging Excel Worksheets
  583. Cells lose border
  584. Vlookup Help
  585. Re-open worksheet saved as PDF?
  586. Counting Entries between two dates
  587. Cell References Format
  588. Excel less than greater than formula
  589. Same Text Characters, 2 Different Codes
  590. Is there a formular for calendar days
  591. Timestamp for when Pivot table was last refreshed
  592. Formatting within a formula
  593. WORKDAY FORMULA
  594. Print Code
  595. Diving 1 cell question
  596. How can I apply print area and page setup to entire workbook?
  597. Sumif less than x
  598. Deleting blanks
  599. Consolidated Pivot table
  600. conditional pivot table???
  601. Updating links specified with INDIRECT
  602. Correct formula?
  603. Alt E no longer opens Edit menu
  604. Date and time
  605. format time problem
  606. spit & sum comma delimted value
  607. To show month end date from any date entered
  608. Combining HLookups &VLookups
  609. Determining the data type.
  610. Export list from Sharepoint to Excel and it is locked
  611. when I reopen the excel worksheet I found that the amount changed
  612. Data Validation
  613. How can I cloud mark on an excel sheet?
  614. Error in Installing Excel 2007
  615. Download Additional Functions to Excel 2003
  616. counting colored cells
  617. using =IF function with 12 variables
  618. can excel backgound be removed to show just the writing ?
  619. 14 Day Average REVISITED
  620. rolling data?
  621. how ??
  622. formula question
  623. tab delimiting numbers
  624. copying formulas when inserting new rows
  625. Autofilter limits?
  626. Sorting columns
  627. return first TWO or THREE words in string
  628. return 1st word in string
  629. numbers within numbers
  630. calc time
  631. related cells in same ecel workbook
  632. 14 Day Average
  633. Changing Autoshape properties using formulas only
  634. Wrap Text, Hyper links
  635. See previously saved files in Excel 2007?
  636. Undo button and redo button quit
  637. deleting empty rows
  638. open spreadsheets into separate excel instance
  639. sum a range with multiple criteria
  640. Self canceling checkboxes
  641. Language setting problem with spellcheck
  642. want negative product not positive
  643. filter rows based on text time
  644. Inputting a value and receiving a result
  645. Help with Excel lookup function please
  646. HELP!!!!!!!!!
  647. Open XLS file
  648. STILL DESPERATE FOR HELP!!!
  649. formula for shauna
  650. hyperlink
  651. can't find file opened from email,changes made & saved
  652. Adding columns in pivot tables
  653. Control on a form to find a record
  654. Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times
  655. File Duplicated in VBE Explorer Pane
  656. conditional formatting
  657. Excel 2002 options grey out
  658. Help with a formula
  659. compare data
  660. graph
  661. calculate Age Year Month & day
  662. How do I create a cost analysis between two companies?
  663. import from Accounting 2007
  664. Monthly tracking log
  665. DESPERATE FOR HELP!!!
  666. Checkboxes in Excel 2007
  667. Drop down list with free text feature?
  668. Excel patch whacky
  669. Zeros and #DIV/0!
  670. dates and number
  671. addition error code is 1E+05. What does that mean?
  672. Can I lock a worksheet and still be able to hide and show groups?
  673. Transpose technique not populating ListFillRange of ActiveX combobox
  674. look-up table - or - error reporting
  675. Average weekly maximum
  676. combine data from several worksheets into single worksheet
  677. Named ranges dissapear from list
  678. Disappearing comments in shared mode
  679. How can I show the file modification date in a page header?
  680. Company Contacts
  681. Getting rid of carriage return in cell
  682. repeating function q
  683. Adding minutes to hours/minutes
  684. Defualt number formats When Opening CSV Files
  685. Link margin size and document size to all sheets
  686. What-If with data tables?
  687. Find/replace numbers
  688. How can i change the #N/A error for a 0 value
  689. long time to close spreadsheet
  690. Mode for Non-Numbers
  691. simple formula question
  692. Formula Help
  693. Extracting (Copying) Text to the Right of a Hyphen
  694. XLA - Addin Active
  695. Roundup percent within existing formula?
  696. Working with numbers in Excel-Specify # of digits
  697. pivot table vicious cycle
  698. Formatting cells containing certain words
  699. Formula Help
  700. Movable "slider" to adjust a range with the mouse?
  701. "Form / Button" Macro for Unhiding Sheets
  702. Is there a cell or column property that indicates ##### displayed?
  703. Question on Macros in 2007
  704. Drop Down Default
  705. Pivot Table blank rows
  706. Calculations on Times Formatted as Text
  707. pivot table maybe?? combining information
  708. entire column to comma delimited cell
  709. How to turn off Cap lock
  710. excel adds quotation marks when pasting text
  711. Run Macro on multiple files
  712. " cannot be accessed. the file may be read-only...
  713. NETWORKDAYS
  714. It opens twice evertime, :1 and :2
  715. Excel doesn't start
  716. Validation drop down box too large
  717. LOOKUP Problem
  718. Changing a field setting in a pivot table
  719. How to determine the number?
  720. How do I open a spreadsheet?
  721. Paste Formatting
  722. how to avoid excel pop-up in macro
  723. How do I add an item with comma in the list of data validation
  724. Can Excel do this? and if so which formula should I use
  725. Excel 2003 - Business Explorer - Missing object or reference error
  726. Count occurances in data
  727. Open XLS File
  728. Conditional Formatting
  729. How to calculate number of occurencies of a specific number number
  730. How do I undock the border tool icon from the toolbar?
  731. find current data with macro
  732. Deleting Excess Rows Again
  733. How to create rows in excel so they show in all forward sheets?
  734. Can this be done with Excel?
  735. Absolute referencing
  736. How do I Delete blank cells in a row
  737. Excel 2003 Advanced filter does not effect data list
  738. subtotals
  739. excel 2000 window disappears from taskbar
  740. Format
  741. Advanced Filtering
  742. Picture formating units
  743. filtering question
  744. Draw border tool - Excel2007
  745. Spreadsheet won't recalculate when numbers are changed.
  746. copying formulas but changing the column #
  747. formatting problems
  748. repeating function q
  749. Search for TRUE in spreadsheet
  750. Macro location??
  751. Borders slowing filter process in Excel 2003
  752. Cell not formatting date correctly.
  753. Conditional formating - for blank cells
  754. Macro not recording in R1C1 format
  755. Date / Time problem
  756. Hide Columns If...
  757. Not able to do any calculations on an Excel sheet
  758. Converting Daily Info to Weekly
  759. How do I add 5 leading zeros to a group of numbers?
  760. Unique drop Down List Selection
  761. Excel can't open network drive!
  762. Sumproduct to divide
  763. Goto Tab
  764. End Down a second time
  765. formula does not calculate blank answer
  766. How do I store through a cell that contains a cell address in it?
  767. tabs and "sub-tabs"
  768. Modeling sales rep ramp
  769. XLS files opening as Read-Only Repaired Compatibility mode
  770. ScroolBar - Showing Blank Names
  771. Best way to format
  772. concatenate & conditional formatting in one
  773. Turn off zooming with scroll wheel
  774. Excel 2003 Subtotals
  775. VB case Help
  776. Formula Result Change when Workbook Sent by E-mail
  777. Formatting the vertical scroll bar
  778. Already have excel installed, but it keeps trying to re-install
  779. Open recent files
  780. vlookup dynamic pathname
  781. Dear Excel Discussion Group
  782. Removing 0 from cell that is blank
  783. 3-D Surface Plot
  784. VLOOKUP Problem, Please Help!
  785. Excel Problem
  786. I want to add and less the time in excel
  787. Fix Cell Data at End of Each Month
  788. Help! Excel 2007 opening in a new instance
  789. Printing thicker gridlines in Excel 2007
  790. Excel 2003 autofit ignored by some rows
  791. Why does this code not work?
  792. Refreshing fields in Excel
  793. Grouped X-axis Categories
  794. can macros include page setup functions?
  795. Need help simplifying VBA code
  796. adding rows after repeated cells
  797. How do I change the file open dialog box?
  798. Excel VBA Books
  799. Count only visible results of formula
  800. Visual Basic code
  801. End Down
  802. Linked spreadsheets
  803. Printing Long Columns
  804. How to keep custom menu from being killed until all wkbk copys clo
  805. Find the smallest amount
  806. greatest value function?
  807. control inactive on toolbar
  808. Hexadecimal data
  809. how do i convert a quattro pro 8 file into a office 2007 excel fil
  810. Auto populate fields
  811. i cannot get coloured text or fill to work excel 2003
  812. Excel 2007 - keyboard functions
  813. Tool bars
  814. Pivot Table Range Extension.
  815. "Excel cannot find the data you are searching for" but I can see i
  816. "excel cannot find the data you are looking for" but i can see it!
  817. How do I record new Highest / Lowest numbers as data changes in ce
  818. Convert Excel file ti ASCII format to allow a SIFT transfer
  819. REad Only Spreadsheet
  820. Enter row into multiple sheets?
  821. How do I prevent data i a cell from being copied?
  822. Sorting Help
  823. Am I expecting to much form Excel 2007?
  824. Inseart row if cell number is repeating
  825. 檔案*在F槽的UBS.9月1日開啟時要求* 化.資料就不見了.要怎麼救回
  826. Can we calculate RSD ( relative standard deviation) in Excel
  827. transfer data from worksheet to another
  828. Make ribbon Icons smaller
  829. Sort names and birth dates
  830. Sort names and birth dates
  831. Hide Duplicates
  832. Extracting parts of a cell when only certain words appear
  833. How do I generate an email list from my worksheet?
  834. how do i stop excel from showing numbers as dates
  835. Sorting issues
  836. countif for 2003
  837. How do I get the scroll wheel on mouse to work in Excel
  838. I am unable to open excel shortcut.
  839. Sum to Blank Cell
  840. Excel 2007 column references
  841. How to bring up a blank cell
  842. Average without numbers
  843. Display only first letter of Weekday in number format
  844. File doesn't appear when opening
  845. Average if ...
  846. Problem opening excel
  847. Creating a Form- Formatting based on answer given
  848. Excel Vlookup HELP
  849. maximum number of rows in pivot table data
  850. conditional formating with multiple entries
  851. Simple C&P Q (internet to Excel)
  852. Hard to Sort Sorting
  853. WEEKNUM change start of week to a monday
  854. Fill Handle in Excel 2007
  855. compare two columns in Excell 2007?
  856. Excel database query referencing data in the same workbook
  857. Importing from Access error
  858. Using Save As to Web Page feature in Excel produces blurry graphic
  859. Move new item on list to seperate sheet
  860. Overwriting data in other worksheets while updating another
  861. Match
  862. Data Validation Menu Greyed Out?
  863. Macro for a Border
  864. Nested IF Function
  865. Is it possible to set headers and footers to show in normal page .
  866. Drop-down almanac
  867. Linking in Excel
  868. Excel 2007 vs 03
  869. I need help with a formula PLEASE I am going crazy
  870. Conditional Formatting and Cell References
  871. text vs number
  872. Excel Functions Help
  873. Transpose a data table
  874. Link Excel Comment to Sheet, Cell (Bookmark)
  875. Please Help Me With This Chart Issue
  876. Open a file twice.
  877. Escape key won't work
  878. Formula Problems
  879. how do i remove the border around a text box
  880. Default Row Hi-light Color Intensity
  881. JPEG picture looks fine but is distorted in print preview & printi
  882. problem of an empty cell
  883. Fixing cell value
  884. hitting enter closes workbook. why???
  885. Conditional If Statements
  886. extract names based on conditions
  887. Moving between cells
  888. Password Protect so can't save and change
  889. Can Excel be linked to SAS query
  890. Multiple reports
  891. Use of macros on spreadhseet copies
  892. unable to open file
  893. Conditional If Statements
  894. How do I reverse the order of a list in Excel?
  895. Excel 2002: How to fill up text for like items ?
  896. How do I skip cells after entering info?
  897. Excel 2000 Validation with colors
  898. File Size
  899. PLEASE HELP!!! PLEASE!!!
  900. Excel 2007 "view side by Side"
  901. 2008 East Coast US Excel User Conference
  902. Merge Cells
  903. macros
  904. How2 set a shared workbook to always open a certain window size?
  905. Max Formula Lenght
  906. Nested If Statement
  907. Invoice spreadsheet
  908. Formulas Reference
  909. merging excel files
  910. help!
  911. excel pivot record group
  912. How to change positive values in a cell to negative in Excel 2000
  913. excel programını
  914. compare a value to many other values
  915. Pivot table and MS Query
  916. How do I create a legend or key for an Excel worksheet?
  917. Extracting numbers from alphanumeric data
  918. Hiding Zero Values in a Pivot Table - MS Excel 2007
  919. Convert Text to Number
  920. How do I setup page and margins for ALL sheets in an EXCEL file AFTERWARDS?
  921. How do I link 2 drop down list together?
  922. baby
  923. File is a [Group].
  924. Incorrect date value when open DBF file in Excel
  925. To what does "Not Responding" on Excel mean?
  926. Conditional Date formula
  927. Reordering and combining data
  928. Formula Problem. Anyone up for the challenge, lol?
  929. Copy Conditional Formatting down rows
  930. email message on worksheet
  931. Excel 2000
  932. Return header cell of last column with data
  933. How do i copy a colored cell to another cell using a formula
  934. Lookups
  935. custom inputs
  936. "X" at upper right of window to exit program is grayed out.
  937. How to search for "?"
  938. How do I copy a macro into another cell?
  939. shortcut for creating border in several highlighted cells
  940. Delete blank rows
  941. Using VBA select sll sheets based on Criteria on each sheet.
  942. Formula displays instead of text result
  943. I have a few saved Excel files that do not open
  944. Showing 18 digits or more in a cell
  945. changing default search location in Excel 2007 Find.
  946. highlight problem
  947. Paste Values and Formats Only????
  948. Breakeven graph
  949. Are there limits on Pivot Charts and Tables
  950. selecting several open worksheets
  951. delete code keeps going and coing
  952. Excel Printing
  953. "File in Use"
  954. Please explain this formula
  955. 2 columns of data to return an answer (Vlookup???)
  956. Month Formula
  957. Excel file formatting
  958. "Reference is not Valid"
  959. macro security
  960. Excel 2003 Formulas not calculating when dragging down
  961. Webquery from other browser
  962. significant figures?
  963. Highlight cells in a row with a given value
  964. can i create a reminder to pop up in excel 5 days before?
  965. yearfrac
  966. Excel 2003 and Excel 2007 on the same machine
  967. vlookup
  968. Automatic numbering with letters
  969. Autocomplete for cell values
  970. Wrapping Columns?
  971. "Select method of Range class failed" Error
  972. Help with VBA Code
  973. Excel Error Message
  974. Another nesting issue
  975. line up items in column a with items in columns b, c, etc
  976. Other sheets to pick data from master sheet
  977. Search function
  978. Adding Time
  979. FORMULA FOR SUM TOTAL OF SELECTED ROWS
  980. Custom Filter/Views
  981. Link 2 Excel files
  982. how can i stop the reviewing toolbar from automatically loading?
  983. Move comment into cell as text
  984. Printing fails on A3
  985. Time formats
  986. adjust line spacing of text in a cell
  987. Insert rows with condition using macro
  988. Help making postage calculator based on a given weight
  989. how to combine number data from one column into another column
  990. Nesting Problem
  991. Formula
  992. "h:mm" format, but 12-hour time, not 24-hour time?
  993. Subtotal with the protected spreadsheet
  994. Data Validation: Lists
  995. OLAP Creation in Excel / MS Query -- .cub files
  996. Does password protection ever "expire"?
  997. Backwards Compatibility with Excel 2002
  998. Hiding Rows if a Field Value is set to 0%
  999. Formula: copy/concatenate cell contents matching condition
  1000. automatically selecting items in drop down list