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. Conditional Formatting Issue
  2. How to disable the message that pops up on hyperlinks in XL
  3. Getting the first data point from a list of data
  4. Calculate working days but change working week
  5. Counting if Date1 is after and Date2 is before another date
  6. Array - Count based on 3 conditions
  7. Returning an alternative value if lookup cannot be found in array
  8. Sumproduct Formula
  9. how do i import data from MS Autoroute 07
  10. Printing a subtotalled worksheet
  11. Protect sheet > unchecking "Select locked cells" has undesiredresults
  12. Excel 2002: Can I customise the file recovery?
  13. Splitting an excel work book in to two
  14. Cell Notation
  15. can i retrieve a document once it has been cut and moved
  16. COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
  17. Need Help with Substitute Formulas, etc.
  18. Get External Data : ODBC Lock Type
  19. Formula based on the lastest date for date
  20. Linking Excel Files
  21. Spreadsheets on shared drives..
  22. Attach button disabled
  23. Link to Excel files
  24. How do I stop a Excel 2007 file opening as read only?
  25. vlookup
  26. how do i translate number to arabic word
  27. Geeting Sheet background from Excel object model
  28. Password Problem
  29. Cell Style Button in Excel 2007
  30. Expiry mm/yy and validation
  31. Conditioning an array formula
  32. Format Cell and Data Validation
  33. Sum If in a Budget
  34. Why won't the copy/paste from PDF retain the row/column in excel?
  35. File size
  36. Lookup with two lookup values
  37. how do I find matrix characteristic values?
  38. Unable to view document
  39. copy formula
  40. Row to column conversion
  41. Stationary Row
  42. how to sum groups of 7 cells
  43. Hide Worksheet Page
  44. how do I set up a monthly budget with space for yearly expensives
  45. how do I find matrix characteristic values
  46. Converting daily data into weekly, monthly and yearly data
  47. Having Trouble Digitally signing a macro
  48. How to insert comma (",") in the end of each mail ID?
  49. Open a Folder
  50. How do I stop a Excel 2007 file opening as read only?
  51. Some data in Excel 2007 temporarily disappears. Why?
  52. Relative filepaths?
  53. changing parts of formula
  54. How do I open a workbook using a different window
  55. Sorting negative numbers?
  56. Cell formatting in excel
  57. sync between table in excel to task list in outlook
  58. need formula help
  59. autofilter was not recognizing rows after row 999
  60. Spell check giving "formula too long" - doesn't make corrections
  61. Filtering grouped worksheets
  62. Opening Excel - getting print dialog box
  63. convert xls file to word doc
  64. How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0")
  65. Nested IF Formula
  66. Excel 2007 - Summarizing Data
  67. Date formatiing - using code to show months
  68. macro to copy value from 2nd file, if a word found in a correspondingrow of both files
  69. Creating a chart template
  70. HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET
  71. report - separator lines
  72. Breaking a long column to print on one sheet
  73. PLEASE HELP
  74. SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?
  75. HOWTO Reference a named cell or range in a script
  76. Automatically gray out a row when a particular field is populated
  77. Automatically gray out rows when a particular field is populated
  78. splitting forenames/surnames into separate columns
  79. expanding columns in excel 2007
  80. repeating a page of formula
  81. repeating a page of formula
  82. when i copied text to excel 2007, how do i convert it to number
  83. cells want automaticly update
  84. about Matching
  85. hyperlink from dropdown list
  86. missing patch (.msp?)
  87. a cell is set to email contents-cannot undo-changes my formatting
  88. Import an MS Money 2007 file into MS Excel 2007 worksheet
  89. Syntax HELP
  90. How do I unhide an excel 4.0 macro
  91. Tallying student scores
  92. Speeding up Excel 2003
  93. Copy format of cell from other worksheet
  94. What do I use to reference the same cell in multiple formulas
  95. How can I "re-hook" my worksheet window to my Excel window?
  96. Adding column numbers
  97. How to calculate between two date/time fields?
  98. exclude amount from sumif total based on how many months
  99. How to lock conditional formatting in pivot tables?
  100. How to lock row height in pivot tables?
  101. Moving In Excel using Ctrl-right arrow
  102. Page Breaks. They are showing up around every cell!
  103. Conditional Formatting help
  104. Selected items (eg count) does not show up on status bar
  105. How can I "re-hook" my worksheet window to my Excel window?
  106. multiple cell sections with one click for one cell
  107. Greying out text
  108. Problem in adding the Column
  109. How do I remove zeros from a linked blank cell?
  110. Inverse ... Formula or Function?
  111. Counting by numbers of Characters in a cell
  112. Controlling Decimal points in Formula
  113. Cell pointer
  114. Print a chart with worksheet data in excel 2007
  115. Appending data from two sheets according to like fields
  116. View which cells are locked?
  117. Combine two predefined borders
  118. How can I pop up a picture when a cell is clicked on Excel?
  119. Large Default Display Size of Ribbon
  120. Macro accessible to all users
  121. Creating names for individual cells over a range
  122. Excel files - macros & links
  123. how can I import a PDF into Excel 2003
  124. how do i append records to an excel spreadsheet
  125. Pivot Table Display
  126. How do I stop selecting multiple cells in Excel with cursor?
  127. Move cursor to specific cell from a specific cell
  128. Need macros for copy data into new workbooks
  129. Print worksheets in external workbooks
  130. Control Toolbox
  131. How to set a conditional format that is dependent on cell type
  132. Still can't view multiple worksheets
  133. VBA to check is someone else has a workbook open
  134. Increasing cell address by a set amount
  135. Variable passed to database query
  136. Excel 2007. Self Digital Signature invalid, can't del.
  137. How do i compack the excel workbook ?
  138. Different objects-same sheet
  139. Investing data in a table
  140. find column letter
  141. Time Average in Excel
  142. sum with 2 conditions
  143. Auto open workbook(s)?
  144. 2008 East Coast US Excel User Conference - Regular registration ends
  145. how to populate many worksheets in a workbook
  146. Importing Excel report into Word showing headers and footers
  147. Security Question
  148. Help with Excle Formula
  149. Special Paste to Next empty row if new data and mark copied Macro
  150. vlookup, move down a row
  151. Wildcards with Sumproduct?
  152. No possibility to save to original spreadsheet
  153. musical notes displayed in Word (offic 2003)
  154. show excel work book in webpage using MOSS
  155. How do I use the same Autocorrect options in word and excel
  156. break the cell by words
  157. Slow Worksheet WHY?
  158. strange about ":"
  159. Excel for cash
  160. Microsoft Office Excel has stopped working
  161. Want to make formula automatically figure out cell number in the r
  162. is there a way to make floating data blocks on the page
  163. Windows Media Player disables Clipboard in Excel
  164. combining worksheets
  165. Problem in hiding columns
  166. Pivot chart
  167. Data Count of cells
  168. Adding up values corresponding with repeating names
  169. Help with Formula
  170. too many cell formats
  171. Cell formulas are not recomputing
  172. How to lock row height in pivot tables
  173. return value
  174. row to column
  175. Total rows when sorting data
  176. #NAME errors on e-mailed Hyperion Retrieve spreadsheets
  177. Excel Data into a Quote?
  178. Lost Microsoft data
  179. MS Excel transpose error
  180. Categorize certain times of day as other days
  181. Blinking A Cell Content
  182. how to add sound ( beep ) if cell content changes in live data
  183. vlookup - lookup with an array in another workbook?
  184. Summing a variable number of rows
  185. How can change range to select active rows instead of :=Range("S10
  186. Formula converts value into Feet, Inches & Fraction of an Inch
  187. combine data
  188. page break preview
  189. find text in cell
  190. Concatenate Variable Array of Text Cells
  191. Moving Cursor within same cell
  192. Setting Default (Normal) Template
  193. Date Stamp in Footer
  194. data analysis add-in
  195. Create two columns from a single column with (first and last name)
  196. Iterations & Automatically Solving If Statements
  197. How to rate perfomers on a scale from 1-5
  198. Need to display values instead of formula; Ctrl + ` doesn't work
  199. pivot table report not valid when opening xls created in 2007
  200. Clearing Multiple Filters?
  201. Macro to create multi files from a template with different data
  202. Convert xls to xlsx - does not delete old file
  203. Comparing 2 spreadsheets
  204. One cell to many cells (two different work book/sheets)
  205. Quick way to elimate BOTH identical records?
  206. How can I make spreadsheet content link to another sheet and have.
  207. subtotal within subtotal
  208. defining names in a macro
  209. Formula changes as new data is entered...
  210. Specifying filtering criteria for ms query in excel
  211. Excel Text Wrapping issue
  212. NETWORKDAYS Troubleshoot
  213. Add csv to Open "All Excel Files" (XL2007)
  214. Identifying next number in a range and referencing it
  215. MAX formula and 'empty fields'
  216. header and footer view
  217. 2007 Pivot Tbl to Access Conversion Issues
  218. I can't right click in an Excel 2007 sheet
  219. PivotTable question
  220. Countif only once
  221. sheet tab options
  222. Maintaining Hyperlinks on a pen Drive
  223. dAY wORK wEEK
  224. Create list from criteria
  225. Comments box
  226. Indirect function across sheets
  227. Pivottable code problem
  228. excel sub-par performance
  229. Excel Insert Typing field has disappeared
  230. Excel 2007 Printing problem.
  231. cell shading
  232. deleting of worksheet
  233. masking with symbol xxxx
  234. sheet tabs
  235. Strange problem writing Excel formulas using .NET
  236. cell display 2
  237. CTRL + `
  238. VBA code for sizing/showing pictures
  239. vlookup to find match only part of a text value
  240. lower case letter "i" always converts to upper case
  241. delete conditional formatting via macro
  242. Report Format - Pivot Table not working
  243. Picture in a cell
  244. Lookup a value and count the number of associated occurences
  245. Conditional formatting
  246. Error message
  247. ribbon into tool bard and drop down menus
  248. what is this?
  249. Automatic update links to monthly file
  250. Re: copy colour
  251. Help! I am having a problem with sort!
  252. Copying fill color
  253. Create a Class Schedule
  254. SUM
  255. Prevent user from copying contents of a worksheet
  256. Need Help with Complicated Array Macro
  257. Worksheet - Copy rows
  258. RE: copy colour
  259. Excel to Word for Newspaper
  260. SUMIF
  261. Excel 2007 not saving user-created range names
  262. Print Fit To Not Working
  263. reinstall
  264. RE: copy colour
  265. What is worng with this code?
  266. In MS 2007 Office, how do I set default color palette same as 93-2
  267. Conditional Formatting
  268. vlookup with the same values in one column
  269. Column/Cell Question
  270. Copy Charts from Excel to Word
  271. #NAME? error in formula in 03 but runs okay in excel 07
  272. Excel 2007 - Pivot Table Limitations?
  273. Create Secure Data (need employee ID & password to access)
  274. Re: Why does the color not show when I'm in print priveiw?
  275. text to speech-helpppppppp
  276. need help with timestamp macro
  277. RE: Why does the color not show when I'm in print priveiw?
  278. Report Numbers only
  279. Pivot table in excel 2007 – default the data to collapsed?
  280. Re: Why does the color not show when I'm in print priveiw?
  281. Populating Cells
  282. Auto Filter Does Not Work
  283. RE: Combine information from rows
  284. Text to large for Excel cell
  285. counting cells associated by year and date.
  286. Re: how can i lock columns but allow for new rows to be added?
  287. Identifying text within a cell
  288. 2003 - 2007
  289. CSV files - auto format
  290. Problem with format of cells?
  291. How to stop "Locked for Editing" in Excel?
  292. Help on VLOOKUP
  293. Min-Max question
  294. Worksheet never opens
  295. How to alternately variegate rows
  296. Help setting up a excel test for new employees
  297. adjust formula to much info
  298. Can I allow insertion of pictures into a protected excel sheet?
  299. Copy Concatenate
  300. Counting entries by date
  301. Copying formulas into protected cells.
  302. List Will Not Automatically Expand
  303. G0 to cell reference
  304. In Excel ,how can I opean the task window
  305. DATE FORMATS
  306. How to simplify CONCATENATE
  307. Addition Formula
  308. CTRL+F doesn't work
  309. changeing words conditional?? please help
  310. I am looking for formula to calculate escalation on construction
  311. Problem with creating pivottable
  312. tag / link a cell comment (date) to alert when due
  313. Formula Help
  314. Data Validation
  315. Drop down lists in cells.....I think!!!!
  316. Help on Macros
  317. Is there an easier way...
  318. Tick boxes in excel
  319. Insert rows and keep merged cells in the inserted row
  320. Pivot Table by Financial Year
  321. How to disallow a sheet or file from copying by other users
  322. How do I attach a jpeg file I've saved so I can open it
  323. Excel IF AND question
  324. drop down list
  325. to unlock password
  326. My printing woes!
  327. Filtering without filtering
  328. Excel Help
  329. Conditional formatting
  330. Linking duplicate file
  331. Pivot Table Field Number
  332. Print on large format paper
  333. Need a drop down list to auto fill other cells...
  334. Automatically populate formulas when a new row is inserted
  335. Default Formating Excel 2007
  336. How do I turn off gradient fill for data bars in condit. formattin
  337. Microsoft Office 2007 Bulk Conversion Help
  338. Outlook Calendar Reminders link with Excel, vise versa
  339. How to automatically update a 12 month budget
  340. how to display item numbers that may contain letters
  341. set operations: union, intersection, etc. and alignment
  342. Count of unique values in a list
  343. pivot table source data expand to new entries when refresh?
  344. Remove carriage returns in an Excel document?
  345. How to set text color based on value in cell compared to constant
  346. Help with Offset
  347. Interest payment
  348. Sort imported date column
  349. Rounding numbers
  350. How to create travel template w/drop down menus
  351. AutoCad/Excel
  352. sorting by date & exported to word for mail merge
  353. Summing Text
  354. A list of what is being filtered on?
  355. TEXT TO SPEECH
  356. Montly payment with interest paid and balance of loan
  357. Comparing text in cells for differences
  358. Paste unformatted text
  359. Conditional format row based on Percentile in one cell?
  360. Printing
  361. Multiple work sheet merge
  362. Remove bad addresses
  363. Formula Question
  364. Help Setting up a test sample for new employees
  365. Interest payment
  366. automatic equal sign that is NOT WANTED
  367. Excel constantly trying to "Recover Files"
  368. How large can a file get before it is too big for Excel to handle?
  369. cell problem
  370. Format as table problems..
  371. How do I copy conditional formatting only?
  372. Import data in excel cells
  373. Import Data in Designated Cells in Excel 2003
  374. splitting date and time information in cells
  375. conditional format?
  376. Excel and Outlook Test
  377. nested function help, please!
  378. COUNTIF Array
  379. Object Selection
  380. Subtoal
  381. excel 2007 Merge and Center button is unavailable
  382. printed page does not look like print preview
  383. Drop Down Lists
  384. CELL REFERENCES
  385. Why when opening a spreadsheet, do two copies appear to open?
  386. Excel Bar Code
  387. Exporting Crystal Reports
  388. Common footer but not common margins please -(Page 1 of 2) etc
  389. Default Book Formatting
  390. Excel locks up when I hit bold
  391. Number format in cell changes
  392. how to create a URL in an Excel?
  393. Macro using Combo box information
  394. Conditional Formatting with Today() Function.
  395. Finding and locking formula cells
  396. Help with different ranges and copyin
  397. display substitution?
  398. Copy string of characters
  399. Excel Enter Key Sequence?
  400. Duplicates Excel 2000
  401. Keeping source formatting from a referenced cell.
  402. Getting a positive percentage to have a + sign
  403. Help with cells contents sum
  404. Data Validation
  405. how to convert Excel tables/charts into EPS or PDF?
  406. How to change display format - double click for precedent cells?
  407. Replacement Vlookup Formula
  408. Locationg the first number in a row
  409. open all files in directory
  410. button bar
  411. Count numbers
  412. locking the cells
  413. Can not save the xls as xlt
  414. Loop till value changes
  415. Creating a list with entries from cells and manual entry too
  416. Lookup inquiry again
  417. Man Hour Savings
  418. Name of files in a folder
  419. validation formula's and conditional formatting
  420. Naming a cell from VB
  421. Macros to copy and paste data
  422. Date !
  423. How to error trap "... cannot find the data..." message?
  424. How to change back to English
  425. MS Query via ODBC cannot read Integer field from FoxPro...what's w
  426. Status Bar: SUM function doesn't work for numbers copied from web
  427. I hate the DIV/0! error! Can anyone help me make this go away?
  428. Password protecting multiple spreadsheets at once
  429. Naming a Formula, using Link to Cell containing that Formula
  430. Pivot Table Missing Filter Tab
  431. Event when a specific cell changes
  432. mail merge "dialog engine failure"
  433. what's the best way to convert a table in Excel to Powerpoint or WORDthen PDF?
  434. sumif or sumproduct with a left statement
  435. How to apply a % to rows
  436. Print multiple columns from single column data?
  437. Reference is not valid for Pivot tables
  438. Editing sources
  439. if formula
  440. how to insertnew worksheet page
  441. SumProduct Question
  442. 2007: How to show ribbon in XLS sheets opened with Internet Explor
  443. information filter
  444. Export and Save Only Certain Rows of Data
  445. Generic Pivot Chart Column
  446. how to count this in this unusual situation
  447. VLookup Formula
  448. Beyond IF Statement
  449. Deleting rows in two columns with a code in visual basic
  450. Five plus mintues to execute
  451. cascading menus
  452. How do I email one sheet out of and Excel 2007 Spreadsheet
  453. What if no one responds to my question
  454. retrieving unsaved files
  455. retrieving "unsaved" files that you accidentally closed?
  456. Pivot Table - with blank rows
  457. Cell changes format upon saving file
  458. Cut & Paste Need Special Macro
  459. Vlookup with Multiple Columns to Match
  460. Pivot Tables - Column Fields
  461. Filtering?
  462. Macro: Delete Row Above Last
  463. Pivot Table Help - Work Around Cell Limit?
  464. Why does Excel always ask if I want to save changes to Book1?
  465. Excel Filters
  466. renumbering rows
  467. Keyboard Shortcuts
  468. Problems using sort when data has links to other sheets
  469. Group cells during sort
  470. Delete all rows if criteria not matched
  471. Wrap Text: Print Version different than Screen Version
  472. Pivot Tables
  473. Adding columns
  474. Remove Email View on spreadsheet
  475. How to list items instead of counting them with Pivot Table
  476. Cannot get VBA to Change PageSetup.FitToPagesWide = 1
  477. Keeping last row last
  478. How do I use freeze pane and split in the same excel spreadsheet
  479. Copy from one sheet to another using VBA
  480. I want to create a calculated item based on a calculated field
  481. If(and statements using data in an array
  482. how can I find cell/s in excel sheet having blank spaces more tha.
  483. ARRAY Formula
  484. Code problem
  485. Display only duplicate values and delete UNIQUE Items
  486. how do i compute (8500 + (180000 - 130000)*0.01 using ms excel
  487. Validation Problem
  488. Freeze panes
  489. Excel 2007 - how do I display formula instead of values? thanks.
  490. How to delete rows in visual basic
  491. get the week start date
  492. Activating links
  493. Split a decimal figure
  494. Excel Spreadsheets
  495. Format row based on conditional format of "Top Ten" in another cel
  496. Missing Column "A" in an Excel Spreadsheet
  497. why would a excel file sent with data open as grey screen
  498. How to open a web page through macro?
  499. following a hyperlink
  500. Lost my Fonts
  501. checkbox = macro?
  502. Anyone know of program or Excel VBA to examine set of numbers for Sum match?
  503. How do I disable a SORT
  504. Excel 2003 won't open
  505. close email option
  506. Data Lookup and Plotting Help
  507. Conditional format row if one cell is in "top 10"
  508. Data filter and deleting rows in visual basic
  509. Excel crashes
  510. Auto Filter - how to collapse "non-blank" cells in a column?
  511. Macro Security Excel 2002 vs. 2007?
  512. Limiting raw score entries and possible pop up message alert?
  513. Help needed with cell reference
  514. Preparing Data for Pivot Table
  515. Insertion of a cell address that constantly rises by a set number
  516. How to determine the values?
  517. number input error
  518. Sheet slow moving from cell to cell
  519. Worksheet form vs. Userform...which is better?
  520. Excel autosave replacement - Autobackup
  521. Counting texts
  522. Freeze pane command on 2007 not highlighted
  523. Unable to insert table
  524. Formula Correction
  525. copy last populated cell (moving) to another cell
  526. reverse cursor/text direction within cell
  527. count characters
  528. Moving highlight
  529. How to multiply column and rows
  530. follow hyperlink syntax
  531. Presentation quality Excel tables?
  532. Better Graph Add-ins/Plug-ins
  533. A formula answer that I just can't wrap my brain around!
  534. IME MODE FOR EXCEL 2007 (URGENT URGENT)
  535. How can you unprotect your file of Exel ?
  536. category axis - date
  537. Hide values in a Drop Down list
  538. How can I remove 5 digit from a string ?
  539. Vlookup to other workbook and Track Changes problems
  540. Print preview or document in color
  541. Options changed when open new window
  542. A bit of a complicated Array that I can't figure out! HELP!
  543. how do I compare versions of an Excel worksheet
  544. Sorting Data
  545. Converting excel list for email
  546. Excel 2007 to Excel 2003 bug?
  547. COUNTIF
  548. macro wich saves files
  549. file conversion encoding error
  550. Drop down
  551. antomatic capiture data from other worksheet input
  552. Excel version in Cell
  553. Save Window-Shortcut Pane-Where is it?
  554. Counting # of characters before a certain character
  555. AUTOFILTER IN A PROTECTED WORKSHEET
  556. Org Charts
  557. How do I permanantly install an "add-in"?
  558. Is there a way to default the number times a document prints?
  559. My Advance Filter Doesn't Filter
  560. Can't add worksheets to a workbook.
  561. Stop carrying over text styles when pasting
  562. how do I add a comment by the gray area (outline boxes)?
  563. Hidden Columns & Rows in a Shared Wookbook
  564. Macro: Insert Row above Totals
  565. Rows & Columns Fixed Width / Height
  566. COUNTIF - Condition
  567. How to send specific cells on a worksheet in office 2007?
  568. Format Cell
  569. Bar graph and stacked bar graph on same graph
  570. Negative Number Display -- need Brackets
  571. Calculate elapsed time Excel 2003
  572. Looking for excel templates
  573. vlookup & multiple values for one customer
  574. Displaying column and row names
  575. Extracting Data
  576. I want to use speling check but is in gray. How do I change it
  577. custom pop up message
  578. Advanced Filter Grayed Out???
  579. linked cell to change another cell
  580. CONCATENATE & VLOOKUP
  581. lookup values on two worksheets
  582. duplicate records
  583. Storing multiple ranges using a macro
  584. SUMIF or IF to display number of days or N/A
  585. Add in Flowchart symbols
  586. Excel shortcut keys
  587. Automatically Extend Formula in Count function with Additional Row
  588. How to increment a cell by 1 on mouse click or move to another cel
  589. if formulas
  590. External links
  591. Unable to self sign a macro
  592. Question about HEaders & Footers
  593. How to get the value from string?
  594. send e-mails
  595. Move logo from word document to excel header
  596. if formulas
  597. How to get number of all rows in every datasheet together?
  598. Dynamic Range including some blank rows
  599. changing times into shifts
  600. Use of OFFSET and LOOKUP to find a value in a table
  601. Cannot see cell shading on the screen, only in print preview
  602. microsoft excel
  603. delete recent documents history in word and excel 2007
  604. Formatting a value in a concatenated cell
  605. Date to text conversion
  606. how to deal with "~"
  607. Pictures on Buttons missing
  608. Pivot Table - Hiding Zero Values
  609. Combining values out of different columns
  610. How to cross-multiply text data in excel??
  611. How to ignore blank date cells in sumproduct
  612. Autofilter Slowness
  613. How do I correct Query error "Invalid bracketing of name 'xls.'."
  614. Extracting Data
  615. Percentage Breakdown Formula Help?
  616. Transposing in formula
  617. Multiple conditional formats met
  618. Calculating Total Return
  619. Excel 2007 pivot table label filter
  620. Blanks or zeros in formulas
  621. SMART TAGS
  622. How to enter text in two line in a excel cell
  623. Removing Tax Component
  624. file cannot be opened directly
  625. how to add another column to completed spreadsheet?
  626. Macro to copy information from a row to another sheet in the workb
  627. Mail merge filters
  628. Excel 2007 certification preparation exams
  629. Moving data without keeping formula
  630. How do I find the original price?
  631. Matching data/columns from two seperate files
  632. XLA File
  633. Find and Replace Troubleshoot
  634. Sentence Case
  635. Docking a Toolbar and having it stay
  636. PDF Maker Toolbar Buttons
  637. Formula too long problem
  638. VLOOKUP IN WORD
  639. Cell protection issues
  640. using a list to return a value from another column
  641. Can't seem to get my Array formula to work................
  642. Text changing colour when bolded?
  643. Validation Table - Entering Value not in a table
  644. Search for string of characters in a cell
  645. Numbers
  646. Autofill & On Error Resume Next
  647. Spilting a column
  648. Autofilter
  649. How do I display empty columns in a Pivot Table?
  650. import question
  651. Linking Documents
  652. negative dates
  653. excel
  654. cursor
  655. SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria
  656. Concatenate with date range
  657. Based on the selction from a drop down box, jump to a cell
  658. Round a number help
  659. RE: How to make text to change its color accord. to selection from
  660. Add "+" plus symbol to positive percentage
  661. IF > then return...
  662. Help with Variable Ranges!
  663. To execute a formula upto in a cell
  664. previous download doesn't work
  665. Help with dates!! Excel 2003
  666. Automatically go to another cell
  667. SCROLL BAR ISSUE
  668. MCAS EXAM
  669. Vba - Picture Object naming
  670. How to create a new page with a button?
  671. Banner ad Manager
  672. Showing Last Value in a column
  673. Pivot Tables - and entering data corresponding to that row
  674. if condition formulas
  675. salary tax calculation f
  676. Excel 2003, European number format
  677. Lottery
  678. Re: how to insert same row numbers in several function statement
  679. Re: protecting the cells
  680. Re: Removing hh:mm:ss from date
  681. Re: Short cut key for 'address' line
  682. RE: Short cut key for 'address' line
  683. how to combine two column with a curly brace
  684. Transpose Data
  685. Workbook Links - Many to Many
  686. How can a drop down list be linked to values on another sheet?
  687. RE: Help with formatting
  688. using auto filter, how to tell what columns are filtered?
  689. Date Count !
  690. How can i print one long column side by side?
  691. Too many messages reported
  692. excel 2007 problem
  693. Splitting a column
  694. Comparing two list of data
  695. Vlookup
  696. zoom to fit to screen
  697. URGENT HELP NEEDED
  698. Lesser than cell
  699. Printing in Portrait & Landscape
  700. Polynomial Curve Fit
  701. how to intrupt Save and Save as?
  702. Using IF statements with a drop-down list
  703. can I export an excel file to the body of an email
  704. Need HELP!
  705. Converting data from every second to a new column
  706. Sort during protection
  707. sorting worksheets containing both imported data and user entered
  708. copying conditional formula
  709. How do I remove a dropdown box in Excel 2007?
  710. Possibly an Array, but I'm not sure?
  711. Can I use Avery Labels with Excel?
  712. formula for previous month
  713. How can I delete a space in the beginning of a cell...
  714. hyperlinks in pivot table
  715. how can I create a pop-up message whenever a workbook is opened?
  716. How do I save Excel to HTML without using frames?
  717. Formula for Recalculated Employment Dates
  718. How to get a copy of the first row Text value displayed in a filte
  719. Automatically copy previous cells in data entry in Excel
  720. Headers in Excel
  721. IF Then using a column of text and assigning a number to text
  722. Formating problems
  723. Link and transpose?
  724. How to pick out unique components in a list with unique and common
  725. Conditional formating
  726. I want average to change as per the filter is added in the sheet
  727. Saving previous sorts in 2007
  728. Text Wrap Toolbar Icon
  729. I need a macro for inserting a border line every 20 rows
  730. Networkdays
  731. SUM Formula
  732. Smart Tags
  733. Excel Keyboard Use for Drop Downs
  734. automatic links
  735. how do I use the arrow keys to move the cell pointer? I have excel
  736. COMPARE Add-in
  737. Excel hyperlink
  738. Excel 2007 cannot close
  739. how to display MDX Query that is fired from excel 2003
  740. Worksheet protected-auto filter works, show all button dosen't.
  741. Sorting by numerical value so that subjects follow
  742. Protection Issue
  743. Conversion of Numbers into Text
  744. Help creating a Chart
  745. How do I move deleted items to another spreadsheet?
  746. how do I remove read only to allow write
  747. how do I add a page number as a background for the worksheet?
  748. Delete Page
  749. Row numbers have been re-sized
  750. Copy Cell atributes to another
  751. Data Validation via Dependent List defined by Dynamic Range
  752. Sum based on two selections - months
  753. Why is hyperlink function inactive sometimes?
  754. Why can't i insert a new worksheet?
  755. find outliers
  756. Challenging question: add TIME TREND in Excel with built-in functi
  757. Time conversion
  758. Unique records in pivot table - formula?
  759. Updating Links
  760. Import Data refresh problem
  761. Color Change Text by type of Entry
  762. ROUND UP or DOWN by 0.5
  763. How to delete rows in visual basic
  764. Disabling Cut and Copy
  765. use checkbox to hide rows
  766. Formulas in drop down lists
  767. Conditional Format
  768. can I insert/embed a word document in a single excel cell?
  769. calculating progressive tax
  770. Protection & Locked issue
  771. Worksheet poser...
  772. to extract numeric figures in left side od the alpha charectors pl
  773. Range error
  774. Hyperlink Question
  775. I'd like to conditionally format a cell based on today's date
  776. amend formula
  777. Names in Drop Down List
  778. How do i remove duplicate records in Excel 2007
  779. COPYING SUM/IF FORMULA
  780. "IF" function question
  781. Date changes when copied and pasted
  782. summing, grouping percentages in pivot table.
  783. how many blank cells it spans
  784. Shapes and Arrows Moving
  785. Protect Excel Format Only
  786. linked files
  787. Changing Length of Cell Contents
  788. how to open a workbook per active window
  789. #DIV/0!
  790. Sumif Formula - Won't Recognize Dates
  791. Find maximum row count of data
  792. Index/Match (maybe?)
  793. Formulas
  794. Solver - error - Compile Error
  795. .XLB files and network
  796. Re: Cursor
  797. userform for updating records
  798. how do I find 2nd highest MAX in a row
  799. Used drawing colors in shapes....lost default colors for "Fill Col
  800. Conditional Formatting various colums at once
  801. My cursor is selecting 3 cells at a time - how do I fix this?
  802. Excel and the Olympic Games
  803. Excel 03' -- Printing to exclude autoshapes?
  804. formula
  805. Creating a Calendar
  806. Average rating by name.
  807. changing vbOKCancel button title
  808. Conditional Formating
  809. Font Size
  810. Macro to Format Lines Between Rows
  811. Formula to read formula in a cell
  812. Merging WorkBooks Not Working
  813. practice training
  814. Format date and time from one contiguous field
  815. Use of Radio Buttons
  816. Calendarize?
  817. formulas not working after copy
  818. How do I add a scroll bar from tool box into an Excel document
  819. How to get days of week by entering dates?
  820. automatic links
  821. MACRO HELP WITH SUBTOTAL AND RANGES
  822. Auto Filter not working?
  823. Comments not editable
  824. Deleting Duplicate records
  825. Automatically changing my numerical entry- when I don't want it to
  826. Subtotals
  827. how can I turn on the mouse scroll wheel in office07?
  828. Dates - gaps between
  829. Como importar para Outlook, e-mail contidos em ficheiro Excel?
  830. rounding off with links
  831. Insert Row - Copy Formula From The Row Above
  832. assign #N/A to blank?
  833. Hide/Unhide vs Group/Ungroup - Need Help
  834. Lost toolbar
  835. Drop Down Sorting
  836. Array Formula
  837. How do I fix invisible text in the formula bar?
  838. Does VBA code add to a files size?
  839. SumProduct Help
  840. INDENTIFY COLUMN
  841. Excel 2002: How to compute average, min and max figures?
  842. Value a workbook
  843. why are my excel docs being converted when I email them?
  844. Formula
  845. Header Linked to Cells
  846. Is it possible to print a row of data on more than one line?
  847. A faster way to auto-fill (XML, maybe?)
  848. Excel Formating
  849. Excel 2002: Max, Min and Average formulas
  850. changing formulas to their result values
  851. Selecting a list issue
  852. Count and Match 2 two columns with Lists from other sheets
  853. Re: Find series
  854. Help with a formula
  855. how to write â‘*
  856. If prompt for user data
  857. how can we set page margins for the entire workbook?
  858. working with %
  859. Print Preview Problem in Excel
  860. Importing fianacial data
  861. Excel 2003 unites csv file row contents in a column A with squares
  862. dates
  863. pivot table
  864. fixed cell lenght
  865. Duplicate items
  866. Too many page breaks
  867. code for auto numbering documents
  868. List data
  869. Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook
  870. Does Microsoft disseminate their market penetration to the market?
  871. Can Excel be linked to MS Acess?
  872. Text to Columns - Excel 97
  873. IF formula only showing positive results
  874. Multiple Lines of Text in One Cell
  875. =IF(AND... function
  876. DATABASE COUNT
  877. =SUM(E4:I4) WILL NOT ADD THE LINE
  878. Flag Help
  879. formula auditing toolbar items disabled
  880. Two COUNTIFs
  881. using a formula to copy a row
  882. Help with a Date formula please?
  883. Formula Help
  884. Unable to use mouse wheel to scroll in Excel 2007?
  885. Copying IF formulas
  886. How do I add numbers from separate worksheets
  887. Automatic Row and column sizing
  888. SUMIF Based On Cell Color
  889. Dropdown menu
  890. Why do I get #### signs when entering cash amount in account mode
  891. Too many levels in the IF function?
  892. Add worksheet at end or last position
  893. Conditional Formatting Duplicates
  894. Need formula
  895. Drawing Tools Arrows
  896. Can someone help?
  897. Excel 2007 - Convert text to numbers
  898. Cell references are acting absolute
  899. length principle of a number within a cell
  900. Pivot Table Subtotals - Calculated field subtotal incorrect
  901. How do I change the outline color of the excel cursor ...
  902. Scrolling with down arrow
  903. Excel Duplicates
  904. Pivot Table Grand Total Plus Calc Field or GT Running Balance
  905. Open by
  906. e-mail/copy 1 shhet
  907. Pivot Table format
  908. Excel 2007 - convert text to numbers
  909. Create txt file with data manipulation and reorganization (macro)
  910. Trust Publisher in Excel 2007
  911. Font Case in Excel-HELP!!!!
  912. read xls spreadsheet attached to e-mail
  913. Defining a Range with Criteria
  914. Data Validation Question
  915. Currency & hours
  916. Pasting options
  917. Referencing External Data
  918. 'blocked by registry policy settings'
  919. Counting by colour
  920. Sudden Change in Copy & Paste Format
  921. Help finding a fast way to cross reference data between sheets???
  922. Office Button Missing - Cannot Save
  923. Formula Question for Excel 2007
  924. User replaces existing file with blank during file open
  925. Unusual Printing Problems
  926. Monthly Reporting
  927. Tie cell together
  928. Conditional Formatting
  929. custom formats
  930. drop down menu autocomplete
  931. Can't Trace a Code/Instructions ....
  932. How do i set up a repeating formula for data in excel?
  933. How do I hyperlink the PDF file in excel sheet
  934. display zero values at the beginning of a number.
  935. how do i alphabetize labels in a word document
  936. how can I return the value of the first not null cell in a column
  937. calculate time does not calculate
  938. General reference source
  939. How to convert a picture of a table into the the original table
  940. look up word
  941. Formula for Changing low number of "-"
  942. change the default Look in entry when inserting a hyperlink excel
  943. IF & AND formulae
  944. Re: Help with a formula please?
  945. Adding date to survey form
  946. looking up data/numbers in table
  947. How do I format a cell value to show kg?
  948. Niggly issues with Excel 2003
  949. How do I conceal the unused range from the scroll bar?
  950. Transferring Data from one sheet to another
  951. Show day or empty cell
  952. Maintaining Cell Format in Query
  953. Hyperlink won't work
  954. Workbook format lost after saving.
  955. using CELL function
  956. columns show right to left
  957. WordArt Fill Effects
  958. Checkbook Spreadsheet for Excel
  959. how to link the templates in the spreadsheet
  960. How can I reference a cell on a previous worksheet
  961. Comparing cells
  962. Excel Hyperlinks
  963. Adding
  964. Computer name
  965. Deleting spaces
  966. Countif and
  967. how do I keep hyperlinks when emailling a file?
  968. HELP HELP
  969. Problem after reinstalling Office 2007 with XP SP3
  970. HELP
  971. What is the name of the cause-effect analysis?
  972. excell 2003 -how to use a scroll bar to adjust the range of a func
  973. Sumproduct
  974. Protect a sheet but allow columns to unhide
  975. Re: Opening a password-protected spreadsheet from a website link
  976. date format
  977. LOOKUP ARRY
  978. Copying and Pasting Question?
  979. Keyboard shortcut
  980. Conditional Formatting Question
  981. change Excel Cell forecolor using VB6
  982. Remove leading blank(s)
  983. Formulas for transfer
  984. Duplicate Running Total Grand Total In Pivot Table
  985. How do I remove a sort in Excell 2003
  986. PRINTING IN FILTERED AREA
  987. Excel formatting
  988. Formula or script needed
  989. Formula needed
  990. Excel 2007 SP1 TROUBLE
  991. disable Compatibility Mode in Vista for Excell
  992. date format help needed please
  993. Find/Replace Problem
  994. How do I print Excel file properties information?
  995. Lookup Data Across Multiple Worksheets
  996. Choose the cells where there is a value
  997. Pivot Tabe Duplicate Grand Total
  998. Re: Non-Contiguous Named Range?
  999. fare is a Travel search site.
  1000. what are the thick black lines called that outlines a cell?