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. Excel startup links options
  2. Headers Help !!!!
  3. Opening Excel 2003 File
  4. Copying year
  5. counting blanks in a non-consecutive range
  6. Password
  7. counting data across worksheets
  8. file replace
  9. vlookup looking at many worksheets
  10. how do i find the last time i picked a winner
  11. count 2 column
  12. DBF File
  13. Veritcal Borders Disappear
  14. How to consolidated (export) excel file as soon as I receive as ma
  15. auto update remote refrences
  16. link two cell from two workbook bypass password
  17. Adding rows
  18. display number in words in excel 2003
  19. Pivot Table problem
  20. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  21. Lookup formula - please help!
  22. using time format in a formula
  23. check if sheet exists
  24. Counting Cells with same data
  25. Monte Carlo Simulation for list of Values
  26. Converting to Date Format
  27. Hyperlink to web does not return to original Excel worksheet
  28. workbook before close
  29. Counting the day of the weekweek
  30. Formulas
  31. MS query - 2 questions
  32. help please!!!!!!!!
  33. lock column size for some rows and resize for other rows.
  34. If combined with OR & AND
  35. cell reference
  36. VBA check to see if variable value is odd but not equal to 1
  37. Copying Filter Data & Using for each in cells
  38. Open Excel File in Internet Explorer
  39. how do I email a single worksheet in Office 2007
  40. Query Editor question
  41. Table References Incompatible with Trace
  42. before close event with condition
  43. Graph Re-size Macro
  44. Autofill in macro
  45. Macro for data base
  46. Pivot Table with data in different sheets
  47. Formula Help
  48. Problem with CSV file
  49. Creating a report with .jpg files in it
  50. What is the maximum filter for rows?
  51. RE: Need Help
  52. Re: Need Help
  53. Auto Fill Problem
  54. Re: Need Help
  55. SS tabs reading Dec 1, Dec 2, Dec 3, etc
  56. SOVER ADD IN
  57. Controls not available in Excel.
  58. Sum
  59. No more custom number formats can be added
  60. Z-axis legend
  61. How to del last two rows
  62. sharing violation
  63. hyperlink is opening file with wrong program
  64. Date Calculations as Days
  65. I need a formula to keep a running percentage....HELP!!
  66. how to get Excel 07 combobox to populate from MS Access table?
  67. Lookup from range to display a row
  68. AverageIF with cell refenrence as criteria is not working
  69. Excel 2007 無法使用滑*捲軸
  70. How do I display numbers of 12 digits or more?
  71. VBA Help naming sheets
  72. accounting issues in excel
  73. Importing data from Excel to Access
  74. How can I keep my numbers while sorting?
  75. Complicated formula?
  76. track changes
  77. Excel 2007 Changing Existing Formulas
  78. Split a table into two
  79. IF STATEMENT HELP
  80. How to add error bars to 3-D chart
  81. Dynamic Named Range
  82. date/time
  83. 1+1=0??
  84. Comparing Two Workbooks
  85. Formula for Created on Date
  86. Copying and Pasting
  87. An easy way to make a "summation"-sheet
  88. Pivot Table is reversing data
  89. Calculation time
  90. How do I prevent copy and pasting into a selected range of a works
  91. Validation cell entries (Drop-down list)
  92. Tracked changes - change highlight colours
  93. Create Labels from within Excel
  94. formula help please
  95. Hyperlink not working correctly
  96. changing colour of cell border
  97. date query
  98. Getting a debt consolidation loan with a credit counselor
  99. Getting a debt consolidation loan with a credit counselor
  100. WHAT happened to the forms toolbar from office 2k need drop down
  101. sheet dragging glitch?
  102. Conditional formatting: colored bar with pointer on current status
  103. Can't change sheet color after sharing workbook?
  104. Create a list from offset data
  105. ungrouping clip art
  106. Change the language
  107. lookups with multiple lookup values
  108. If C2 is Sunday how do I make D 2 to the next day of the week
  109. Request for VB to do something simple (insert text in a column ofcells)
  110. complex macro??
  111. macro for copying background color
  112. Making touchpad's Horizontal Scroll region work in Excel/Word 2007
  113. Column Order Reversal...
  114. Count cells according to format
  115. Macro
  116. Cell Value from String Name
  117. RE: Covert # to measurement
  118. range of Formula copy but not changing the content
  119. Duplicates
  120. If return
  121. How do I validate text in a cell based on other sheets in the work
  122. Macros
  123. macro to save as a data input by user file name from a designated
  124. Calendar in ADD IN
  125. renaming column labels, pivots
  126. How do I have the first few rows not be numbered?
  127. Workbook cannot be expanded to fill screen
  128. Link or join worksheets?
  129. Adjusting row height to accomidate text in a cell
  130. Creating a graphical bell curve form Excel data...
  131. max limit to characters in COUNTIF function?
  132. Regional Settings with Date
  133. Lookup Function
  134. Conditional Formatting a Formula Field
  135. Text to Columns - Way to remove all column breaks at one time?
  136. Display Leading Zero
  137. Shortcut for hide/show detail in grouped columns/rows
  138. validation problems...
  139. Copy cell data as formatted
  140. Hidden Rows blocking TAB INDEX
  141. Pivot Table SubTotals
  142. View mult workbook tabs in excel
  143. Stop Autofill/Highlight of cells
  144. How do I clear a cell contents but not the formula behind it
  145. how do I change cell labelling from R1C1 to A1?
  146. Windows XP Pro Ed._Desktop window at startup is too small
  147. Source to Pivot Table
  148. Help with Solver
  149. Date Comparison Formula
  150. Link to last used cell
  151. Adding autoshapes at commets
  152. Want to treat e-mail addy as text!
  153. How to add currencies at conditioanl formating
  154. How to add currencies at conditioanl formating
  155. Declaring variables in Module vs. Public
  156. Worksheet referenced in same file as variable in formula?
  157. Carrying formulas from one sheet to the next within the same file
  158. More than i substitution
  159. gicals or formlasCount cells in a Range
  160. Fix for "That command cannot copy multiple selections.".
  161. Parameters Button Greyed Out Why?
  162. error using LOOKUP function
  163. Pivot Table (Grand Total)
  164. Check Folder For Files
  165. Inserting an interactive spreadsheet into a webpage
  166. Deleting Duplicate Cells in one Column.
  167. Leave a cell COMPLETELY blank if there is an error
  168. Delimiting when seperator is a comma & number is bigger than 1,000
  169. Rounding to case quantities
  170. auto fill failed
  171. Excel 2007 and saving as a web page
  172. Help on a Date formula
  173. ThisWorkbook.Print question
  174. Network days - Returns error sometimes.
  175. Multiple Hyperlinks - linking external photos/files help
  176. Converting numbers to text
  177. Find the median 3 values
  178. Total of 2 columns in pivot table
  179. Sorting
  180. I was informed that there is a hidden Game in Exel. can you asist
  181. conditional formatting
  182. Office 2007 Trace Precedents + Tables
  183. Comparing 2 cells using vlookup
  184. Counting defined values
  185. Can't save excel worksheet
  186. extraction
  187. Printing
  188. Diagram that selects reference area automatically?
  189. Selecting data – when some cells are empty
  190. Using Countif two criteria
  191. Avoid re-entering 'Find what:'
  192. how do i give differect color for validation list?
  193. Sumif question
  194. recognize weekends and calculate the next working date....
  195. Index & Match
  196. Looking for someone
  197. Excel 2003 default file location always jump to .....\Proof Help
  198. Exccel 2007 puzzling "loss of fidelity"
  199. linked files to be changed
  200. Excel and Lotus123
  201. Macros enabled but will not run in excel 2007
  202. VBA RANK
  203. Lookup Help
  204. Pivot Table exclude negative values from sum
  205. mouse trouble in excel
  206. Dcounta for counting staff grades
  207. Filling in specific dates in Excel
  208. Value searching in columns - vlookup can not do it?
  209. Random Number Generation at Interval
  210. vlookup - matching where codes are not exact
  211. numbers rounding
  212. How To Anchor Chart Data
  213. Date Posting
  214. Color Palette
  215. CAN I MAKE COL. A,ROW 3 CELL BIGGER THAN COL. B,ROW 3 CELL?
  216. create calener code
  217. auto fill code
  218. Return total number of YEARS & MONTHS in a cell
  219. Conditional Formatting dependent on another cell
  220. COUNTIF limitations, alternatives?
  221. Files don't open first time EXCEL 97
  222. VBA For Expiry date
  223. Why Cos(45) is not equal 1/Sqrt(2)?
  224. Numbering Sheets
  225. excel training videos--recommendation?
  226. Rate sheet re-calculation
  227. Find replace in functions
  228. Filtered cells return after saving
  229. Formulas for dividing in Excell
  230. Control Box Text Box
  231. Create a RowSource Depending on ComboBox Choice
  232. Within excel how do you display large amounts of text
  233. How can I copy a formula into a column but extend it by row
  234. Charting selective data
  235. Errors Installing the Analysis Toolpack add-ins.
  236. hopefully a basic macro
  237. Question for Gord D
  238. French format
  239. Regressions with data in (changing) rows
  240. Several things if anyone is willing to help a total novice user ofExcel
  241. Deleting and Opening a Macro
  242. Rounding time
  243. function formatting a cell
  244. Tracking Time in my Spreadsheet
  245. Countif
  246. pivot tables
  247. Lost view of spreadsheet EXCEL 2007
  248. I forget the password of protecting sheet, I need to unprotect it
  249. minimum function but want to exclude zero
  250. How to determine the number of common factors?
  251. Automatic backup option
  252. how to create an accumulated value
  253. enabling/disabling a set of code from within a spreadsheet sheet
  254. Mass Protect and unProtect
  255. maxing out conditional formatting
  256. SWITCH NUMBER BY LETTERS
  257. Can you print a background?
  258. Search for Excel worksheet in Windows Explorer using dollar value
  259. First time deleting macros
  260. How to search a spread sheet for a value and return the adjacent v
  261. First Time Macro User--Stop Recording Toolbar
  262. Sub Totals
  263. Can you view cell formats without opening the formatting window
  264. Issues with sharing workbooks (data loss)
  265. How to average every 48 rows of data for 20,000 rows?
  266. transitional formula entry
  267. t-cards
  268. T-cards
  269. Printing Double-Sided
  270. Imported Oracle Data
  271. how do i calculate wins and losses for basketball scoring?
  272. How to add currency symbol to a cell value
  273. How to add new currency symbol
  274. Group button Links
  275. How to restrict zeros in a number from 16th digit onwards
  276. Excel 2002 produces error in calculation.
  277. Help with sorting blanks out of a list
  278. How do I create a drop down box that is not a filter in Excel?
  279. median calculation
  280. Subsequent MODE
  281. Non-contiguous named range
  282. Count function
  283. Add separate colors to values in drop down list
  284. List problems
  285. Sort Pivot Table
  286. Pivot table totals?
  287. Blank cell
  288. Keyboard Shortcut Conflicts
  289. XML export with <![CDATA[text]]>
  290. Trying to get a decimal point using Match command
  291. Toolbars
  292. How could I create a two point lookup?
  293. when i megre cells that begin with zeros , I lose the zeros
  294. Custom message at opening or closing of file
  295. Text to Numbers
  296. How do I lock several sheets
  297. HELP WITH MY MACRO
  298. How do break the link from my excel workbook to a access database.
  299. Drop Down List + Validation
  300. vlookup - removing formulas
  301. Scroll
  302. Can it be done in excel?
  303. How do I plot an expression in excel?
  304. Charts
  305. ActiveChart.Location help
  306. SQL Query - To Excel - My Workbook Does not Function Properly
  307. 2007 - Worksheet slow to open
  308. Credit Card Calculation
  309. Credit card Calculation
  310. VLOOKUP
  311. Stop Values Duplicating
  312. How to convert numbers to text format?
  313. check spelling automatically as you type by displaying red underli
  314. technical problem of newsgroup usage
  315. convert Boolean true-false to zero's and ones
  316. superimposing charts
  317. create footer, sum of column values
  318. progressive sum
  319. Any Excel spreadsheets to track a Wolf scouts achievements?
  320. XL 2007 Toolbar Disaster
  321. Gridlines on partial sections of sheet
  322. Formatting 11001981003213 as text..
  323. Protection - Allow Group/Ungroup but lock / unlock some cells
  324. print half of rows on left and other half on right
  325. Solver Ignores Constraints
  326. Excel Formulas
  327. How do I stop auto conversion of numbers to a date?
  328. subtracting in excel
  329. Formula & text in one cell
  330. formula in conditional formatting with dates
  331. Automatically convert Text with 2-digit year
  332. sumif with multiple constraints
  333. Parsing / seperating text string in excel cell
  334. Taking values from another cell
  335. Orientation Landscape but want Page #s to Print Portrait
  336. Excel Cell Styles - Quick Styles?
  337. How do I set the default Excel application to Excel 2003?
  338. Pivot Chart Data Data range cannot be changed
  339. Extracting number of hours as decimal...
  340. Timesheet -
  341. Value won't show correctly in cell unless I double click formula,
  342. Deleted gridlines.
  343. Data Base
  344. Prompt for Korean proofread
  345. Editing a multi-line formula
  346. Printing Charts in Excel
  347. formula
  348. Need help with a SUM formula...
  349. How to control row height and text wrap in non-merged cell ???
  350. Date format
  351. How to enter in one cell and show up in other worksheets
  352. Insert Comment Command
  353. How do I make Excel 2007 compatible to others on older MS systems
  354. circular reference
  355. Dividing cell by sum of two other cells
  356. Sheet Information - Is sheet protected?
  357. In Excel, colored text is printing in black. Shaded cells are ok?
  358. Automatic Webquery Refresh
  359. Currency Custom Format
  360. Price List
  361. SUM Issue.. HELP
  362. Thanks
  363. Need help: Excel automatically change input values
  364. Drop Down - Repost
  365. Tailoring Pivot Table Data
  366. Baby stuff I know-if
  367. Workbook name in VBA doesn't match filename.xls
  368. Date Display
  369. Creating Forms in Excel 2007
  370. Lookup table help please
  371. Pivot Table from Macro
  372. Filters
  373. what is the formula
  374. Games
  375. Format Data
  376. Cell Markups
  377. Pivots: Grand total = Count not sum of data
  378. Pivot Table Top 20 excluding specific items
  379. Question on how to raise a price 15% in a coloum
  380. QUESTION ABOUT ENTERING DECIMALS
  381. Pivot
  382. how do I add a caption to a picture in Excel
  383. Name an Entire Workbook
  384. Name an Entire Workbook
  385. Help with multiple If statement
  386. Formula to sum multiple columns on multiple criteria
  387. How to make a dynamic named range
  388. CONDITIONAL FORMATING QUESTION
  389. SUMPRODUCT with "Contains" criteria
  390. Programming
  391. Re: If statement
  392. How do I jump between sheets in Excel using keyboard?
  393. Diagram question
  394. Table within a table
  395. Macro Button in a work sheet
  396. Keep last 4 characters of value
  397. paste special transpose problem
  398. COUNTIF verses VLOOKUP or HLOOKUP
  399. recognizing the next cell and inserting the correct currency symbo
  400. Macro - Insert/Copy
  401. Can I Add the last saved Date to cell ref in excel?
  402. Excel-VBA
  403. Long Code
  404. Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise
  405. how to increase no. of rows in excel spreadsheet
  406. VLOOKUP
  407. Formatting time for m:ss.00
  408. Excel 2000
  409. Rounding and formatting
  410. Match help again easier this time
  411. using a date format not in Excel 2002
  412. Help & me match these rows
  413. splitting Last Name, First Name
  414. Excel2007 - draw a line
  415. How do I create an email macro to auto fill the email?
  416. Formating Date problem
  417. convert a text date to a true date
  418. Unhide column - why doesn't click unhide column work?
  419. How do I find the exact years and days between 2 dates?
  420. Links between Workbooks
  421. Create time value from number
  422. copy down with variable number of rows
  423. Quarterly figures with criteria
  424. Wildcard Character Placement in MS Query
  425. Formatting Bug on Read-Only Excel Files
  426. Formatting $19 million
  427. top 10 for text?
  428. HELP ON VLOOKUP
  429. Adding data to Excel cell contents
  430. Any help
  431. Lookup all values on next tab
  432. How do I set up Alerts and Notification on Excel?
  433. Printing a workbook but not getting page set-up results
  434. Creating a Proposal
  435. Worksheets
  436. Leading Zeros
  437. how do i make values increase by 1 while going down a cell
  438. Merging rows based on column value
  439. copy value from cell above
  440. printer collate box unchecked in excel
  441. Excel 2007 can't use mouse wheel to scroll through page
  442. 'NAME' instead of numbers
  443. Add Seconds To Date
  444. adding addresses to a file from another file
  445. Formula needed
  446. need if then statement help please
  447. Number format not being recognized when pasting value
  448. How to generate a list from a table
  449. Can Excel 2007 & 2003 run on the same machine?
  450. Selection Window
  451. how do I only do payroll check stubs on the computer
  452. E-mailed worksheet reverts date
  453. Drop down list
  454. Duplicate worksheets
  455. how can i see all column sizes at once not individually?
  456. Import data from website everyday at certain time...
  457. Using non-default printer on start-up
  458. Changing text to numbers
  459. Problem I need Help With -- IF Statments
  460. Creating a pricing table - with 2 input fields.
  461. extract center char
  462. Excel 2003 and Unicode csv files
  463. Excel 2007 - hide row from print?
  464. Error message: Too many different cell formats
  465. How to overlook zeros in a calculation?
  466. Excel 2007 - "Snap To Grid" doesn't work on same grid line
  467. cells with zero value are shown as blank, not zero
  468. Preserving Highlights in Pivots
  469. HELP!!!
  470. How do I turn off smart tags.
  471. Pyramid diagrams - like food pyramid - How can it be done?
  472. Downloaded Report
  473. accidental save - recover prior version of Excel file?
  474. Edit multpile hyperlinks
  475. How do I lock down the options settings?
  476. Hyperlink issues
  477. Drop Down List
  478. Graph with scroll bar
  479. How do you create a complex footer (e.g. title block) in Excel?
  480. Sort problem - help!
  481. How to use cell fron different sheet in IF statement
  482. Countif
  483. How do I link cells in 1 spreadsheet to Specific cells in another
  484. Building a rank table using If
  485. Drop down lists?
  486. Query and Report Problem
  487. Spreadsheets in separate windows
  488. Excel 2003
  489. Hiding Sheets
  490. Find and Replace looking for values
  491. autotab
  492. Editing the Excel Sheet from the command-line
  493. Template WANTED
  494. Functions in a pivot table
  495. Importing data from one worksheet into another
  496. Dragging formula
  497. Having trouble with returning a certian value using =IF function
  498. Result in days and/or months
  499. Copying Sheet with Pivot charts
  500. Stop Excel converting csv values to scientific format
  501. excel microsoft
  502. Pivot Charts on the web
  503. Any Black Scholes Model Formula for Excel 2003?
  504. Create An Address List with Pictures in Excel 2007
  505. Change Row of text to values
  506. Sort (find / replace) by cell colour ?
  507. Link to a password protected file
  508. ACT! and Excel
  509. Can I change the color of the largest number in a column?
  510. Excell spread sheet
  511. # of weeks left based upon a date?
  512. Changing default Page Setup
  513. Hyperlink stored in an external workbook
  514. AverageIF
  515. User Proficiency
  516. Stop URLs from changing font size - Excel 2007
  517. MSN stock quotes - Error message "problem displaying attributes"
  518. Need help making algebra graphs
  519. Q: Named range based on cell value?
  520. Named Range question
  521. Type in all caps
  522. changing cell sequence
  523. Adding dates & times
  524. How to use a formula to determine the Cell Style?
  525. Using XP Operating System to Search for Numbers Values in Excel Files
  526. formula or macro.
  527. Sub Worksheet_Change
  528. How can I convert a time calc into an overtime pay rate
  529. Using vista home basics, need excell & word, can it work together
  530. Extract text from large Text
  531. I am unable to right click a cell and get options to pop up... 2003
  532. Exit from Excel edit mode using IDispatch
  533. Can key tips be left on in without repeated use of the ALT key?
  534. Merging two sheets with non-identical data
  535. Summing fields based on color
  536. How to do mail merge from excel worksheet to word document.
  537. How can I insert the symbol for average in an office document?
  538. How do I add a button with a macro?
  539. Insert a PDF as a comment on Excel 2003 or as a hyperlink to the c
  540. How do I drag a,b,c,d down a column into a series?
  541. Excel and E mail
  542. Grouping Variables on an axis
  543. Sum of numbers with only two decimal places wrong
  544. E-Mail Issue in Excel
  545. Help please! Date formulas
  546. Q: criteria based vlookup
  547. SUMIF Function
  548. My num pad is locked
  549. Insert rows macro.
  550. unique item remover
  551. Find first digit of value
  552. Filled grid command
  553. How can I center a number in "comma" format?
  554. Comments Won't Print in Worksheet
  555. Comparing Excel Files
  556. I can't get my office to print in color
  557. I have a gripe...
  558. Reminder Macro
  559. VBA Help
  560. Count based on criteria from two different columns
  561. Find External Links
  562. sum adjacent columns based on variable
  563. distribute rows from one workbook to other workbooks
  564. Spreadsheet will not open without Excel Application being open fir
  565. Scrolling all worksheets at the same time
  566. Can one workbook/sheet update another workbook?
  567. Applying a Border Around Sets of Data
  568. colour rows alternating colour
  569. Print out does not match spreadsheet
  570. Creating a drop down list
  571. Sumproduct to get a count of dates
  572. Using sumproduct to sum multiple colums
  573. Formula help...find values and grouping together...
  574. How to determine the number from given conditon?
  575. Print titles must be contiguous and complete rows or columns
  576. Format Numbers
  577. Read/Write Process
  578. Read/Write process
  579. Pivot Formula
  580. coding macro
  581. Protect Cell Formatting including Conditional Formatting
  582. Pivot Tables - calculate field?
  583. JPG file inserted in Office 2003 cannot be viewed by office 97-200
  584. Importing data from excell to access.
  585. HELP ON LINKING DATA TO DROP DOWN LIST
  586. Erroe Messages
  587. Copy data from 1 work sheet to another automatically
  588. data table construction
  589. Selected Sheet will update cell.
  590. how do I hide a calulation error in cells/table #div/0!
  591. format and paste problems
  592. Solving #REF! Problem
  593. WORKBOOK COMMENT
  594. How to determine the number from given condition?
  595. Excel 2003 chart lines are too thin
  596. My excel 2007 is so slow
  597. trying to delete a row in the pivot table for the pivot chart
  598. Drop down list help
  599. Copy Filter Results only
  600. Data Validation on Vlookup
  601. Removing date from time
  602. How do I protect a whole folder from getting deleted???
  603. Stopping a pivot table from reformatting column sizes and widths
  604. Visual basics
  605. How do I remove the e-mail header in an excel file?
  606. POSSIBLE TO ROTATE FONTS 180% ?
  607. Linked spreadsheet is not automatically adjusting row height?
  608. default format for footers
  609. Excel - Formulas
  610. Conditional Sum
  611. how do I create the formula for PVIFA?
  612. is it possible to enter in text over a formula without deleting the formula?
  613. Excel Save with Errors
  614. Open excel pivot source data in Access?
  615. average of 12 noncontiguous cells
  616. Deleting entries one year old
  617. rows reappear on pages when printed
  618. text format doesn't work properly
  619. Hyperlink in comment box
  620. Displaying date as a real number
  621. how do i hide a single worksheet in a workbook?
  622. How to fix if Excel won't sort a column?
  623. Can't Open Excel
  624. green triangle top left corner of cell in Excel
  625. auto filter
  626. Options link under Tools is greyed out
  627. Formula snafu
  628. Text stored in a cell is displayed as a string of "#####..."
  629. Creating a weekly rotating employee work schedule
  630. Pls help for formula.
  631. Excel Spreadsheet Employee list
  632. Cell Selection in Excel
  633. Multiple rows into one
  634. display the day of the date
  635. Picture Stock Brochure TIA
  636. Hide Repeat Data
  637. Shortcuts
  638. Convert Min & Hrs to Min in Decimal
  639. vlookup for 4 different ranges
  640. vlookup for 4 different ranges
  641. Hyperlink in Excel - not the same after it is emailed
  642. pivot table within a pivot table
  643. Transfering data/table from excell to access
  644. how to create formula.
  645. plain text opens instead of formatted spreadsheet
  646. how to insert rows by formula.
  647. How to stop last number from changing to 0
  648. ADD COLOR TO FORMULAS
  649. Pivot table drill down
  650. how do i set up a repeating meeting in outlook?
  651. Properties selected during Save_As
  652. Date Round Up
  653. exporting from Excel
  654. Unlock worksheet
  655. Button properties blank: protection problem?
  656. how do i calculate the difference between two numbers?
  657. Excel 2003 Status bar missing in Internet Explorer
  658. Excel Problem....
  659. Find alpha all characters
  660. Excel Problem
  661. Function - how to count all cells with text
  662. 2007 UK Excel Conference - Nov 29 - Dec 1, Cambridge, England
  663. macro to save as
  664. what did I do to get autodate?
  665. SumIf right = 1
  666. Negative entry
  667. Double clicks do not open the file
  668. How do I add additional text in many cells
  669. Excel Date/Product formula. Please help
  670. i need a help on the excel formulas
  671. Hyperlink 4 Opening More Than 1 File.
  672. Replacing Two Items Together-Urgent
  673. Formula Help!
  674. formula calculating date
  675. Column Headings
  676. transpose - array problem
  677. SQL.REQUEST
  678. SQL.REQUEST
  679. 1 Heading for 2 columns
  680. Row retrieval HELP!!!
  681. How to determine the correlation between two lists of numbers?
  682. Excel 2007 data corruption using sort within a filter.
  683. Check if a folder has x files in it.
  684. marking duplicates between two files
  685. Odd question about sending attachment via Excel
  686. How to clear all filters in worksheet for all columns
  687. Sudden Increase in File Size
  688. clear the clear the web page email attachment lines
  689. Running Excel from a PDA
  690. Create column with data pulled from header row
  691. Hiding/unhiding rows
  692. Excel 2007 Freezes when I try to copy a cell
  693. Table Layout tab missing
  694. drop down lists that populate other cells
  695. Column display-excel 2007
  696. Calculating a generalized inverse matrix
  697. Sorting Data
  698. Countif between two dates
  699. charting categories
  700. Merging data of the same record
  701. If And Formula
  702. How to insert bullets between the words in footer
  703. Excel 2007: Cell border drop shadow
  704. Format Header Date
  705. Fixed & Reducing Balance Loan Calculation.
  706. Another Print Area question
  707. Formula
  708. Format of Header Date
  709. setting row heights in excel
  710. Excel FILES WILL NOT OPEN WITH NEW VISTA OPER SYSTEM
  711. Excel through email
  712. SOFTWARE for SALE!!!******************************************* ********************* 95487
  713. I want to use a standard 'Word' field in my Excel header
  714. Changes in my setup?
  715. Elapsed time
  716. How to get the final "result" to show in one cell? Excell 2002
  717. Excel 2007; problems with Excel macros
  718. How to print address labels from addressbook on excel spreadsheet
  719. Excel docs opening encoded
  720. Text not showing in merged cells
  721. Stop 10-6 from changeing to 6-Oct, or anything else.
  722. check box
  723. Conditional Format a cell that contains a function
  724. String of functions confusion - please help
  725. How do you change the number of undo's in excel
  726. How to disable the Macro?
  727. Time Formatting Question
  728. Vista oper system will not accept old excell files
  729. hot to get a tally of the number of times a cell is clicked
  730. 3 Questions
  731. How to change text into number?
  732. Help with formula
  733. How to detect characters in cell?
  734. cannot insert rows -error message "cannot shift object off sheet"
  735. Reopen workbook
  736. how to use the soft keyboard ?
  737. Saving Worksheet to new file by tab name
  738. Digitally signing VBA Project
  739. deviding hours
  740. AUTHORITY OF VARYING RIGHTS
  741. MULTIPLE HYPERLINX IN A SINGLE TEXT
  742. Wrap text in header section Excel 2007
  743. simple but hard question
  744. Sharing an Excel file among 3-5 users
  745. Setting the Validation Criteria on the fly
  746. password protection
  747. NUMBER FORMATTING: ODDS AND TEAM RECORDS
  748. Finding data in a text column
  749. Pivot table grouping
  750. Excell Data Filter Fails to Integrate New Data-rows
  751. Can't edit a Comment, not protecting, not sharing
  752. Data Validation
  753. saving and refreshing workbook linked to a SQL database
  754. reading from SQL
  755. Creating smaller files from one worksheet
  756. Rows to Repeat at top
  757. Excel Forms vs InfoPath
  758. Slow opening of "in use" workbook
  759. Conditional Formatting
  760. How to save an entireworkbook to individual text files?
  761. Failing IF Statement
  762. two flavors of formatting patterns (border/area vs. line/marker)
  763. How do you collapse a picture in Excel?
  764. Highlight Pivot Row Totals
  765. Dividing in excel easy questions
  766. Hidden Cell Contents
  767. Can't get formula to work in inserted column
  768. How to paste Word table into Excel 2003 intact?
  769. column headings
  770. Break one rpt into multiple rpts
  771. Help Please
  772. Autofilter across a single row -- is this possible? (repeat, sorry
  773. Autofilter across a single row - is this possible?
  774. Windows in Taskbar issue
  775. Pivot Table - Quarterly report
  776. link web page to excel
  777. How to add up all cells with no fill color
  778. using wildcard for vlookup?
  779. Sorting data on a worksheet for different users (shifts)
  780. formula help
  781. how to not display a certain result
  782. Calculating working days
  783. Rounding up - number data and frequencies
  784. footnote protection
  785. assemble worksheets into one workbook
  786. Remove fill color for cells without text only
  787. calculating time, overtime in excel [h]:mm format
  788. Pivot table source data
  789. Alphabetical Physicians Rotation Roster for Unplanned Leaves
  790. spell number
  791. Restrict / Stop Printing
  792. Replace only abbrevations
  793. Lookup Help
  794. how can I use the ampersand in a custom header as the word "and"?
  795. checkmark boxes
  796. automatically open a specific worksheet when starting excel 2007
  797. Comparing Two Columns
  798. vlookup question
  799. Repetive Formatting/Creating a Toolbar button
  800. When editing a funciton wheel mouse stops
  801. FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL
  802. Payroll Calculator Excel 97 or later - what figures to use?
  803. Resetting view when hiding detail in outline level
  804. Greek Spreadsheet
  805. Help with formula
  806. How do I create a formula that pulls info. from many sheets within
  807. How do I split form controls in a sheet in excel?
  808. Excel spreadsheets messing up my decimal point
  809. Validation of a sum
  810. Accessing imported Excel files after Office 2003 SP3 upgrade
  811. Help! Counting Sick Working Days Formula?
  812. Formula Help
  813. Compiler Error
  814. Problem with chart and formula
  815. Validation of cells containing percent
  816. how to monitor/highlight upcoming expiry/due dates
  817. set a maximum of characters allowed in a cell
  818. Digital certificates
  819. Address's in Word document into Excel
  820. How do you Concactenate Fields in Excel???
  821. fill series by weekdays in XL 2007
  822. Creating combinations
  823. Is there something easier than a merge???
  824. getting small cirlces and squares when i click on cells
  825. Display all values in other cells with no duplicates
  826. formula using dates
  827. formula problems
  828. In Excel My Columns are going from right to left, how can I fix i.
  829. How can I combine multiple csv files with different number of records?
  830. Data validation dependent lists
  831. WTC Towers: The Case For Controlled Demolition
  832. Excel Icons lost
  833. convert number to text
  834. How do I add a border to a header or footer?
  835. 2003 - import external data problem
  836. converting a number to a text
  837. Find matching date in another worksheet, copy and paste data
  838. Trying to consolidate data from another workbook
  839. Browse For a File or Path and enter in a cell
  840. Sub Routine Call From a Macro
  841. formula to use next cell in line
  842. Pivot Table Not Working
  843. Enter date on one worksheet, pull data from another
  844. Opening an Office 2007 Excel file in Office 2003
  845. Enter date, then pull data from another sheet
  846. Large digit numbers
  847. how many columns are included in a standard sort in Excel?
  848. opening 2007 files in 2003
  849. adding reminder on worksheets or cells
  850. How do I write a conditional "IF" statement to color a group of ce
  851. Excel 2003 "file error: data may have been lost" after applying SP3
  852. calculating due dates
  853. How do I specify a date range for given cell?
  854. Command Button Click
  855. Speed of Excel When Inserting & Deleting Rows
  856. CAN YOU ALPHA SORT IN A SINGLE CELL?
  857. Email trigger
  858. Print Preview
  859. Excel as a products catalogue?
  860. sum colored cells
  861. links missing
  862. how to see the whole edit links list?
  863. How to code VBA: Auto open workbook and run macro
  864. Formats-Paste special
  865. Function for months name
  866. Automatically copy rows based on criteria
  867. Updating Charts in Excel 2007
  868. Excel 2003 not opening files selected....???
  869. Delete automatic headers/footers in dropdown lists in Excel 2003
  870. auto populating a cell based on another cell for an invoice
  871. how do I view cyrillic characters in excel
  872. Macro question
  873. Copy and Paste with Macro Between sheets
  874. Create Variances using Pivot Table
  875. How do I hide rows by using the + sign?
  876. Data Validation
  877. In Excel, show 0.00 for "zero" entries, but "-" if no entries
  878. Freeze Cell Once Information is Entered
  879. how do I find differences between two open excel files
  880. drop down list shows first blank row after last list entry
  881. Delete all negative numbers leaving only positive numbers
  882. Default entry to year other than current
  883. Macro creating folder and files automatically, without permission.
  884. drop down list starts from blank row
  885. Change the location of external data feeding a pivottable
  886. Workbooks.Open Filename:=.UpdateLinks:=0, IgnoreReadOnlyRecommended:=True
  887. Using Filters in Excel 2000
  888. Conditional Format
  889. Validation of cells who is dependent on each other
  890. overtime calculation
  891. excel date ranges
  892. A curly date problem
  893. In relation to macros
  894. How to kill an ActiveX object
  895. Calculating how many days past in a month from today
  896. Question about a MS online schedule template
  897. Formula Mystery
  898. Save row heights with VB copy
  899. Pivot Table- force rows with no data to be hidden
  900. Cannot open a .dbf in Excel that was saved in NotePad
  901. Top 10 autoshow in PivotTables
  902. Printing two two pages on one peice of paper
  903. Transposing Multiple Cell References to Multiple Values (NOT total
  904. Transposing Multiple Cell references as Multiple Values
  905. lowest of two closest numbers
  906. formatting code is showing instead of data.
  907. Three Pivots Linked By Page - Possible???
  908. Is Conditional Formatting Using WordArt Possible?
  909. Pivot Table Error Message - "Command Text not set for command obje
  910. Sorting Pivot Field List
  911. macro to move to minimum value in column of data
  912. Dynamic formula for Pivot Table
  913. Alter pivot with code
  914. Copying Text Cells
  915. How can I Hyperlink text on a picture to a different excel workshe
  916. htm slow to load
  917. changing file extention names
  918. Print Preview in Color
  919. Range selection with R1C1
  920. Conditional Format
  921. Use Letter Template but not Mail Merge
  922. I Need a forumula or VBA code
  923. Ref earlir post "If, SUM, VLOOKUP...oh my!!"
  924. Conditional Formatting- adding more than 3 conditions
  925. Compare two worksheets and identify common entries
  926. dates nad conditional formattine
  927. no blank cells
  928. Changing Direction Columns/Rows
  929. Ref earlier post "Excel Time Calculation"
  930. Moving Columns in a Pivot
  931. highlighting a search cell
  932. holding worksheet formats when copying/pasting
  933. excel-how to get the spreadsheet to move as I move the scroll tab
  934. Sorting Worksheet w/o breaking links to other sheets
  935. navigation
  936. excel pages
  937. Filtering a Pivot
  938. Concerting total minutes to hours and minutes
  939. Unhide Rows
  940. lookup function
  941. How to Hyperlink in an email?
  942. Creating borders via Conditional Formatting
  943. matching two columns in two separate sheets against one another...
  944. insert row above button (retrieve position of button)
  945. convert numbers
  946. IF, SUM, VLOOKUP...oh my!!
  947. can a symbol be inserted in front of existing data
  948. Excel time calculation
  949. formula for tab value
  950. Saving sort criteria
  951. Show a time 50 min before entered time
  952. Is there a maximum of the number of worksheets in a workbook?
  953. How do I keep formulas for being lost when saving in 2007?
  954. Dates / reversing
  955. sum x number of fields containing data
  956. How to copy comment box to other cells
  957. Data isn't imputting correctly
  958. Batch print excel files
  959. formulas in columns formatted as text
  960. If date in column A is less than 15th of month can I display next.
  961. how to make envelopes with christmas design?
  962. Cell reference moves
  963. Excel 2007 >65536 rows-convert
  964. Cell Reference
  965. Calculate no. of Sundays in a month
  966. Pivot Table - Repeat row data
  967. Location of AddIns
  968. Conditional Formatting in Pivot Based on other values in pivot. XL
  969. Can I make multiple comparisons ?
  970. Criterian Range taking value from another cell
  971. Maxium hours that excel accept
  972. Newbie Question
  973. macro reference changes with filename
  974. Unable to link!
  975. Range error
  976. change default page orientation from portrait to landscape
  977. I CAN'T SEE TOOLS MENU IN THE RIBBON
  978. dependent lists on data validation
  979. Can we change the format for pre set footers like date, time etc.
  980. Multiple "other" delimiters? Easy multiple cell merge?
  981. long time to save
  982. sum number of columns based on variable value
  983. Create Table
  984. AutoTabulate
  985. Create If statement that returns a tick when true
  986. find last row in a sheet
  987. Consolidating Data
  988. Referencing Cells in a Web Query
  989. How do I convert database to Apple format?
  990. Importing text files automaticly.
  991. excel 2003
  992. macro security problem
  993. Create Outlook Contact from Excel
  994. Export Excel Data to Excel Spreadsheet
  995. download trial version excel 2003? can only find trial version 200
  996. Is excel mailing list exportable to Outlook Contacts?
  997. Copy ranges into email - HTLM and Text format
  998. Location of AddIns
  999. Formulas not calculating - Calculation is on Automatic & I pressed
  1000. Office 2000/Vista