PDA

View Full Version : Excel Discussion (Misc queries)


Pages : 1 |  2 |  3 |  4 |  [5] 6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 |  90 |  91 |  92 |  93 |  94 |  95 |  96 |  97 |  98 |  99 |  100 |  101 |  102 |  103 |  104 |  105 |  106 |  107 |  108 |  109 |  110 |  111 |  112 |  113 |  114 |  115 |  116 |  117 |  118 |  119 |  120 |  121 |  122 |  123 |  124 |  125 |  126 |  127 |  128 |  129 |  130 |  131 |  132 |  133 |  134 |  135 |  136 |  137 |  138 |  139 |  140 |  141 |  142 |  143 |  144 |  145 |  146 |  147 | 

  1. How do I cancel/delete read only for a worksheet?
  2. Needed Macro and Function Help
  3. RE: Lookup formula
  4. Removing spaces from middle of cell
  5. Protecting an excell workbook
  6. Lookup Formula
  7. Recover lost excel tabs/spreadsheets from workbook
  8. Viewing text 2003 vs. 2007
  9. RE: When I search this group w/my user name nothing from 2010 comes up
  10. Excel 2003 - Skip a cell
  11. Find/Replace Numbers stored as Text drops zeros
  12. How do you automatically display a vba form in excel 2007
  13. no more new fonts may be applied in this workbook when changing fo
  14. Subtotals in Excel
  15. Log of users who open the workbook
  16. Arrow Keys
  17. defaulting to Euros
  18. Can I move a button from toolbar to a worksheet?
  19. lookup row number
  20. entering current time in shared work book - 2003
  21. Re: When I search this group w/my user name nothing from 2010 comesup
  22. Re: When I search this group w/my user name nothing from 2010 comes up
  23. Re: Match formula to match values in multiple columns
  24. Concatenate lists
  25. Lookup formula
  26. Conditional Format
  27. using Sumproduct with named ranges
  28. Reduction in Growth
  29. Simple Yes/No drop down box
  30. Conditional formatting of date-cell - 2007
  31. bahttext
  32. Can an If statement return a formula for false?
  33. alternate row shading kept with autofilter
  34. How do I insert a file into Excel 2007 spreadsheet ?
  35. Unusual Date Format
  36. Unusual Date Format
  37. Segregating Duplicate Transactions
  38. Seperate data
  39. COUNTIF formula Using 2 or more cells
  40. Problem with subsets for multiple Report Filters in 2007 PivotTabl
  41. Combo Box
  42. Calculating Sum Series
  43. Formula to find the last number of a column (lower cell)
  44. Mandatory/Compulsory
  45. Vlookup Question
  46. How do I add extra data to a pivot table?
  47. find and copy it..
  48. Excel Spreadsheets formulas don't update
  49. Excel Spreadsheets formulas don't update
  50. Search and Replace, or Add New Row
  51. How to use the "shell" command?
  52. How do i extract worksheet cells with the same contents?
  53. repeating number in a data
  54. Shading on highlighted range of cells
  55. Help with setting a "nof found" statement
  56. Help with setting a "not found" statement
  57. Average If, with a Moving Target
  58. stike through font
  59. horizont line above/whereupon font X or V
  60. SUMIF, use List as a Range
  61. Macro problems
  62. Adding digits in a column based on data in a separate column
  63. Populate List Based on Cell Value - XL2003
  64. Pie of Pie
  65. Urgent!! compare 2 columns of numbers for duplicates
  66. Network days
  67. Calculating a Series
  68. Transferring files from a MAC
  69. letterhead in excel
  70. Macro to hide rows with zero in specifc column range
  71. making a correction in a row of excel?
  72. median standard deviation
  73. Cell colour in relation to IF results
  74. worksheet change question
  75. PROTECTING CELLS
  76. Excel - Run Macro on Cell Change
  77. Left Function
  78. Excell 2007 will not open XLSX
  79. Insert Object Problem
  80. Excel 2003 Pivot Formatting
  81. Sorting PivotChart
  82. Sorting Pivotchart
  83. Row Height variations from computer to computer on same workbook
  84. Pasting a value as an hyperlink
  85. Where can I find a Outside Sales Daily Call Report Template?
  86. Need Help
  87. Visible Shapes in a frame?
  88. Excel - decimals
  89. Sorting several columns
  90. Conditional Formatting Help
  91. Keep macros from being ran under the tools option in the menu bar
  92. Date format
  93. Format Date Filter Problem
  94. Count but ignore duplicate data
  95. [Flashing] RED before renewal date
  96. Copying Formula - Please help
  97. Macro Code
  98. league table sort
  99. Macro error
  100. how do I unshare an excel file?
  101. Checking for merged cells
  102. Excel slow!
  103. Change ComboBox arrow colour????
  104. #Name problem
  105. Invoice created from Excel ocr Access and sent via Outlook
  106. data splitting
  107. Formatting toolbar is not displayed
  108. excel 2007
  109. Printing spreadsheet and diagram
  110. How to calcuate 6 variable's contribution towards a fixed sum???
  111. find a name
  112. QAT does not allow enough room for customization - please help
  113. Paste to size
  114. how to Sum last 10 values of a dynamic column excluding zero
  115. Look up value range in column and then count
  116. Excel wrapped rows, want automatically leave some space bottom of
  117. hiding zero for a sum
  118. calculation help
  119. Excel password mechanism failure
  120. Cut and paste specific data
  121. autofilter
  122. How do I create a feedback form?
  123. Protection
  124. need a formula to find "*" in s string and multiply by preceding andfollowing values
  125. Pivot Table Wizard in 2007
  126. Number format changes to date by itself
  127. Excel 2007: @*. formatting
  128. TimeStamp
  129. Automatic Pareto data with Formula
  130. Column link
  131. Date Format not working
  132. how dod I NOT select multiple cells at the same time
  133. copy date in a cell if within a date range
  134. I want to search "if cell a1 start with .. "
  135. how can I add an * to be the last character in a cell
  136. Microsoft Excel
  137. Pivot Table Count Issue
  138. Repeat formula
  139. cell selection troubleshooting
  140. Disable macro selections under tools menu
  141. conditional formatting = or > cell reference + 2
  142. Data table with inputs from a differente worksheet
  143. Adding some list items
  144. excel 2007 autofilter change to 2003 autofilter functionality?
  145. Blackberry and Excel
  146. script or format to identify duplicate data
  147. how can I create a dummy variable in Excel?
  148. Creating a value from a variable result
  149. Displaying entire row
  150. 2007 Find_Replace - default on workbook?
  151. 2007 excel autofilter change back to 2003?
  152. 2007 excel autofilter change back to 2003 autofilter?
  153. replace a negative result with a zero?
  154. 2007 excel autofilter back to 2003 autofilter?
  155. Using Conditional Formatting to Pass/Fail
  156. Excel cell value equals selected text from Word
  157. New To Pivot Tables
  158. why are my column headers numbers instead of letters?
  159. Excel formula
  160. Copying data from one workbook to another dependent on user select
  161. Script to insert Row
  162. Editing options disapear when document is changed to compatibility
  163. upgrade macros to 07
  164. "Blank" cells showing unwanted data
  165. can quadratic equations be solved in excel
  166. How to retrieve the value within string?
  167. Conditioinal Formating Question
  168. Flashing RED before renewal date
  169. IFBLANK
  170. Excel custom format q
  171. Key Board shortcut to Status bar
  172. How to undo overwrites?
  173. How to use Windows command within Excel macros
  174. Top row of excel stays even in sorting
  175. Rating
  176. Excel, custom format
  177. How to arrange data
  178. Add and edit a shape in VBA
  179. Countif Formula
  180. Default font/Size in Comments Box
  181. what is the best book to learn macros indepth
  182. 1-52 pages, 8,000 employee numbers
  183. Advanced Formula troubles
  184. How to choose maximum value
  185. chart Templates in Excel
  186. copy a pivot table to another sheet in a macro
  187. Pivot Table Groupings Fail if 1of the items isn't in the next data
  188. How do I set home to A1 instead of K1?
  189. Problem printing from Excel
  190. how can i make a line inserted in excel be straight
  191. Excel (2002) slow after deleting some macros
  192. How do I use standard notepad (unicode) font for special character
  193. VBA selecting an input range of cells
  194. Count
  195. Vlookup with sums
  196. How to count the number of cells not empty?
  197. sum function
  198. Excel Shared Over Internet
  199. Pasting in Excel has started taking a long time.
  200. Excel Formatted Spreadsheet To SQL ?
  201. Formating a decimal number
  202. How to sort names in alphabetical ascending order?
  203. How to retrieve the yahoo symbols into excel?
  204. tabs identifying columns and rows
  205. Sorting by Content
  206. send color filled shape behind text
  207. Why do I get two different paste special screens?
  208. How to change default date formula on Excel worksheet
  209. copy if
  210. how do I delete documents from the start list in word and excel?
  211. How do I calculate the percentage of email i receive over time
  212. Recent documents don't display
  213. Hide Formula & Allow Copy
  214. How to pull only dates within a requested dynamic range
  215. Hide Formula
  216. Excel 2007 text flash (or blink)
  217. set cell to empty
  218. Print Parameters
  219. Summary of Difference between dates in years, months, days
  220. How to print (not) grid lines?
  221. Setting up Invoices
  222. Help With Macro
  223. Pulling Multiple Text Strings in a One Cell
  224. Excel 2007 Saving Issue
  225. A Guide to succeed
  226. If B2=x, then for all values of A2, place y in C3
  227. updating Data links
  228. hide items with no data in pivot table
  229. Fixed length string of text
  230. Workbooks that are not directly linked updating?
  231. How to change the character set in Excel 2007
  232. calculations help
  233. Sharing workbook error message
  234. Sharing workbook error message
  235. Pivot Table Data
  236. Search for my questions in 2010
  237. Automatically shift chart data range
  238. Make code apply to more than 1 column
  239. Export data from the same cell from multiple spreadsheets into a n
  240. printing multiple worksheets in a workbook
  241. Data visible in formula bar, but not in cells
  242. Is Otto still around?
  243. Moving Shapes
  244. Adding multiple items in unordered data to match a target amount
  245. Excel 2007: Slow copy/paste
  246. summing based on text conditions
  247. kopirovanie bez zvysovania hodnoty
  248. Find MAX of column from using 2 criterias
  249. Switching between sheets in same workbook (Like Alt + Tab & Choose
  250. segreating duplicate Trasactions
  251. How to count the number of text?
  252. office program freezes for about 1 min when doing a save as
  253. Issue with pivot table
  254. Insert outlook mails as attachemnt without inserting as object
  255. How to disable the pop up for enable auto update?
  256. EXCEL
  257. What are the different methods of representing numerical data?
  258. How to gernerate invoice numbers in EXCEL?
  259. Sort blocks of data
  260. How do I compare the stored data in micro
  261. Excel 2007 missing data using auto filter
  262. Calculation help
  263. Excel - Expense tracking-multiple users
  264. Formula adding 2 days...
  265. Formula Help...
  266. SumProduct counting negative numbers
  267. FV annuity re: compounding
  268. How do I move contact info from excell to Outlook?
  269. Copy and Paste Macro
  270. How to delete digital signature certificate?
  271. Calculation Problem
  272. Trying to delete blank rows after file save
  273. How to take information from one work sheet to another?
  274. formato rtf excel
  275. Suggestion on format of workbook
  276. stumped on creating dependent data validation lists
  277. How to find a text in a string without giving the position of the
  278. TIMESTAMP FORMULA
  279. formatting for mail merge
  280. Can you format numbers in Excel 2007 status bar?
  281. How do I see PDF comments in Excel insert object
  282. Printing a two spreadsheets front and back
  283. Printing selected pafes in Excel 2007
  284. Help with a macro
  285. trouble with shared workbook
  286. Printing Excel
  287. Displaying report filters on Excel Pivot Tables
  288. Converting a letter to a numeric value
  289. Conditional Formatting from 2007 to 2003
  290. Time entry help
  291. how to delete an excel worksheet?
  292. Formula help
  293. Problems with 'Names'
  294. runtime error 429 when trying to create Inet object
  295. Print and shrink automatically so that worksheet fits on paper?
  296. Adding "moving" ranges
  297. onenote
  298. Sending Excel Files from within Excel
  299. VLOOKUP function part 2...
  300. Unpivoting a worksheet
  301. Payroll
  302. Counting entries which match specified criterial
  303. Excel query to access database
  304. How do I add amounts referencing specific dates?
  305. Change Default Auto-Fill-In month
  306. Filter with criteria!
  307. Macros to Button
  308. Excel 2007, can't edit 2003 document
  309. hide columns before printing
  310. vlookup based on IP range
  311. conditional format
  312. Predefined text list
  313. NOW() help
  314. Used to return a worke sheet to origanan values
  315. excel will not print in color 2007
  316. VLOOKUP just returns formula
  317. Look up a reference which has more than 1 exact match
  318. pop up calender
  319. Cell fill color changes by itself
  320. Is there a way to auto save at an interval? Not just AutoRecover.
  321. Cell names of merged cells
  322. Entering and displaying time
  323. How do i do an eblast from an excel spreadsheet, that has email's
  324. WORKDAY function available?
  325. Allow selection of Validation List in a Protected Cell
  326. converting date to text
  327. XIRR range question
  328. how do I change format to percentage without multiplying by 100
  329. Using an If statement
  330. Need help formatting rows
  331. Sumif using Values, but returning text or values
  332. Can I combine two of or more files of the same type and layout
  333. Protecting sheets with drop down boxes
  334. Excel calcutions using date/timestamps
  335. Disable Options in 2003
  336. Spreadsheet with query statistics
  337. What is wrong with this formula? Please help!
  338. Out of Stack Space ... Recorded Macros
  339. Time formulae - delay updating when the sheet is refreshed
  340. Duplicate data
  341. One pivot table for multiple worksheets/tabs
  342. Not working: Conditional Formatting
  343. Hypeerlinks in worksheet changed locations from server to workstat
  344. Updating of a locked cell
  345. Vlookup function...
  346. Why does picking an cell highlight two cells?
  347. Prevent Manual Calculation Mode
  348. formula needed
  349. Merged Cells
  350. Cell Border Symbols
  351. Forms / Templates - automatic sending
  352. Need help with below question
  353. Coping part of a cell content into a seperate cell
  354. Transpose Multiple Rows to one
  355. directing the sum of a cell to either of two cells depending on va
  356. Include a value from one cell within text of another cell.
  357. Concatenation and Formatting
  358. turning text into a calculated result:
  359. From Access to Excel
  360. directing a total to various cells dependent of its value
  361. Selecting only specific rows for a Sort - additional bit of info..
  362. Footer date format
  363. Selecting only specific rows for a Sort
  364. Conditional Formatting: Fill Cell if Formula Overwritten
  365. Formula for transposing Row Values to Col Values
  366. / keyboard key doesn't work in Excel 2007
  367. troubleshoot shared workbook
  368. Increment value in a Formula
  369. Macro to show only rows with X
  370. In Excel how do I find unformatted shapes that are invisible?
  371. Password Protecting a workbook
  372. Pivot Table Consolidating multiple ranges
  373. Pivot Field List
  374. Cell Format
  375. Splitting Equals
  376. Excel. How do I remove 1,000 mailed addresses from list of 2,265?
  377. How to change default font color in Excel 2007?
  378. How do you apply a print area to an entire workbook
  379. Worksheet - various appearances
  380. Is it possible...
  381. name tags
  382. Need help for getting output
  383. Keeping Workbook Name Out of Sheet When Copying to Different Book
  384. Hyperlink mapping
  385. Excel Sudoku
  386. Cell Styles on Ribbon
  387. Use module globally
  388. caculate the total for specific date
  389. How do I Fill down on Excel
  390. Help with InputBox and MsgBox
  391. How to use Excel as a CRM tool
  392. How can this Micro customized. Please help
  393. How do I merge 2 worksheets into one consolidated worksheet?
  394. Formula to return a formula
  395. How to stop Excel from automatically truncating leading zeros
  396. Conditional linking
  397. Custom Number Formats for Excel 2007
  398. Can a Excel Spreadsheet automaticly open only once a week?
  399. year formula
  400. sumif function
  401. No left click
  402. Print 3 charts on one page
  403. Quarterly Formula
  404. xl 2007 how to validate that cell 1 invalid if cell 2 not blank
  405. Moving Hyperlinks
  406. how can we calculate the numbers of hours between two dates and
  407. How do I strike through a row of datas?
  408. Create a log sheet
  409. How to do - B2 is only valid if B1 is zero
  410. Reverse / Mirror Image of Text
  411. page breaks won't reset, 1 page is now 4
  412. From share drive particular excel file takes long time to open
  413. Sumproduct Question
  414. How to set a few columns on a worksheet which can be edited by ot
  415. To much space in my cell?
  416. Macro Help Needed
  417. Averaging unique values
  418. IF
  419. Average using Sumproduct or ....
  420. Using Sumproduct - Excel 2003
  421. Formula Simplifications Using Nested If, Indirect & Address Functi
  422. Conditional Format a range based on 1 cell
  423. Match or Vlookup
  424. Count function not working in one workbook
  425. Shared Excel Workbooks Show different layouts between users
  426. Insert Rows
  427. Total
  428. Change Track Changes Colour
  429. Offset/Index/Match ... or something?
  430. Can I protect data in a cell, but allow comments to be entered.
  431. Excel Questions: using match
  432. total
  433. total
  434. total
  435. total
  436. Security and macros
  437. Calculating a week between a range of dates
  438. Excel 2003 to Excel 2007 graphs
  439. How to Insert Excel file into webpage
  440. Protecting Formulas in Tables
  441. not summing all the cells
  442. How do I get totals from several different worksheets on to one?
  443. To display repetitive text, one time, auomatically
  444. copying causes lock up
  445. Search and then format by color
  446. Changing Color Pallet in Excel 2007
  447. Does a HasDependents = True property exist?
  448. auto fill or if function
  449. Get Data from Quickbooks
  450. Question on the formula
  451. Excel error: "The path you entered, ---------- , is too long. "
  452. copy cells but lock editing
  453. How can I insert rows BELOW, in Excel
  454. Simplification of Formula
  455. Sumproduct...Average
  456. How do I select a range of cells in an Excel table using the mouse
  457. Cell Formula
  458. Pulling data from other spreadsheets
  459. Command botton
  460. Excel wants to create a page break in every cell!
  461. showing 2 numbers in a cell
  462. work out how many trucks came in between the hours of 9am and 3pm
  463. Can I put hyperlink to an email in a cell?
  464. Data Validation
  465. Multiple Pivot Tables based on the same data
  466. Excel Cell Compares
  467. Please help to get cross reference with another sheet
  468. Convert FUMIFS to a format useable in Excel 2003
  469. Show Pivot Table Dates in a Month/Year Linear Fashion
  470. AVERAGEIF FORMULA EXCEL 2007
  471. Data Validation
  472. Are there any Excel macros for a simple countdown timer?
  473. Corrupt
  474. How do I copy color text & paste keeping color
  475. recently viewed items in Excel
  476. Auto-Close
  477. Macro Help
  478. Combine rows and Qty
  479. keyboard with excel
  480. Error using Data Query within Excel 2000
  481. To find the same price in another sheet
  482. command button colour
  483. Opening Lotus Files in Excel 2007
  484. how do I get autodate to stay the date it was saved
  485. Allocate payments
  486. Track Changes without sharing
  487. Excel formula
  488. Excel
  489. Barcode Font
  490. error with code
  491. Custom Number Format
  492. Date in 5 weeks from entered date
  493. .csv Re-Format Question
  494. First Pivot Table
  495. Look up in another sheet for values to return in 1st worksheet
  496. Curve fit coefficient
  497. Desparate For Help - Pivot Table Field List
  498. break links not working
  499. Copying cells working only sporadically
  500. Transfer information from column
  501. custom date format
  502. n "añadir botones" solo me aparece "estandar" ¿Como restablezco
  503. Conditional Formating based on 3 Conditions
  504. Cell formats
  505. How do i enable all 1,00,000+ rows in excel 2007
  506. Creating a list using the file names
  507. How to determine the value?
  508. add specific character in existing cell
  509. External data properties
  510. how do you insert a tick in excel document
  511. Lookups
  512. formula help
  513. Control pie slice colors
  514. Mangonuts
  515. how do i save an excel file as .xbrl?
  516. excel 2007
  517. no cells, grey screen, all tabs greyed out
  518. Setting the lower limit of a logarithmic axis scale
  519. Add Watch
  520. How to use 3 axis data to create 3d box
  521. Auto Refresh data from original worksheet to newly created copy
  522. Number of characters to be displayed in a cell
  523. Subtraction of 2 numbers/cells
  524. Counting Cells in a column depending on another column but excluding duplicates
  525. Copy function.
  526. Why my default number format changed
  527. Appointments won't open
  528. formula help PLEASE PT 2
  529. missing styles
  530. I need to link 4 pivot tables that are on a single page.
  531. formula help PLEASE
  532. Auto Lease
  533. IF nested problem ..!
  534. How to create a pull down lists?
  535. Autofilter header row
  536. Audit Trail
  537. Cell Referencing
  538. Excel Jululian
  539. Using an Excel File in Mailings
  540. Date Formula
  541. Single Filter to change all Pivot Tables in a Workbook
  542. Filtered Sort freezing up
  543. Macro's
  544. Link a file to a Pivot Table in another file
  545. Filter duplicates based on criteria / column values
  546. Look up and return data
  547. Does a formula exist that will lookup on ALL tabs, not just one.
  548. setting scale on chart automatically
  549. TODAY() in an IF AND function
  550. spreadsheet
  551. How do I do a TODAY() Function within a Nested IF AND Function
  552. A link to a collection of tutorials and videos on Data-Applied.
  553. Excel file size limitation
  554. Excel on Different Computers
  555. excel help
  556. File Size
  557. Pivot data
  558. double use of Substitution Function
  559. Formula for calculating the diffrence between two dates
  560. Pivot Tables
  561. =Countif(range, criteria)
  562. Embedded web graphics not displaying
  563. Enable/Disable Macros Pop-Up
  564. Excel hyperlink within workbook and SharePoint drafts
  565. Conditional Formatting Minimim Value
  566. vba or excel help
  567. if cell in other worksheet meets criteria, then leave blank.
  568. copy and paste macro
  569. Allocate payments
  570. Creating emailing list from column of addresses
  571. Enable/Disable Macro Pop-Up
  572. Does anyone have coding for Parabolic SAR?
  573. How to split a cell diagonally?
  574. text to columns
  575. "Reverse" conditional format
  576. one cell in my worksheet appears blank, but answr shows in formula
  577. How do I create unique pivot tables from the same data
  578. Compatible Mode for 97/2003 doc in 2007
  579. View Pivot Table Source data as a Data Table
  580. HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
  581. HELP! Lookup
  582. enter a formula
  583. "seeing" hyperlinks in a worksheet
  584. counting numbers
  585. What does the number 1.26E-23 mean? Is it a large or small number
  586. Data validation list, combobox
  587. external data table sort order
  588. Printing two columns of data in telephone directory style
  589. detect trailing spaces in an excel document
  590. Forgot Password
  591. Declare variables to a code?
  592. VB Help Needed
  593. rewrite code
  594. Move Form to edge of chart window
  595. Difference in time
  596. Userform modal
  597. Locked for Editing
  598. Vlookup with difference between two data
  599. how do I email excell
  600. Auto change of data in a cell like a Slide show in ppt
  601. autocalculate doesn't work even with formula .
  602. How to change the date format?
  603. Heat Map
  604. Copy of VB code to new spreadsheet
  605. How do I remove a Calculated Field from the Pivot Table field list
  606. Macro & Protected sheet
  607. How to enable / disable re-calculation option?
  608. ADDING COLUMNS FOR COMMON ROWS
  609. cell that updated when spreadsheet is modified
  610. Count cell changes
  611. Return information in one cell based on search in other sheets
  612. HOW TO ADD LEGENDS IN CHART
  613. Excel 2007 with macros and Apple
  614. I closed an excel file without saving the changes. Can I retrieve
  615. Using Popups to select a range of cells.
  616. How to determine the value within specific cell position?
  617. Macro Enable/Disable Pop-Up Warning
  618. How to retrieve the sheet name?
  619. Large Excel 2008 .xlsx file behaviour with Vista
  620. Copied Worksheet, lost the lines that were drawn
  621. please, add the feature that allows us to attach file with our thr
  622. 我用WIN 7和OFFICE 2007,在使用excel时,想插入“超连接 ,却显示“这项作业*电脑上作用* 限制而取消”,如何解
  623. Date Calculations
  624. How to get value a field based on of two other columns?
  625. How to password protect multiple workbooks?
  626. Need help vlookup?
  627. Named Range
  628. Can't move page break
  629. Sheet Names Randomly Change (Chart Sheets Only)
  630. Analyzing 2 excel workbooks
  631. Printing on Plotter
  632. Macro to hide/unhide WS based upon WS tab color
  633. I need to copy a formula to a 100 cells
  634. Insert a Row and then Sum
  635. What is the formula for calculating the age (Expiry Date)
  636. How to get an end date for a schedule excluding Sundays?
  637. Congratulations, Jacob Skaria...
  638. Excel 2003 - Maximum number of characters a cell can contain?
  639. Printing Problem
  640. Remove print area from multiples pages
  641. Error when Saving a Workspace
  642. Convert Grams to Ounces, Ounces to Grams without a conflict
  643. VLOOKUP 1st Friday in April and So On
  644. Data summary
  645. RE: Declaring variables for use in multiple worksheets
  646. Macro to hide worksheet based upon text in the name
  647. Format Question
  648. create chart from daily data and add trend lines for each week
  649. IF ERROR FORMULA
  650. Hyperlink to specific page in a pdf
  651. Sumproduct to count between two dates
  652. How to translate text in a whole spreadsheet one language to anoth
  653. Keyboard shortcut for Auto-filter
  654. Visualizing fiscal year impact
  655. Area Charts in 2007 - how to bring data set to front?
  656. I have an excel file split 1 and 2 how do I restore it please ?
  657. Excel 2007 - Customised Menu
  658. Point Sec Protector
  659. Time entry and calculation
  660. Save a macro button onto a toolbar
  661. using Vlookup to validate data
  662. I want to link sheets in excel to a master sheet in excel
  663. How to make a .XLTM template file default to save as .XLSM type?
  664. Organizing a column for what's after the @
  665. Retrospective Cell Naming
  666. Formula Help
  667. adding spaces
  668. Run "Workbook Open" once
  669. Put excel data on a US map
  670. How do I save the same document in 2 different files
  671. find a record with a missing value
  672. Refresh of links in shared file.
  673. How do I sort a column using the last number in the cell?
  674. =CELL("filename") returns #VALUE!
  675. Comparing two columns of text data
  676. Ghost Data/Large Operation
  677. Custom Views
  678. moving data from one sheet to another
  679. IFERROR TO COMPARE WKSHEET
  680. How do you randomly generate numbers in Excel 2007?
  681. WorkSheet Cell Precedents?
  682. Way to create a note based on the contents entered in a cell?
  683. Saving and Sharing with VBA
  684. Emaling(as body)
  685. Excel Equivalent of Access "Load" Event?
  686. Lock format but allow data entry
  687. Disable auto (date) format?
  688. opening files error
  689. i want to know formulas in MS-Excel2003
  690. I need to show a % of a number
  691. Use hyperlink to open workbook read only?
  692. Web lookup query (have: city+state | want: zip code)
  693. Calculate parts per hour on rotating line
  694. Return value greater than in LOOKUP
  695. "Enter" moves the screen, not to next cell(excel07) help!
  696. Help with a range formula
  697. If statement with 9 sequences.. problem
  698. If Statement with 9 sequences
  699. Retain drop down lists in Excel when saved as HTML
  700. convert to minutes
  701. Patient Demand on X Day of the Month
  702. If Statement with 9 sequences
  703. Excel
  704. Lookup for Part of the number
  705. clean up code a little
  706. Index/Match vs VLookup?
  707. Countif result problem
  708. Multi-select from a dropdown list
  709. VLookup Variable Offset
  710. Block a excel file from being copied?
  711. how can i make furmulas for converting gram to microliter,thanks
  712. Why would someone use $-sign?
  713. Need a formula to count dates
  714. Need to Change Case from Mixed to Caps
  715. Sum If ???
  716. How do I do a drop down box with calender in excel?
  717. Order of Numbers
  718. Sum and multiply at the same time?
  719. INSERTING NEW ROWS
  720. drop down list should remember selection.
  721. Need formula to locate and validate specific text from a string
  722. External Referance over Network
  723. Import XML
  724. Subtract 12 hours from date/time
  725. copy rows and paste onto visible only
  726. Sorting and COUNTIF
  727. Problems with merged cells
  728. Color certain strings of text
  729. COUNTIF, Sorting, on Two Sheets
  730. Countif, Sorting => Two Sheets
  731. Repetitive macros
  732. COUNTIF, Sorting, Two Sheets
  733. Mask Account Number
  734. Combine Descriptions
  735. Showing Outline Symbols
  736. Cell formatting
  737. vba autosave
  738. If statements
  739. Grouping Multiple Entries
  740. I cant select rows or columns
  741. IF or SUMIF to bring back text?
  742. rename default sheet numbers
  743. Compatibility Checker - minor loss of fidelity
  744. Sumifs
  745. Total percentages
  746. Need Macro- Insert rows based on dates and copy info from that row
  747. Installation Issues
  748. Assign numerical value to cell based on selection from drop-down m
  749. only a certain text from a target col
  750. Calculating Age NOT as of today but as of a date in the future or
  751. Forumla Needed: Text or Number Format
  752. If then
  753. Multisheet range in SUMPRODUCT?
  754. How to clear clipboard memory?
  755. "_Fill" and "_Key1" is contained in the worksheet I want to copy..
  756. trouble posting tothis group
  757. Trust Center - Trusted Locations are greyed out
  758. Insert pdf file into Excel
  759. How do I change the color the cell becomes when doing a FIND
  760. RE: Make a csv file open in excel instead of IE
  761. Ranking in a Different Way
  762. Trust Center - Trusted Locations are greyed out
  763. random select a percentage from a list
  764. sort data without changing pattern
  765. Dysfunctional link in Excel 2007 help
  766. Using Tab key to jump to specific cell
  767. Count max consecutive cells
  768. Re: Nested If Formula
  769. Consolidate
  770. Alt-F6
  771. Calculate Filtered Columns
  772. Unknown repair
  773. Pivot Table - replace numbers with a text
  774. Default date format (with shortcut keys)
  775. .xls .doc files have become corrupted after BSOD!!! how recover?
  776. Macro to run on selected sheets
  777. xlsx viewer
  778. Blank
  779. Blank Cell
  780. excel inserted in word document
  781. IF FORMULA
  782. Excel worksheet
  783. re: formula needs to move across 1 column every week
  784. in excel, workbook column heading is displaying numbers not lette.
  785. 00/01/1900
  786. Use CountIf() with symbols
  787. Working hours
  788. Formula shows in cell instead of results (text reference)
  789. auto update to multiple worksheets
  790. How do I provide new sample spreadsheets to office online
  791. Easy way to add my custom button on Excel 2010 quick access toolbar?
  792. Very Slow to open 2003 Excel Files
  793. What is the syntax for control+UpArrow in Macro?
  794. Pivot Table Help
  795. Name Format Formula
  796. how do I get one dropdown menu to trigger another one in excel
  797. Prevent cut & paste in a protected worksheet.
  798. line graphs
  799. D-Concentrate numbers
  800. Charts Resize on Open
  801. Connecting multiple IF statements into one formula
  802. How do i change column header from R[1] C format to A1 format?
  803. Size of drop down in validation list
  804. AutoCalculate
  805. Named range error
  806. @Sum Conditional Values within a Macro
  807. Count specific days in between dates
  808. lost ability to sort by color
  809. The picture is too large and will be truncated."-excel Warning
  810. If formula: if A1 is greater than B1 and A1 is greater than zero..
  811. Vlookup
  812. Sort data
  813. Form and protect sheet
  814. Hidden tabs on my worksheet
  815. How to multiply time by monitary value
  816. Need help with Counters
  817. auto selection by FILTER
  818. 2003 documents converted to 2007, lines drawn in are misaligned
  819. Updating a DATE, only if the page has been modified.
  820. Calculate the annual payment for a $4,000 loan, 3%, 3 years,
  821. to find the repetitve text from a column.
  822. create a message box when opening a file in word or excel 2007
  823. IF need to add a third value
  824. XLT and Internet
  825. excel formula
  826. Time calc formula please.
  827. Fals Result in IF Formula
  828. convert text "20100315" to date format
  829. Excel 2010
  830. restrict view of certain cells in excel
  831. Calculate How the Number of Specific word.
  832. rks Data Validation
  833. percentage in excel
  834. Where is the print funtion in excel 2007?
  835. Paste Value Error
  836. Workbook_Open code help
  837. Using Cartesian Cell Names
  838. Calculation of Credit Card %
  839. Tabbing through input worksheet
  840. help on a vlookup please
  841. Sumproduct Erro
  842. Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?
  843. Link Cells (Read for more info) -- HELP PLEASE
  844. Chart Goal Lines
  845. How do I recover a prior version of a saved document?
  846. what if formula
  847. How to not display right side column for information?
  848. Dropdown List That Accepts Other User Input
  849. Delete entire row if older then 365 days
  850. hide formula in cells till data is available for calc
  851. Word prints Excel does not!
  852. Sorting and coloring cells, formula or macro help needed
  853. find the last occurance of a character in a cell
  854. sorting two columns of merged cells
  855. Print selected worksheets in multiple workbooks?
  856. alignment in a validation list
  857. Automatically move a set of cells
  858. How to enter excel dates for last year?
  859. WHY IS FREEZE PAINS GREYED OUT
  860. templates
  861. scroll left and right mouse wheel doesn't work in excel
  862. anyone have a simple income/expenditure sheet, excel
  863. how do you include todays date in SUMIF formulas
  864. right click
  865. date comparision
  866. How to not display clip board on the right side?
  867. Save file to same directory folder
  868. Percentage between two numbers
  869. why do i get the pdf icon when copy and paste in excel
  870. Sumproduct
  871. Copying multiple cells out of multiple worksheets at same time.
  872. row height does not move with row when sorting
  873. making a comment/description area in middle of form template
  874. Anyone have an idea of Excel use among versions?
  875. Excel open NOT in compatability mode
  876. PIVOT TABLE Help Please
  877. Excel Spreadsheets Reformat Question
  878. highlight the row of the cell Im working in?
  879. merging cells and eliminating spaces for empty cells
  880. Name a worksheet tab based on the value in a cell.
  881. Sumif comparing dates in criteria
  882. z-order of various lines and bars in an Excel 2007 chart
  883. Drop down/data validation list
  884. vlookup + if formula help!
  885. worksheet change question
  886. Formula HELLLPPP!
  887. replace ' in cells
  888. spreadsheet layout changes
  889. Compare an Array to a Date Range
  890. combining text
  891. Having a macro/function available in new spreadsheets
  892. Excel 2002 : How to eliminate _ before a cell address in a formula
  893. Excel 2002: How to select an invoice entry ?
  894. RE: Macro passwords
  895. Vlookup based on a unique "Text" occur
  896. Changing Arbic numeral to Hindi numeral
  897. How to delete cells with a given data?
  898. how to embed print instruction portrait landscape in excel
  899. Saving an Excel Spreadsheet outside of Excel Recent Documents
  900. sharing workbook
  901. Pivot Table
  902. Moving Text from Word to Excel (and having it set into 2 columns)
  903. compile data base on hit
  904. Macro to send email
  905. How do I parse the data in a cell
  906. Outlook Calendars
  907. why can't i browse to a location to save a flat file
  908. VBA to select all cells with content
  909. When opening a file in 2003 it gives a look in option-Where n 200.
  910. Cell Formats - Limit # of characters
  911. keeping values
  912. Formula help--lookup?
  913. Vlookup in Excel 2003
  914. Formula help
  915. Hyperlink to 'hidden' grouped cells
  916. Disabling Compatibility Checker
  917. series of sums in a long spreadsheet
  918. Lookup, vlookup, find, or what
  919. Formula showing in cell
  920. any good accounts payable templates?
  921. Deleting rows meeting certain criteria in a particular column
  922. Filter (blanks) with two or more unique values not working
  923. Chart - Custom Stacked Bar with Line
  924. VBA Printing Custom Footer on all but last page
  925. .csv Saved File Question
  926. Excel 2007: Percentile vs Percent when It comes to Color Scaling?
  927. Formula to move from cell to cell
  928. Sot data and make it apperar in other sheet?
  929. Mail Merge
  930. How do I find responses to my posts?
  931. Target.Offset(0, 36).Value Help
  932. Sort Warning disabled? Need to enable it
  933. excel changes date
  934. outlook 2007 wont recognize my profiles
  935. Text Columns Function
  936. Pulling Data
  937. Expand Conditional Formatting to all Rows
  938. RE: Page 1, Page 2..shows up in the middle of the worksheet.
  939. Auto-filter selection
  940. How to change order of drop lines relative to the plotted data inExcel 2007 chart
  941. Excel 2003: Keeps applying auto-font settings I don't want
  942. Spreadsheet (version 1).xls: file format is not valid
  943. Saving a newer version of Excel using an older version (Excel 97)
  944. Importing Works data to Excel
  945. Auto Format icon
  946. Protecting Xcel worksheets
  947. lookup H&V...or match...index???
  948. Excel Sheet Suddenly Runs Slow
  949. mailto syntax for text to display
  950. macro for inserting one row between different data
  951. Data from one spreadsheet to the other
  952. how can I get old replaced excel file
  953. Standard Colors
  954. Autorecover takes so long
  955. vlookup?
  956. Macro to return to original cell
  957. Can i avoid "00.00" when the result of a calculation is 0?
  958. Can I automatically have a space after the content in an Excel cel
  959. Annoying issue
  960. Import from Excel to Windows live outlook
  961. Word Wrap Not Working on Double Click
  962. Printing problem in Excell 2007
  963. lost ability to filter by color
  964. Problem with Excel getting correct # of records back from Access
  965. Excel Pivot table - getting back to the skeleton template
  966. data conversion
  967. macro-import another xls file
  968. Need to create an automatic hyperlink
  969. How do I convert rows into columns?
  970. How do I convert rows to columns
  971. VBA Formula Help
  972. keep source formatting when concatenating
  973. do you have examples of make vs. buy models in Excel?
  974. how do you show the status bar if you accidently hide it?
  975. Conditional format for unique values
  976. change links to a different source in the same workbook
  977. Printing Large Posters 3' x 4'
  978. Excel On-line
  979. Sorting/Filtering Info
  980. Append multiple columns
  981. how do I get rid of ###### that appear instead of text in excel?
  982. VLOOKUP returns 0 (zero) when lookup cell is blank
  983. append multiple columns
  984. Emailing Excel with hyperlinks
  985. VBA Code to Export Data from Chart
  986. Missing sheet tabs and horizontal scroll bar
  987. Compare 2 worksheets
  988. Forumal writing for imported sheets
  989. Adding hours and minutes
  990. INDEX and OFFSET Formulas
  991. email a worksheet
  992. SUBTOTAL A LIST
  993. Need Macro to create a new worksheet and insert image
  994. Double If Statement help
  995. reformat dates to yyyy/mm/dd
  996. Compare worksheet data
  997. Look up, return value
  998. OFFSET Formula
  999. Block cracking code from opening protected excel sheets
  1000. Help with Text and Dates