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. row placement & alternating highlighting
  2. Inputbox macro filter using "Contains"
  3. How to delete fist 6 digit of all contents in a column?
  4. Adding alpha-numeric value in from all alphabetic content in a col
  5. COUNTA - ADDING CELLS
  6. Formual If All Cells are Blank
  7. Page Break Preview
  8. Save details
  9. parameter query
  10. I wanting learding office
  11. name cells with their adjuscent cells
  12. date format code in national language version
  13. how to find duplicate values in a column during enter the value?
  14. Icon picture on excel files
  15. Negative Time Numbers
  16. Excel 2000 file slow to open--nearly 5 minutes!
  17. ? E 1 = plus or minus the difference of D1 & C1
  18. How do I autofill spaces in right justified fields?
  19. Text Alighnment Across Selection
  20. Somehow my spreadsheets have numbers instead of letters, why?
  21. Screen Problem
  22. Find and replace paragraph marks in Excel
  23. How do I nest more then 7 IF's?
  24. How do I copy File Path?? Excel
  25. How to create a list that shows one value and gives another
  26. backup??
  27. Solver model loading problem
  28. Worksheet and Formula assistance
  29. Extending formula series...
  30. Counting the times a number appears
  31. Printing Excel Workbook
  32. how do u make a freytag pyramid
  33. Defining lists
  34. Is there a way to upload a spreadsheet here?
  35. Merging two data cube reports
  36. Is it possible to select a multi value from a drop down box
  37. Doubt on extending series. Someone could help?!
  38. Why does worksheet print smaller?
  39. Hyperlink in Excel to an image
  40. Excel To PDF
  41. Can't Drag a cell on a password protected sheet (Excel 2003)
  42. Formula assistance please???
  43. Join tables like inner join in Access
  44. Rounding Date to Next Half Year
  45. Calcular Tool
  46. Searching or Find question
  47. How do I change a time such as 1:15 to all minutes such as 75?
  48. Missing Rows after Ungrouping
  49. Inserting row while retaining formulas
  50. MS Query - 2 Parameters
  51. Pivot Table to Tabs
  52. weighted mean
  53. Renaming Pictures
  54. Macro to find and record Unique values?
  55. Excel Spreadsheet Question
  56. Spreadsheet with data on two lines
  57. Linked Cells
  58. How to know the last row?
  59. User Defined FUNCTION
  60. Macro to allow auto filter after running password protect
  61. Average Calculations
  62. Cluster chart nightmare
  63. Excel 2003 assign keyboard shortcuts to specific special character
  64. autofill
  65. Get to Combo Box without mouse
  66. Fix for the slow opening of excel 2007 (Fix inside)
  67. autofill or auto reference
  68. plus or minus difference
  69. The button on my tool bar won't display
  70. Is there a shortcut for applying sheet formatting to another sheet
  71. Changing the look of a graph
  72. Question about count ONLY different Texts in a range.
  73. Command button unhides but not hides
  74. How to Cross-Post ??
  75. Macro - Formula RC[?] with ? being a variable number
  76. Is Logarithmic the way to go?
  77. MAX Foumula
  78. Can't scroll down
  79. Lookup?
  80. help with protection of sheets
  81. Excel
  82. View Code question
  83. Excel Drop Down List
  84. 2P import
  85. Excel Text Replace
  86. This doesn't look right to me
  87. linking dates on multiple worksheets
  88. Macro security seetings revert to "High" after reinstalling Excel
  89. link check boxes in multiple cells
  90. Column to text
  91. Excel 2002: Any faster way of deleting floating objects?
  92. 5th Conditional Formatting
  93. 5th Conditional Formatting
  94. Summary Sheets do not Link
  95. Using a macro to create a macro
  96. Adjusting Column Size
  97. How could I share a custom toolbar on the newtwok for all users?
  98. launching Excel clears clipboard
  99. changing a cell formula to value before save
  100. send email to each customer email in excel sheet.
  101. How to filter data in another sheet
  102. filtering (all) by value
  103. Page layout - page setup - items disabled
  104. IF function
  105. VLOOKUP
  106. Excel Sumproduct
  107. Automate pivot table selection
  108. What's the command to select row 1 to 8000 out of table of 24000 r
  109. Linking Cells accross Workbooks using Column Names
  110. Counting almost identical duplicates
  111. Creating a Unique Reference from 2 cells
  112. INDEX+MATCH=slow?
  113. how to convert numeric to words Example 525 in words (Twenty five
  114. =IF(B25="",ROUND(O25,-2),"")
  115. Can see the spread sheet Only in print priview mode..
  116. char()
  117. is it possible to record a macro that would lock a sheet
  118. Avoid 'Save As' with the same name
  119. Pivottable Sum of fields.
  120. Recovering passwords for protected worksheets
  121. Run-time error '1004'
  122. how do I automate emailing filtered data
  123. how do I remove table formatting from an excel spreadsheet?
  124. Lookup value and return with all related data
  125. Supervisor Hierarchy
  126. How can I make Excel save Unicode CSV data correctly?
  127. Comparing and Reconciling 2 excel tables
  128. How to copy excel to text in a certain order.
  129. Combine Sumif and Subtotal
  130. convert time format
  131. excel 2007 colors do not match excel 2003 colors.
  132. Eliminating weekends when subtracting dates
  133. converting word docs into excel
  134. Verify Textbox Information is a Number and Not Text
  135. How to regroup rows that have the same value in a particular colum
  136. importing Word lists into Excel
  137. How to add the same alpha-numeric value to all the content of a co
  138. Data validation error message
  139. difference in time
  140. Sumif function with a date range condition statement
  141. Zeros after the decimal
  142. Digital signature - files for download
  143. auto-updating index
  144. keyboard does not work right
  145. Disabling automatic formula arguments
  146. Excel 2003 Pro
  147. THANKS JOHN & BERNARD
  148. Formatting Page
  149. Round then round?
  150. Excel - lost my row numbers and column letters
  151. Excel 2007 .xlsm file. Macro Security options not available.
  152. word wrap in excell
  153. Opening old 2003 spreadsheet in 2007
  154. Inserting a blank row after subtitle row
  155. calculate totals from added sheets
  156. Using enter key in the cell
  157. Unique value party
  158. My Excel icons disappear from the taskbar & another issue.
  159. $ and 0.00
  160. HeapSort VBA function
  161. How do I save an excel workbook as a DBF file
  162. Printing alignment
  163. How do I set up a spsht to allow adding data only - no deletions
  164. Publish Excel to a web page
  165. Showing which cells are locked
  166. 07 Custom style does display banded column styles in preview
  167. Adding text to Excel Worksheet
  168. error with adress function
  169. Conditional formatting different on XL2007 than XL2003
  170. Count and Sum multiple values for a single entry
  171. Print Ranges based on conditions
  172. Doing MS Training in Excel, having Macro Issue
  173. Excel 07 - Formula won't calculate - please help
  174. what would the script look like to open a new sheet
  175. Query via Import External Data doesn't reflect revised syntax
  176. How do I restrict data entry to one of two columns but not both?
  177. 3 COLOR SCALE CONDITIONAL FORMATING WITH FORMULAS
  178. Make range of cells mutually exclusive
  179. Excel Quick Access Toolbar Commands not working?
  180. Custom number format for driver's license number
  181. Hide only rows that are not bold?
  182. Data Validation - allowing only negative numbers or converting
  183. Series Capture Feature is Turned Off
  184. Copy Graph But change Data Sheet
  185. Name The Week Of The Month
  186. conditional cell formula
  187. Text to speech upon cell selection, Excel 2007?
  188. Calculating Average
  189. Rows disappear in pivot table
  190. vertical scrollbar in Excel
  191. Pivot table question
  192. Eye-sight and errors
  193. Receiving Spreadsheets Inline
  194. Sum
  195. How to average hh:mm:ss when hh is 00
  196. Formatting
  197. counting cells that fall within a certain date range
  198. Excel 2007
  199. Rounding
  200. Add-Ins
  201. set a variable based on a vlookup
  202. Linking Drop Down Boxes
  203. How to look up a =COUNTA and =SUM formula from another sheet?
  204. Printing comments
  205. Hi
  206. Why, please?
  207. key shortcut for PasteSpecial->Values
  208. sort of the field area's totals in pivot table
  209. How do I restrict data entry to one of two columns
  210. How to show only Month of a mm/dd/yyyy format?
  211. Excell Arrow Keys
  212. Lookup Index Match??
  213. RE: Excell Arrow Keys
  214. Conditional Formatting within a Pivot Table
  215. RE: Excell Arrow Keys
  216. RE: Excell Arrow Keys
  217. Links
  218. how do i set up a chequebook transaction recoed in excel
  219. naming a sheet the same as a cell in that sheet
  220. Find cells using wildcards
  221. Reversing the log
  222. Reducing decimal places
  223. Change a specific figure i.e 0:00 and 24:00 to display as "MIDT"
  224. Creating setup file for excel add-in
  225. Bloomberg and Indirect
  226. excel Formula
  227. Problems with Photos Moving
  228. Unmerging A Named Range
  229. Excel problems
  230. Cannot read Excel 2007 despite installing Compatitibility Pack
  231. printing confriguration in Excel
  232. Excel 2003: Pivot table value field settings
  233. Calculating average ages
  234. If two instances of Excel open top right "X" close only one
  235. conditionl format overrides explicit format
  236. Health record Template
  237. TRUE OR FALSE CAL FOR A STRING EXAMPLE C1 C2000 > D1 D2000
  238. Compiler Error - Not an Appropriate Name
  239. Secondary list
  240. autofilter
  241. why do I get a series of pound signs in a cell?
  242. List of Features/Options/Functions No Longer Available in XL 2007
  243. Convert hard coded query criteria to Parameter Query
  244. How do I store frequently used text in Excel for auto-complete?
  245. create columns within a text box
  246. SUMIF to clsoed workbook
  247. Link Excel 2007 file to 2003 files
  248. Loop Statement through If Not IsEmpty Then Paste into Destination
  249. Paste from Word table into Excel
  250. linked workbooks - how to move color as well as data?
  251. Compare Excel files and spreadsheet 3rd party apps
  252. 2003 vba in 2007
  253. Standard formatting not being applied to negative percents
  254. How to define a drop down row filter in cell C2 for cells C3:C27 ?
  255. How to create a Pivot Table
  256. Font Formatting
  257. Max values entered and format
  258. How do I create a lookup using layered parameters
  259. Date format for general formatting
  260. CONDITIONAL FORMATING: 3 COLOR SCALE REFERENCED TO A DIFFERENT CEL
  261. I do not want formula to round out the number how do I turn off
  262. Select Range based on column name and not A1 notations
  263. consecutive numbering on multiple worksheets
  264. subtotal
  265. new row without effecting equations
  266. Watermarks on Excel
  267. Compound Interest
  268. moving data to one row
  269. macro vlookup between 2 files
  270. Cannot find source of external workbook links
  271. How do I save excel file in text format without columns?
  272. Can information from a cell be placed over the top of an object?
  273. chart referencing
  274. Subscripts
  275. Conditional formatting in Ex2007 seems to be different than in Ex2
  276. Formula Bar Syntax Tips Disappeared!
  277. View in page break preview
  278. Excel calculation help
  279. Importing Text
  280. How do I consolidate data into ranges
  281. Compatability Issues between 2007 and 2003
  282. Numbering data as entered
  283. Excel: how to convert text to upper case upon entry?
  284. set up a shared workbook to be view/edited at the same time?
  285. How do I copy from one workbook and paste to another in excel?
  286. Question about linking please
  287. Add Cells Using Multiple Files in One Folder
  288. prevent pivot tables / charts from editing
  289. Customized user exit warning/reminder
  290. Test Post
  291. Mandatory Input of a Cell
  292. Linking to another workbook
  293. Help With Linking Drop Down Boxes
  294. Question regarding lookup
  295. use dynamic data source to make pivot table
  296. Copy value of the cells but not formatted one
  297. IF with nested AND
  298. Specify a range when using 'Import data'
  299. Formula Changes when I delete other cells
  300. Broken Excel Links - move files to another computer
  301. 2008 East Coast US Excel User Conference
  302. Shortcut key for aligning data in cell
  303. how to change pivot value form column to row
  304. List?
  305. Excel formula
  306. can't open Excel file sent as email attachment, direct from OE
  307. Worksheet protected
  308. IF function
  309. filtering for numbers ending in 000
  310. Pop up Julian date
  311. if a number lower than 30 than the cell turns yellow??
  312. How do I import from csv file without auto formatting?
  313. Highlight more than one entire row when cells = TRUE
  314. how to find duplicate numbers?
  315. fill a cell color using date in one cell and "yes/no" in another c
  316. How do I reformat data into ranges
  317. How do I delete a missing reference to a Macro
  318. Reset Ctrl+ Macro Shortcuts
  319. Finding Number Inside a Cell
  320. eliminating hyperlinks from a complete column in Excel
  321. help text suddenly too small to read, Excel 2003
  322. curve fit equation
  323. paste link
  324. Help on: IF no "," found in cell then...
  325. Getting correct results for lookup?
  326. I saved and shouldn't have! Can i get that older file back?
  327. Retain value of merged cell in all unmerged cells
  328. SUMIF vs SUMPRODUCT
  329. Excel adds a 1 to the end of the filename.
  330. where is this in 2007?
  331. Pivot Table column sizing
  332. Custom Cell Format - Revisited
  333. row color formatting lost going from 2007 to 2003
  334. Match & Merge columns
  335. Excel 2007 Function Library
  336. Automatic insertion of page breaks
  337. Copying selected data and headings
  338. custom footer
  339. Scientific Notation - Suppression of Auto-formatting
  340. Problem attaching with Word 2003
  341. Excel
  342. excel word art in 2007
  343. Cutting and Pasting Cells into a shape or textbox
  344. Message Box with a list
  345. Drop Down List complication
  346. combine contents of multiple rows in one row
  347. cell protection
  348. HELP...SUMPRODUCT with multiple criteria
  349. SUMIF statement with AND statement
  350. Print B&W in Excel 2007 vs. Excel 2003
  351. mediam
  352. Sum multiple invoice number
  353. Sum if two varialbles (sum if and if)
  354. Excel Calculation with Time
  355. Day/Date/Week
  356. xlsx 2007 display only 65536 rows
  357. pivot table calculated fields
  358. when pressing forward slash key numbers appear below headings
  359. Divide Cells on a spreadsheet by 1000
  360. Macro: Paste Values
  361. balance checkbook register using online banking
  362. Excel Pivot Table Format Messed up
  363. MS Excel & Powerpoint Copy & paste
  364. Filtering
  365. Printing in Excel
  366. Protecting cells with VBA (Excel 2003)
  367. Asterisk is missing from list
  368. Creating macros with if stmts
  369. How to insert columns aftre each column of data
  370. Highlight a row yellow if a cell contains TRUE
  371. Handling Large Files
  372. Error when creating hyperlink
  373. How to Reduce value in a column by 5%?
  374. I need to count and / or sum cells with specific text colours. Hel
  375. alternate rows with date
  376. fill series with alphabetic
  377. UTF-16 ?
  378. Is there word art like MS Excel 97-2003 in MS Excel 2007?
  379. Look-up
  380. Save as file format excel worksheet 4.0 in Microsoft excel 2007
  381. Inserting formular in Table
  382. Excel2007 importing issue/bug
  383. RE: COPYING FORMULA CONTAINING NAMES... ( 2ND POST)
  384. INSERT COMMENTS INTO PROTECTED SHEET
  385. Private Sub - Called from Userform
  386. sumif with 2 variables
  387. Count occurences of time
  388. Converting formula into values
  389. Selecting Rows using Long Variables
  390. why is there no A3 page size available in excel?
  391. If Statement to run a macro
  392. Cal the different of 2 date (MM,YY)
  393. 1st of current quater today()
  394. Assign Values to array
  395. how do I assign a CTRL + shortcut key to a menu item (paste speci.
  396. Formatting Text on Option buttons
  397. Pulling table into new worksheet
  398. my worksheet tabs are hidden
  399. Excel #Value! Error on external link, when source file closed
  400. textframe autofit
  401. copy a color
  402. linking pages of a workbook
  403. Formula returnsas "1" even with nothing to solve for?
  404. sum of last 3 figures in a column which also contain empty cells
  405. Unhide rows 1 - 9
  406. How come Excel is printing only blank pages?
  407. Not able to fSave the file on Excel 2007.
  408. How to count date difference in excel?
  409. Go to cell with maximum value when worksheet opened
  410. Cell Merging Issue
  411. Formulas in Excell 2007 nor working
  412. substract cells from other cells then forwarding to a different ce
  413. Help refining sumproduct
  414. Cell Text Alignment - Not A Centering Issue
  415. Description in custom macros
  416. Function to sum same cell in several worksheets
  417. HELP still needed - BOXPLOT OF Deciles
  418. **Finding the sum of multiple time intervals**
  419. quarter report
  420. what is meaning of insurt menu name option
  421. Reference worksheets in ascending order
  422. Calculate number of weeks between two cells
  423. HOW TO CREATE a BOXPLOT of DECILES?
  424. Need code to copy and paste based on cell address.
  425. HOW DO I FREEZE THE 1A ROW IN EXCEL
  426. Amortization Tables
  427. automatic "date update"
  428. Please can you help. I can not remember what the special formula step is.
  429. Adding time
  430. subtotals showing 0 in summary level// 2 subtotal levels
  431. Rows and Columns
  432. Huge problem with time
  433. CTRL+C not COPY anymore - seems to be delete cells
  434. Problem upgrading to Excel 2007
  435. Drawing Lines In Excel 2007
  436. Numeric value in cell
  437. Pivot Table Toolbar
  438. Print area won't change
  439. How to update an excel sheet dynamically from another excel sheet?
  440. HOW TO CALCULATE AGES IN AN ENTIRE COLUMN??
  441. UDAYAN-Conditional Formatting
  442. Formula Prompts
  443. In cell using minus changes value to sum formula instead of enteri
  444. VLOOKUP WITH WEIGHTAGE
  445. PROPORTIONATE DISTRIBUTION - CHALLENGING QUESTION 4 SURE
  446. LOOKUP into a different Sheet
  447. mail merge in excel/losing leading zero
  448. turn areas blue
  449. Installing Excel 2007
  450. Specific sort order
  451. Copy Source Cells to Destination Cells Only when a Change Occurs
  452. code question
  453. how do I copy an existing file to a flash drive
  454. cut/paste text into cells (wrap text)
  455. How to reference a cell?
  456. How to reference cell?
  457. Hide a sheet using code
  458. Validate Data Message Box
  459. Extention a formula to a new location
  460. Macro for sequential numbering.
  461. formula in VBA
  462. Form Toolbar verses Control Toolbar
  463. In VLOOKUP() can one "fetch" a range of columns?
  464. Lotus Conversion
  465. Question about pinning a document to the Recent Documents list
  466. How to make inserted picture transparent so the cells will show?
  467. Pivot table sorting
  468. Losing lines when pasting charts to Excel
  469. Use text in formula as a cell reference
  470. file name length
  471. Networkdays formula in macro
  472. Pivot Table
  473. Hyphenate
  474. Import FROM quickbooks
  475. Excel object in word document; some cell borders are too dark
  476. Adding time, but only to 80 hrs.
  477. Excel Theme Colors Strange Behavior
  478. Complications putting text into multiple lines within a cell
  479. Import datas into defined LIST
  480. access
  481. How do I allow users to view grouped rows while still protecting d
  482. sorting columns sorts header values too
  483. Synching worksheets in same workbook
  484. Special Private Character Question
  485. TextBox Question
  486. TOC: the first page number of each worksheet
  487. Inputing data into Pivot Table
  488. HOW DO I CHANGE THE DEFAULTS ON THE "FIND" TOOL?
  489. Exporting Excel Sheet With Additional Info Added To A Text File
  490. Histogram bins being ignored
  491. Quarantine workbooks
  492. Is this possible? SUMPRODUCT with criteria range?
  493. Column Headings
  494. Shortcut to a Macro
  495. match identical cols
  496. formatting spreadsheet cells to tab between
  497. how do i clear formatting on new excel files?
  498. Macro to hide rows
  499. How can I open up a Lotus 123 spreadsheet in Excel 2007?
  500. Pivot Table
  501. If Largest Data Pull Name.. Help!
  502. Splitting Date and Time
  503. Drop-down list with Lookup function?
  504. How do you view files in an alphabetical ORDER ?
  505. macro for footer
  506. Saving a file and not allowing it to update cells
  507. Getting names data information from another sheet
  508. Macro Image Import Size Issue
  509. Pop-Ups in a spreadsheet?
  510. raising multiple cells containing numbers by a percentage
  511. Problem with Printing Legal Size
  512. Horizontal scrolling problem with new mouse
  513. Change cell color
  514. Ctrl and Tab functions broken
  515. import multiple csv files into excel 2007
  516. how i change standart format to comments?
  517. Formula help needed
  518. Printing an excel sheet
  519. Como fazer um grafico de pareto utilizando o Excel 2007
  520. EXCEL 2003 AUTOFILTER PROBLEM
  521. Updating Formulas
  522. Returning a text string after a 2 criteria search
  523. Display maximum value of matching values in a different column
  524. Query to take values from Cells
  525. Delete rows that contain colours?
  526. More on text in Comment Boxes.........
  527. formulas showing up in an empty cell by themselves
  528. Lookup on more than one variable in 2003
  529. MONTH display
  530. date problem with mail merge
  531. Count
  532. Status Bar - SUM function adding grouped cells
  533. Excel 2003 how to stop emails from turning into hyperlinks?
  534. Excel Sheet Off To Side
  535. formulas
  536. index, offset, match, i dont know what to use
  537. can't seem to activate an open workbook
  538. Cell that contains formula but needs to allow text as well
  539. Conditional Formatting
  540. Ongoing Average Calculation
  541. Gridlines have to be chosen each time
  542. Finding a value in a multi-column table
  543. setting column width
  544. Selecting Pages to Print
  545. Pivot table macro
  546. Naming the range of data
  547. Precision As Displayed Has Failed Me--Help
  548. if statement with date format
  549. copyright symbol
  550. How can I link two workbooks together
  551. Percentage Formula
  552. Drop down list query
  553. Use of MATCH
  554. Can I attach 1 worksheet from an excel spreadsheet to an email
  555. how do i calculate negative hours in excel
  556. Excel Drop down menu IF statement help Please
  557. Sorting dates in the format Jan Feb Mar Apr ... ???
  558. Fine tune scroll amount
  559. Change default font for single workbook
  560. Setting values in a cell
  561. Format "find results" so that they are hi-lighted?
  562. email part of worksheet
  563. Event Macro With Multiple Pictures
  564. MACRO
  565. How do I change the default folder for My Templates?
  566. Excel 2007
  567. Converting formulas to values
  568. freeze pane
  569. i am trying to figure out how to divide one cell with a line
  570. Can I attach just 1 worksheet of an Excel spreadsheet to an email
  571. Merged Workbooks Overwrite existing text
  572. Filtering Filtered Data
  573. View worksheet tabs
  574. Inserting Rows
  575. Cross match data in Col A v/s Col B and display match in Col 3
  576. Sorting Numbers
  577. Format to lowercase
  578. VLookup Freeze?
  579. Take values for Query from Sheet
  580. VLookup - Column name?
  581. Add-in Descriptions
  582. Create a list in a shared workbook
  583. changing column letters to numbers , etc.
  584. How to spill over into a "" cell?
  585. need this formula to exclude cell value 'x' and 'xx' when counting
  586. Show or blank out a cell dependant on an selection in another cell
  587. Priority order in conditional formatting
  588. Evaluating a group of cells
  589. Changing sheets after the DeActivate Event.
  590. How do I close all workbooks and exit excel with one click?
  591. Unhiding Columns
  592. very simple question need to count number of rows
  593. Let user insert value that highlights closest value in an array.
  594. I would assume this is possible
  595. See column or row total on bottom of worksheet?
  596. Stop error checking a cell that has been formatted to text
  597. Data Validation - can you use another workbook?
  598. Updating a reference ROW
  599. How many conditions can I apply to a cell? I need to apply 8.
  600. need help with links
  601. Excel 2002: Unstable color setting in converted file
  602. Urgent Formula Help Required
  603. 12 Sheets - Submit to One Main Spreadsheet
  604. pivot table (blank)
  605. How to let Excel not to save the tmp files in the same folder?
  606. Macro button to print sheets populated from drop-down list
  607. EXCEL 2007 EXTERNAL LINK ERROR-NEED HELP
  608. filtrowanie danych z jednej kolumny na podstawie kryterium z dru..
  609. expanding the size of all cells in a range
  610. Excel Alt Return
  611. How can I get Excel for Free?
  612. Random text via Macro button
  613. Merging multiple (n) cells into one cell
  614. Range recalculcation
  615. CONDITIONAL SUM FOR ONLY VISIBLE CELLS
  616. I WANT THE MULTI CELL DATA IN ADDRESS FORM OR IN ONE CELL
  617. installed sp1 and now only compatability mode works
  618. If or Lookup or Something else
  619. Excel print jobs
  620. help with counting down to a date in excel
  621. custom percentage calculation
  622. Template
  623. Formulas
  624. Email data from a form
  625. Saving data from a cell reference
  626. condtional format - hightlight max results
  627. how to do these things in Excel with and without VBA?
  628. How do I create a formula for this equation
  629. look up zip code
  630. Using a cell reference as a file name
  631. Expert in Excel Needed.... HELP
  632. Need help in date format
  633. Greater and less than
  634. Saving file without empty cells
  635. Hide/Show Data
  636. Cannot insert illustrations or charts
  637. Change columns after a certain cell
  638. Sorting Formulas
  639. Highlight a complete row when scrolling
  640. Excel Data Analysis Tool Pak
  641. RoundUP
  642. Arrow Keys in Excel no longer work correctly.
  643. formula to bring value from another sheet with different spaces
  644. Data Validation
  645. Page Breaks for entire spreadsheet
  646. Name The Day Of The Date2
  647. split panes / freeze and zoom
  648. Concatinate name and date
  649. format issues with decimal places
  650. how do I send selected cells in an e-mail using excel 2007?
  651. how to display rows of data in a single column
  652. Naming Of A Day In The Month
  653. custom cell
  654. Cursor stuck
  655. First Positive in Horizontal Array
  656. How do i setup tabbing order of cells?
  657. Time Function
  658. In Excel sometimes the end of the text does not wrap - why?
  659. If number in cell does not equal 6 digits, add zeros to the left
  660. Offset vs vlookup functions
  661. Sorting
  662. Excel new window view
  663. QUESTION REGARDING HOLIDAYS
  664. List multiple values in seperate cells
  665. Excel opening another instance automatically
  666. i need helps with Options on the tools menu
  667. Excel-Outlook Contact List
  668. How format partially one text cell for font, etc., but not whole c
  669. DARKENING GRID LINES WHEN PRINTING
  670. date fomulas for tracking data entry times
  671. fomulas for tracking time entered text or data
  672. .xls Extension
  673. Pivot table summary
  674. Average of column with changing numbers of records
  675. Char(10) and blank lines
  676. Moving text box
  677. excel-why do the columns A B C D etc and 1 2 3 4 etc print?
  678. Variable Text in Comments box.
  679. excel strike through button
  680. Count files in a folder
  681. Large file sizes due to images ...
  682. adding values and converting the sum to hours and minutes
  683. Count numbers between 0 and 2
  684. Select case for dependant lists
  685. sumif on a single criteria rows but several sum rows
  686. Relative references in conditional formats
  687. Time Format
  688. adding stock items to accounting reports
  689. Define alphabetic sequence to sort by
  690. Automatic closing Excel
  691. How do I convert a birth date to current age?
  692. Generic Worksheet Names
  693. averaging separate cells in excel excluding 0 values
  694. Block Printing of sheet
  695. Shortcut for Time Now function
  696. 2007 file not being read correctly in 2003
  697. Automatically Combining multiple spreadsheets
  698. automatic picture sizing?
  699. MAX then return value?
  700. Grey screen on one worksheet when opening excel file
  701. Sorting alpha numeric data
  702. grey screen when opening excel spreadsheet
  703. Equations in fil not being read correctly
  704. Direct path to Worksheet
  705. help with vbscript to average a report of dates
  706. How to Find Incompatible Cell Formatting XL 2003 / 2007 ??
  707. Have cursor go to specific place when worksheet opens?
  708. Repeat same data entry to multiple worksheets without Group Functi
  709. CAGR for short sales using XIRR
  710. How can I randomly sort a column of data using Excel?
  711. shading
  712. Running total within IF
  713. Workbook Protection so it won't open
  714. Removing text from a cell with text and numbers
  715. valor negativo de hora
  716. need to display the excel atcive control calendar to enter dates
  717. Excel Chart - additional information added
  718. Highlights/changes the column and row appearance as the cursor mov
  719. Sequential numbering by 6
  720. how can i use template wizard with data tracking in excel 2007
  721. filecopy Question
  722. Print Area to last cell with data
  723. File is slow opening
  724. formula needed for conditional formatting
  725. f2 function key
  726. chart size changes in Japanese environment
  727. Navigating on a worksheet
  728. How stop Excel fm asking to "increase security" when saving?
  729. Excel calendar?
  730. Error occur while loading Sheet1811111111111111111" HELP!!
  731. excel: combine several spreadsheets into one workbook
  732. Pivot Tables
  733. Toggle between two workbooks via MACRO
  734. Excel Formulas with multiple criteria
  735. My Cell Input is Changed to Different Value by Excel
  736. Re: Microsoft.ACE.OLEDB.12.0 - BUG
  737. Multiple IF values
  738. Conditional Format - Due Dates - 2 questions (2nd posting)
  739. Naming Ranges
  740. Excel 2007 Autorecover
  741. How do I enter a "Tick" symbol in Word or Excel?
  742. Page numbers across multiple tabs - one sequence
  743. Conditional Format
  744. Excel 2003 Control Toolbox
  745. Selecting a cell for fill-in by previous cells
  746. Assign a macro so I can just single click it to run it
  747. Opening file in Excel
  748. Spell out date
  749. if formula
  750. COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES
  751. ctrl + down
  752. Sort by date but not year
  753. Rounded corners on Tables
  754. ATTENDANCE SPREADSHEET
  755. Switch to change data fields to 0's, then back to original data?
  756. tell me the formula of converting amount to million from koror
  757. data not updating
  758. F KEY SHORTCUT
  759. Count number of positive values in range
  760. Importing Tables from Word to Excel
  761. pivot count unique records only
  762. Filters on Excel 2007 Tables
  763. Sort
  764. No "Comments" in Paste Special
  765. char 124 where is on my keyboard.
  766. How to connect excel(If I consider it as a database) with a websit
  767. How to view data using a mouseover?
  768. AUTO CORRECT PROBLEM
  769. Easily extracting data from one spreadsheet to another
  770. Adding to drop down lists
  771. Private Sub - Only Accessible from same Module?
  772. Copying forward a number
  773. How do I put spaces in a field
  774. Grouping & Outline
  775. Average / sumproduct based on multiple criteria
  776. How do I retrieve a file deleted in error?
  777. Excel 2007 - Consolidation question
  778. Excel limitations
  779. how do i get rs format in excel? or is there any chance to add ou.
  780. How do I round up the answer an iferror formula?
  781. Another Parsing address question
  782. Text match from web query
  783. Custom format numbers
  784. sequence of input
  785. Turn off grey background in picture
  786. Johnranges function.
  787. What is "Bridge" excel and how does it work?
  788. Link Combo box
  789. Unable to sort when column is included in range
  790. double click cell to show formula references
  791. Can't open Excel from Office 2007 due to spell check
  792. payment worksheet
  793. Conditional Formating
  794. Fixed Width Text Import Settings
  795. Formula to find cell
  796. Excel 2007
  797. Macro to set cell interior color?
  798. MS Exel 2007
  799. Print range
  800. Data-Validation -List - Pick from a drop down menu
  801. Suddenly border of cell not highlighted when I click on it
  802. Conditional Formatting "Between"
  803. #NAME showing in Excel 2007 but Excel 2003
  804. Close all
  805. rename groups in Pivot table
  806. Close all
  807. Convert Text To Number
  808. Print Drop Down List
  809. '08-'11 Days of the Wk per Month
  810. Auto insert row while entering raw data
  811. How do you lock formats?
  812. Data entry problem
  813. Need help with vlookup nested function
  814. File formats : XLSB versus XLSM
  815. How do I enter a Hard Return inside a cell?
  816. Close vs. Exit in 2007
  817. Is there a button to close multiple files simultaneously
  818. Is there a way to scroll (w/mouse) when entering a formula in 07
  819. Strange Message when opening workbook
  820. Excel Issue
  821. Auto fit text in cell of a protected worksheet
  822. Does anyone have a generic 'warranty approval' form/document?
  823. FREQUENCY FUNCTIONS
  824. Customize macros Very urgent
  825. Linking Text
  826. remove duplicates from one cell that has been combined
  827. XML File Opened In Excel is Missing Header Row
  828. Macro to insert an object in a specific cell 2007`
  829. Status Tool Bar and "Calculate"
  830. Lookups
  831. Filter Criteria - Excel 2007
  832. Control Data Entry - push entry to next cell
  833. Display contents of associated cells
  834. Download link ok?
  835. Custom Format
  836. Fluent UI and protect workbook with password
  837. Insert Function next to formula bar gives Run-time Error '50290'
  838. month function
  839. page setup chaged when I used different computer
  840. Open and Close a Workbook to Update Links
  841. Hide the answer to an equation until all values are inputed
  842. autofill timestamp
  843. Graph Creation in Excel
  844. filter a column from other sheet.
  845. Prefix in every cell
  846. not equal to
  847. Problem with Save As
  848. Creating a HyperLink
  849. Mouse movement in EXCEL
  850. Freeze Panes in 2007
  851. conditional formatting to group rows with repeating entries
  852. Input selection choices
  853. Excel no longer marks selected cells by highlighting them in blue
  854. Counting Dates
  855. Data exported from Lotus approach to excel how do I show it in a u
  856. namebox
  857. after saving excel 2003 file, functions do not update anymore
  858. Expanding a data table to include an extra row
  859. Time and Date Formula
  860. Auto colour when other conditions already in place
  861. All about numbers
  862. Conditional Format - Identifying Highlighted Cells
  863. Formula error - Excel 2007
  864. Time Formula
  865. Pasting Spreadsheet into Word
  866. Cell automatically copying to multiple sheets.
  867. Moving Columns
  868. Applying multiple distinct conditional formatting rules
  869. Converting a range of Excel 2003 Cells to a Single text string
  870. how to display error message?
  871. newsgroups
  872. Column Text
  873. Weighted averaging of dates
  874. rearranging formula suggestion
  875. How to display decimal number only?
  876. Print Worksheet Poster Size
  877. combining documents help needed
  878. how do I write a macro to show the find dialog box in excel 2003
  879. how do I extract only certain data from a cell?
  880. need help
  881. CSV File
  882. How to return to previous cell?
  883. How do I copy and edit photos received in an excel spreadsheet
  884. using Sum Function
  885. Trouble opening xlsx with 2007
  886. Text copying disabled.
  887. Preventing Changing Formula's
  888. protecting specific columns in a worksheet
  889. Letter = Number
  890. whole numbers plus a percentage
  891. whole numbers plus a percentage
  892. Change hyperlink name to url
  893. Why isn't Wordwrap not wrapping the last sentence?
  894. Change Insertion Point
  895. How do I stop Excel from auto-inserting a date?
  896. Merging Workbooks
  897. Change default from 2007 demo to 2003
  898. Can't get my "'s Right - Never !!
  899. Number Format
  900. add column into another column?
  901. How to delet browsed pages list from the insert hyperlink
  902. formula help
  903. Excel 2007 slow changing between worksheets
  904. Reference to sheet name in another workbook
  905. restricted permission for worksheet
  906. Conditional Format based on existing cell colour ?
  907. FINDING TOP 20 (URGENT PLEASE)
  908. Lookup value needed
  909. How do I add column headings to the single sheet.
  910. Using merge cells in worksheet for Pivot Table
  911. what is the formular to use from one wokesheet to a new workbook
  912. The Instruction at "0x749860a0" referenced memory at "0x00000000"
  913. Copying different cells from one list to another
  914. INDEX/MATCH #REF! error
  915. Sum formular using vlookup
  916. menu bar
  917. Were is the Tools menu in EXCEL 2007?
  918. grabbing data from another website
  919. Locked for editing problem...
  920. Cycling through workbooks
  921. Change Field On Pivot Table Using VBA Input Box
  922. 2008 to 2007 - How can I find the extremities of a worksheet?
  923. Conditional Formatting on empty cells
  924. Combine two columns and delete original
  925. Getting cell index from cell to the right
  926. cell is blank then dont count range
  927. Can I automatically hide a column with zero values in Excel
  928. Not at all clear on use of variables and/or object variables
  929. Weekdays
  930. Formula Tracing
  931. Time Format
  932. MATCH, Vlookup whatever
  933. Data Validation List with blanks
  934. CALCULATING A VALUE
  935. importing data?
  936. Quick way to link infos on all worksheets
  937. I cannot "nudge" using CTRL+arrows
  938. Lookup / Match function
  939. Restricted Access with Macros
  940. Working with dates
  941. if helf
  942. Comments
  943. how to email a single worksheet fro m Office 2007
  944. how to change this format?
  945. Macro-enabled workbooks
  946. closed workbook macro
  947. Make Paste values default...
  948. ROLE OF XML IN EXCEL 2007?
  949. Subtotal and Grand Total Functions
  950. Help!..Why won't my CSV file open?
  951. How to find dublicates in Excel and delete it?
  952. Formula Result = Volatile ??
  953. excel add-on (QUICKSEARCH)
  954. Excel 2007 sharing issue
  955. Anyone got an easy solution
  956. Counting values in mulitple worksheets
  957. Sumproduct absolute cell references
  958. VLOOKUP on multiple columns
  959. Copy Command
  960. HORIZONTAL SCROLLING
  961. How do I make Word Art fade from left to right?
  962. READ-ONLY PROBLEMS
  963. Setting margins in page break preview
  964. How do I format part of a text cell, but not the whole thing?
  965. Conditonal Format
  966. Protection of a Drop Down List
  967. Excel is pasting values, not formulas by default
  968. Importing data from another spreadsheet to a different format
  969. How do I suppress repeating data in Excel
  970. Date Formula
  971. Referencing Path
  972. Print Page #'s
  973. Change font in portions of cell with many characters (1000's)
  974. Possible Array Solution Needed?
  975. delete the actual symbol *
  976. Quick Access Toolbar
  977. Excel keeps adding in my date as part of my sum
  978. order in which pages print - Excel 2007
  979. Project 2007 Pro in Vista
  980. dates to hours
  981. copying HTML table into Excel
  982. Automatically creating new file and worksheet
  983. Listbox
  984. Refering to multiple tables
  985. Sumif
  986. how do I change column totals from number signs to amounts?
  987. Using reference column # in IF Statement
  988. Costed Multi Level BOM
  989. Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi
  990. decimal places and leading zeros
  991. Unable to update links
  992. Averages
  993. How do I disable pre-loaded shortcut?
  994. Using COUNTIF with AND
  995. aesthetics (how might I make it look pretty)
  996. How to keep Column headers with Autofilter & Freeze Panes
  997. quesiton on links
  998. Negative hours [h]:mm:ss
  999. How do I copy excel file to a flash drive?
  1000. How do I filter a cell to look for anything w/ text vs numbers?