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. OFFSET FUNCTION
  2. copying a named range
  3. Alerts - how to cancel
  4. Do VLOOKUPs require the applicable other files to be open?
  5. Return a value based on another cell
  6. Need More Columns than IV
  7. Count question
  8. how do I delete a row automatically after each date
  9. File Name Display
  10. Combo Box Properties
  11. Rounding 1,000s
  12. Links not updating - autocalc is on
  13. how do I delete a row automatically after each date ends
  14. Print file name to all files from excel?
  15. IF statements
  16. Conditional Format-Expirery date
  17. print areas on one page to print?
  18. Sort problem
  19. less than (<) in a formula
  20. Set up Form
  21. Linking to another spreadsheet in a dynamic way
  22. Round doesnt work the way it is expected
  23. Can anyone tell me what this formula means?
  24. can I set a date alarm in Excel
  25. How to use If statement to read a value in a cell
  26. SUM IF with conditions in another column
  27. Sum Multiple Ranges in the Same Column
  28. getting chart legend to ignore #NA s!
  29. format in macro
  30. Percentage sign
  31. Questions about Forms & Controls
  32. COUNTIF with criteria in 2 columns
  33. automate charting question!
  34. How to I make sure that my workbook always opens with a desired sh
  35. Userform / Text Box problems.
  36. Pivot Tables - "(blank)" in rows and cells
  37. Date round-up
  38. Userform Rangebutton
  39. how do i prevent duplicate values in a range of validated cells?
  40. Changing error reports in functions
  41. A macro that counts the number of times a file is opened
  42. Excel Question
  43. typing text on lines
  44. Problems searching a database and reporting all occurrences of a v
  45. 2007 Excel Functions
  46. Countif rows
  47. Best way to share a sheet?
  48. Excel pastes as object into new workbook
  49. Auto-numbering new row entries
  50. I have a problem with "LEFT" formula
  51. Row height to auto-adjust for wrapped text
  52. working with a long list
  53. how to stop long formulas from obscuring column letters?
  54. Creating a formula
  55. need sumproduct
  56. how do I resize a range of cells in a column in excel?
  57. Command button and requested field
  58. problem with Linking workbooks via "copy" and "paste link"
  59. IF Question
  60. from browser opening csv in Excel and invoking template, how?
  61. I am looking for a imple formula for excel i need Cloumn be to be
  62. File size increase
  63. Cell value not recognized by code.
  64. how do I resize only a part of a column in excel?
  65. Setting Print Settings Across Entire Workbook
  66. Is there any plan to incorporate an "Excel 2003 Menu type" structu
  67. Help with Formula
  68. Data lining up correctly when printing
  69. How to easily put a sum of all pages
  70. XML vs. XLS
  71. Happy Holidays
  72. Importing Data From a "Formula-Based Website"
  73. Happy Holiday
  74. automatically update a link without opening the other spreadsheet
  75. Excel with game is stuck in a loop
  76. Changing the Note Indicator location
  77. Still looking for help
  78. how to view two seperate speadsheets side by side using Excel 07
  79. Excel function help
  80. Autoupdating a range with Vlookup?
  81. Using TODAY function to return a date as text
  82. Excel to e-mail, with a twist
  83. shared excel document
  84. Auto formula fill
  85. Bold Row if Col E is bold
  86. getting more data into an excel cell?
  87. How can i allow my excel webpage to be edited and not read only
  88. Message alert
  89. Referencing a data validation list
  90. Auto Format in Excel 2007
  91. I can not update my pivot charts and tables.
  92. Bubble chart or something similar
  93. Trouble with Images and Autofilter
  94. Substitution
  95. How do I perform mathematical convolution in Excel?
  96. putting 2 conditions in a formula
  97. Is this release buggy?
  98. Splitting Numbers
  99. Validation list with blanks at the bottom
  100. Window Menu is empty
  101. Maximum number of Worksheets printed
  102. Multiply/ Round by 1000
  103. Why does this formula =SUM(AJ3:AJ410) not add up/total correctly?
  104. data table, two-input
  105. How do you change Excel column names from ABC to 123?
  106. Excel Templates
  107. protecting individual cells
  108. making all the figures in one column appear as a negative
  109. protecting individual cells
  110. Is sumproduct the answer?
  111. Using IF to return more than text
  112. Printing multiple worksheets to one single pdf file
  113. Jean-Guy question
  114. Which Font uses the exact same amount of space for every letter?
  115. Shortcut key: move to last worksheet in file
  116. How to sum only positive values in a column?
  117. PasteSpecial Method Error
  118. exel help how to ???
  119. funtions and conditions
  120. delete rows with empty cells
  121. Moving to different cell
  122. find replace in multiple sheets based on namebox
  123. Going Crazy, excel can't subtract!
  124. COUNT-COUNT
  125. Excel Headers and Footers Printing out
  126. Auto-readjust row height to show entire formula results
  127. How to export excel file in dbf format
  128. E-mail from list of users
  129. Funny Reports
  130. new window settings
  131. how to: continuously updating column in new worksheet
  132. HOW CAN I MAKE OUR PENDING SHIPMENT SHEDULE IN EXCEL?
  133. auto fill every other cell from other workbook
  134. File & Help only active menu items
  135. Can spin boxes be rotated in Excel?
  136. Macros created in 2003 won't work in 2000
  137. How do I lock cell value even if other values change
  138. Row height problem
  139. Find first blank row in worksheet to import data from txt file
  140. Is this a joke or Microsoft screws up again?
  141. Num error #3
  142. Num Error #2
  143. #value
  144. NUM Error
  145. Excel 2003 color resetting problem
  146. Ink Annotations in Protected Worksheet
  147. Formula going troppo
  148. Combining multiple pivot tables
  149. Can't delete Excel file saved as web page
  150. Need help concatenating and formulas
  151. Indirect reference to another worksheet in file
  152. Can I pivot multiple data fields and display them in a column?
  153. How do I prevent excel from automatically changing my numbers?
  154. Formula to recognize if another cell's conditional format is true
  155. Macro to Formula References
  156. Array formulas won't recognize external data from Microsoft Query
  157. In-Cell Dropdown for validation not displaying
  158. Password for Folder?
  159. Macro Starter
  160. Printing on 11" x 17" paper?
  161. saving a big spreadsheet in chunks
  162. Default color for graphs, charts, etc.. in excel and powerpoint
  163. Chart data range
  164. Replacing last 3 characters and adding them to front
  165. Rounding Question
  166. Autosaving an Excel Workbooks as versions
  167. Conditional Formatting Entire Row
  168. Formating Pivot Tables
  169. How do you change the File save locations in Excel 2007?
  170. Date Expiry function
  171. Lost data
  172. Pixcel vs cm
  173. Excel 2003 Workbook I want to convert to Excel 2007
  174. how to password protect a validation list?
  175. Copying Worksheets with Validations - Response Time
  176. How do I upgrade to 2003
  177. I've added hyperlinks to cells, but when I save the file they don'
  178. UNC for external data source
  179. How to include ranges of data in a nested EXCEL formula
  180. Extracting Data From A Table
  181. Getting 0 values when merging for labels
  182. How to extract a few results (names) from i big list into a small
  183. first time here: IF function problem
  184. Formula if a conditional format exists
  185. Linking, find and replace
  186. Adding every 5th row (e.g. B5 + B10 + B15 etc)
  187. Can excel display HTML in cells
  188. ranking names
  189. Shortcut does not work
  190. Pivot table is not valid in Excel 2000 but works fine in EXCEL 200
  191. automatic date
  192. Using IF Function
  193. Finding cells that contain an apostrophe
  194. promting a number in cell
  195. How do we add a separator in Excel 2007 menu using VBA
  196. Date Format Under Japanese Locale
  197. Recalculate changes only
  198. Can We Arrange Multiple Sheets of Excel File in Alphabetical Orde
  199. Conditional Formating from Drop Down List
  200. sortinging data from a specific point
  201. excel help
  202. Converting excel file to tab delimited (txt) file
  203. Formatting a cell
  204. Macro Tutorial
  205. How many items can be listed on Ebay for through MS SB Pro 2007?
  206. How do I create a custom fill series for dates?
  207. Formatting Phone Numbers with Periods
  208. Fill Down In Rows But Want to Increase By Letter
  209. excell does not print rows or columns
  210. Filling in blank rows
  211. If cell has any character typed in it cell curser moves to next c
  212. Overlay Schedule Question
  213. Hyperlinks in drop down list
  214. Replace values in shaded cells with blanks
  215. in excel: how to change the return key to go to the right instead
  216. Copy&paste cells w/o affecting borders
  217. USE PART OF TEXT FROM ONE CELL IN ANOTHER
  218. using a cell value to name a newly created workbook
  219. Simple Format Question
  220. Sheet Tabs
  221. how do I paste excel text into a comment box?
  222. Calculate review date
  223. Find feature defaults to look in formulas
  224. Introduce decimal point in a list of values in column.
  225. How do I calculate?
  226. "How do I print comments with a Excel sheet"
  227. drop-down List range define
  228. Counting a mixed text/number column based on text in another colum
  229. gedcom files in excell
  230. archiving spread sheets
  231. Increase a currency grid values by 3%
  232. How do I flip the order of a column? (it is sequintial, so not sor
  233. Names & Dates
  234. how can I calculate n root of a given number?
  235. Excel 2002 Update
  236. validation
  237. Maintenence Spreadsheet
  238. Making Border of Frozen Panes Invisible
  239. how do i delete grid lines from one column
  240. Open From Read-Only Location ?
  241. Opening calendar form with today's month & year
  242. status bar displays calculate
  243. Passwords for folders?
  244. Need more than 7 nested "IF" statements in Excel"
  245. excel - print worksheet as 2 columns (like in word)
  246. Macros won't work in 2000 that are created in 2003
  247. hiding data points on a line graph
  248. List the one nonempty cell
  249. pricing
  250. Keeping the Plus Sign when importing from CSV file
  251. how can I personalize more my graphics in Excel?
  252. Open .txt file in excel
  253. Advanced Filters - can I "not"
  254. Open file
  255. How do I parse one column into different columns?
  256. Invoice Numbers
  257. Automatic link refresh
  258. SHAST.form.xls
  259. How can I get Office to activate a command in a non Office program
  260. How do I export to word without getting strange spacing and tabs
  261. Excel won't stop rounding numbers. Please help
  262. keep cell value when another cell value changes
  263. MULTIPLE DATA - How to insert new data into existing data....
  264. Excel 2007 (Trial) Active X Problems
  265. Too many different cell formats
  266. How to Remove Automatic Links?
  267. Pivot Table question
  268. decimal to comma
  269. Step up blank rows
  270. Custom Format
  271. inserting an address into excel 2003
  272. i need visible study template
  273. Count
  274. If Formula
  275. Pivot table - don't group names
  276. Disable collate "on" option?
  277. Why can't I sort a worksheet in Excel?
  278. reverse the entries in an Excel column
  279. LOOKUP across multiple arrays
  280. multiple SUMIF arguments
  281. Astra Schedule export to excel problems
  282. Autocopy formula without VB
  283. Formatting default text location in cells
  284. multipl HLOOKUP/VLOOKUP Criteria
  285. Find and replace
  286. Merge data rows at fixed ratio
  287. Recently Used Templates list in Task Pane
  288. How do I insert a link to a cell in a header in Excel?
  289. How Do I turn off indicators and comments?
  290. lock folder through DOS
  291. Move/Copy or Copy/Insert worksheet?
  292. Excel 2002 : How to move to the last line of the active worksheet
  293. find, replace, update links
  294. Formula??
  295. Controlling column widths in interactive web page output
  296. Date formatting
  297. Solver bug - Won't return Integer
  298. Strange message when Excel starts.
  299. How do I type text and have a formula in the same cell?
  300. Saving CSV file with TXT extension
  301. Changing Hyper links for the whole sheet
  302. how to show long x-axis label in two lines?
  303. Cell Shading from a Bit Map image
  304. Macro to create a new folder according to the month
  305. how to delete multiple rows in excel, with one click?
  306. How to activate (in the Project Explorer window) using VBA
  307. Symbols added to Word's AutoCorrect don't appear in Excel
  308. what does this mean?
  309. Formatting cells
  310. Linking Spreadsheets in a Workbook
  311. Can Excel settings default to always print entire workbook?
  312. Calculate Sum in one cell after Exiting (ENTER or TAB) another cel
  313. alert before deleting contents of a cell
  314. how to restore link in the formula via file saved from emails
  315. Selecting A Column based on Cell Value
  316. Why number 8 turns into a 0?
  317. sum if - month question
  318. XML List of lists in Excel
  319. Sending an e-mail from the Excel or Word toolbar
  320. Question on RATE()-like method for non-straightline values
  321. Publishing Excel Files to a web page
  322. Macro Prompt for Zoom size
  323. Links in Excel 2003
  324. Sorting data with an imbedded list
  325. Pivot Tables...argghh
  326. Need to find the right formula
  327. How do i convert unix time to Julian time in excel?
  328. Eliminate Blank Rown in a List - Then Create New List
  329. Naming Worksheet tabs
  330. How do I accrue certain cell values across multiple worksheets?
  331. Help with data manipulation
  332. can I ensure a drop down list is used i.e by preventing printing
  333. Need help with formula
  334. Formula help
  335. time sheet spreadsheet
  336. VBA Numbers to Text or Date to Text
  337. Date formating
  338. File Convert With commas to txt format
  339. If Forumla
  340. spread sheet problems
  341. Changing Text to Numbers
  342. abs function for column
  343. Alternating BG colors between groups of rows
  344. how do I quickly insert numbers 1 to 100 in a column in Excel?
  345. Overwriting an existing Excel workbook
  346. euro symbol not displaying in excel
  347. Method 'MacroOptions' of object'_Application' failed Runtime Error 1004
  348. converter tool to convert XL 2007 files to XL 2003 files
  349. Complex If/Then formula?
  350. Automatically populate and multiply amounts
  351. Can I Shade Text Only In A Cell?
  352. Quiz...
  353. Using Hyperlinks in Data Validation
  354. Folder information
  355. protecting worksheets
  356. Find a value, return the value of another cell
  357. Renaming A File
  358. Show Non Blanks using MS Query
  359. Create a test
  360. Headers/Footers Formatting
  361. Help Making Diff CHarts have same Size and Loc on page
  362. Dropping 0
  363. inspiration
  364. excel
  365. Delete pages
  366. passwords for excel
  367. EXCEL CHANGE PASSWORD
  368. Can I increase # of worksheets in file over 255?
  369. how does excel calculate curves of best fit?
  370. Making my Formula F1 Race
  371. Excel 11 and Excel 12 addins
  372. Check box links
  373. Check input is a date
  374. auto filter within a macro
  375. autofilter
  376. Superscripted exponents
  377. hücre içerisine resim ekleme
  378. how to create pivot table from existing pivot table in excel 2007
  379. Copy/Move Worksheet from one Workbook to another
  380. Solver - Assign values to Letters of the Alphabet
  381. Solver - Assign values to Letters of the Alphabet
  382. Solver - Assign values to the letters of the alphabet
  383. Calander Control 9.0
  384. Solver - Assign values to Letters of the Alphabet
  385. Plus sign no longer appears when cell is selected
  386. Excel 2002; how to reduce the size of the save dialogue window?
  387. In Excel, how can i make text in a sigle sell flash, or flicker?
  388. TRANSPOSE 'group' of columns to rows
  389. Excel Formula using relative position of cells in two different worksheets
  390. Cell reference
  391. How can I call IE browser (Back button) through Excel macro?
  392. Creating list of names from specific value
  393. Can't open embedded .msg objects in Excel. Help!
  394. Lost "Relative Reference" button in Excel
  395. Do anyone know how to covert 912:30:44 into seconds
  396. Formula required - possibly macro
  397. Buisness Days Help
  398. title columns above the first numbered line
  399. Fill in blank cells
  400. Count # of Occurences
  401. Columns overflowing into the next
  402. Hide Zero values bar one
  403. process of elimination of duplicate information
  404. How do I remove a search bar on Excel?
  405. Opening Files to Dailogue Box
  406. How to stop Option Button unselecting one on different worksheet?
  407. excel
  408. Text box tabbing
  409. x-axis label placement
  410. Separating worksheets into separate workbooks
  411. Date issue
  412. Excel won't stop highlighting (Dec 06)
  413. Excel Form
  414. Making computation from primavera ...
  415. making a schedule from primavera...
  416. Addendum to 2 digit year to 4 digit year
  417. Search Spreadsheet for a name
  418. Making PMS-Histogram/S-curve for Progress REport from Primavera..
  419. how to include saturdays in networkdays formula
  420. Copy File from activecell
  421. Warning Message
  422. Should I be using Access?
  423. Format 2 digit year to 4 digit
  424. Combining data using a primary key
  425. File will not save
  426. How do I double the amount in each cell...for entire column?
  427. Sumproduct or countif?
  428. calculus
  429. Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu
  430. New rounding problem in Excel 2003?!?
  431. Home on the RANGE
  432. Need to Query Excel File Opened by Another User
  433. Neg Values in Chart with Diff Color?
  434. Subtraction Chart
  435. Error Msg 400 - Macro Spell Check
  436. How do I set up Excel to automatically hide certain rows?
  437. How to auto count data in an empty cell to be 0. Blank cell=0
  438. Frequency of a word string in an excel database
  439. strange character
  440. Alphabetizing
  441. One column stays while others scroll
  442. how to increment a value by 1 everytime excel is closed?
  443. Copy Multiple Rows into One Cell
  444. Sorting Decimals as Numbers
  445. Save as Button is greyed out in excel
  446. Bypassing a proxy server
  447. numbers instead of letters
  448. Printing the inserted picture
  449. HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS
  450. Count unique text values
  451. Selecting printer in a macro
  452. How to solve the following code?
  453. Excel's Rand() Function
  454. How do I print the "&" character in a footer?
  455. Auto-formatting cell contents
  456. exel de dosya acamıyorum
  457. XML Problem in Excel 2003
  458. How do I send or replicate info from sheet 1 to appear on sheet 2?
  459. suddenly see all the formulas?
  460. LOOKUP is working - but VLOOKUP is not
  461. How to Freeze Multiple Rows/Columns
  462. Removing Gridlines
  463. Filtering Columns
  464. Gridlines on Excel Spreadsheet
  465. SWOT sheet
  466. Formatting Cells
  467. Macro to open specific document
  468. Combining multiple cell information into one cell
  469. If statement
  470. how do install VBA in msoffice 2003 setup
  471. Filter
  472. Deleted Data
  473. How to Import Financial Data ?
  474. Windows - Delayed Write Failed
  475. How can i type two lines of text in the same row? Like A1or A2
  476. Add a character to the middle of a text string
  477. How do I add multiple data lines in one cell
  478. To Max MVP
  479. Table equations...
  480. How to send email to a list of people in excel sheet?
  481. How can I call IE browser (Back button) through Excel macro?
  482. How to create Dropdown lists not using Data Validation
  483. Help: Pictures Disappeared in Excel Worksheet
  484. deleting rows in a huge spreadsheet with subtotals
  485. Taking contents of a cell an inserting them into a phrase.
  486. How do I get rid of read only that isn't there?
  487. Excel 2003 Filtering
  488. UPDATING CELLS THAT HAVE BEEN CONNECTED FROM DIFFERENCT PAGES
  489. Stop scrolling on 1 worksheet
  490. How to do this kind of sorting?
  491. Numbering Sheets incrementally (as in Invoice numbers)
  492. Clear entries on Combo box
  493. autofilter and protection
  494. Question on formula
  495. Printing on notepad from excel worksheet... Please Help!!
  496. how to sum contents of duplicate rows
  497. Re: Batch Job "Text to column" in excel
  498. Rotating Rows To Columns
  499. running macros at a set time
  500. How do you skip graphing some data?
  501. Charts in Excel - please help.
  502. adding a phone area code that is not there
  503. merging 2 worksheets
  504. training worksheet in excel 2003 do not show up. Why????
  505. Turn functions off
  506. Please help me with an If statement
  507. How can I get Excel to open a document in a new Window ? NEW QUEST
  508. Copy while skipping Rows
  509. How to "return" the array element number in VBA
  510. how to compare cell content to a row pf data in excel and return .
  511. Delay Opening File
  512. Checkbox Font Size
  513. Excel Form attached to a Word Document Letter
  514. Choose Data Source
  515. alphabetize
  516. Excel File is shrinking two pages to fit to one page
  517. Sort then lookup
  518. ADD DATA TO A COMMENT BOX
  519. Index,match, vlookup?
  520. Complicated (to me!) find and replace
  521. Date Cut & Paste Issue
  522. Insert lines at each change in value
  523. How do I sum the value of a range of cells without pulling any ce.
  524. Formulas never show result???
  525. Please help with selecting a range
  526. Formula???
  527. two lookups?
  528. Editing a Macro
  529. XML data Error in Excel 2003
  530. Column Width
  531. Cells converting ###s to formulas
  532. Mail merge with header/field info in 3rd row
  533. Formula 'mis' calculate when reference cell contains a "0"
  534. Function for Deleting Data?
  535. Problem naming tab- Keep getting .xls] in front
  536. Sorting Data
  537. Using Excel VBA to manage outlook attachments 2003
  538. using scroll wheel in vba window
  539. check if there is any double information
  540. Excel 2002-SP3 keeps trying to open deleted workbooks
  541. Please help****I am trying to create a formula and it doesn't work!!!!
  542. How can you text in excel to go from bottom to top of the cell?
  543. List Problem--Please help?
  544. Referencing a Worksheet
  545. Sumproduct w/ multiple factors: Correct and Incorrect return value
  546. Sudden "0" output on Sumproduct formulas
  547. lookups
  548. Searching, matching then searching another list based on the match
  549. How do I set up a salary compression template in Excel?
  550. Copying html data
  551. Strange double-click behaviour
  552. Any shortcut to switch between fonts
  553. Word (text) with a numeric value...PLEASE HELP!
  554. Returning Values
  555. how do i get the red x out of a cell
  556. RE: SQL Server -- Bulk Insert from Excel to SQL Server
  557. Basic format problem
  558. Array formulas convert to zero when e-mailing
  559. Insert spreadsheet - without changing appearance?
  560. subtotal copy-paste and delete hidden rows
  561. Charts in Excell
  562. Insert Worksheet
  563. Ranking
  564. Maintaining in-doc hyperlinks when rows/cells change
  565. MERRY CHRISTMAS
  566. Header date
  567. Calculating sum based on value in adjacent column
  568. separating +ve and -ve numbers into two columns
  569. Lookup - Display contents of a cell
  570. Same macro - Different Worksheets!?
  571. Data Form has macro issues
  572. How do I set up a Page Border in Excel?
  573. Saving Excel (2003) File Causes Growing Size
  574. stop automation to date field
  575. How to change to the Indian Number System?
  576. compunt document
  577. How to extract decimal numbers e.g. $1.57 from alphanumeric string
  578. array formula q
  579. Macro question in 2007
  580. Extraction Question
  581. Macro Questoin
  582. Web Queries and how Excel sees the "selected box" on the web page
  583. How can you change the x-y axis of data in an excel spreadsheet?
  584. value list in excel
  585. Conditional Formulas--Suppressing error values?
  586. How can you add the Add-ins permently?
  587. how to solve equations in excel that involve iterations?
  588. Comparing Data and Updating a worksheet
  589. Help with VBA, Combo Box and Filter
  590. Copying Named Ranges
  591. Calender
  592. highlighting altered cells
  593. Cursor Highlighting
  594. Large workbooks
  595. is there a add-on for excel to make mp3 list from directory
  596. Totals in Pivot Table
  597. Automatic Value
  598. Text Box w/Scroll Bar
  599. excel protection
  600. Batch Job "Text to column" in excel
  601. adobe converter in excel
  602. How to remove the Chinese language option from Excel?
  603. fix font size in a drop down list
  604. Error - No more new fonts in this workbook
  605. Excel 2007 links not working
  606. Calculating Median Value in a large array
  607. Export from OL to Excel with 2 line addresses question
  608. forcing cell entry with validation
  609. Worksheet protection
  610. Workbook_Open event does not run on Outlook attachment
  611. Conditional Formatting Highlights
  612. Excel Comparison program?
  613. Formula #Value error
  614. Undo multiple actions
  615. Excel macro to prompt for filename
  616. Wrong Answer
  617. build a pivot table from multiple other pivot tables.
  618. Returning a mortgage balance based on a particular date
  619. How do I take a string of text and convert it ASCII Values?
  620. Ratings
  621. NOT saving Excel files
  622. how do I get saved information onto a floppy disc?
  623. How do I delete or edit this- file properties statistics in excel.
  624. Insert several Excel files into existing Excel file?
  625. Conditional Min Value
  626. essbase add in for xl
  627. Can I share a selfcert macro workbook with other network users
  628. Copy / Paste
  629. DATA OUT OF THE PIVOT TABLE PLEASEEE!!!
  630. Excel 2003 Error Message
  631. Autofilter 2007
  632. COUNTIF not computing
  633. Bug? Pasting values instead of formulas...
  634. Order of words in title of Excel windows
  635. Can I consolidate one work sheet from several workbooks? A few oth
  636. Can I consolidate one work sheet from several workbooks? A few oth
  637. Use last Cell in Formula
  638. Maybe cancatenate
  639. need filtering help
  640. Find Macro
  641. convert a formula into a macro
  642. Options at Start up
  643. VBA to address first visible cell in Column "D" after filtering
  644. Grouping a data field in a pivot table
  645. Inserting row/Column
  646. Filtering drop down lists
  647. Combining Text and formula
  648. linked cells in excel on a shared document
  649. how to disable copy paste buttons from from edit menu
  650. NOW
  651. excel time sheet
  652. Can adobe files be converted to Tif?
  653. Formula Help
  654. Find/Replace *
  655. i need a macro to read blank cells
  656. Custom Number Format
  657. mail merge from XL to word
  658. updateable constant?
  659. VBA macros for web pages
  660. Area Lookup from Radial button
  661. Dates and formulas
  662. Does anyone know of a free pop-up calendar for use in Excel?
  663. Creating Sheets in a present Xl File
  664. Downloaded a template and want to stop feedback from popping up
  665. If function
  666. Summary sheet in effecient way
  667. why share workbook suddenly stop working
  668. Naming a range during macro execution
  669. converting hex values to negative numbers
  670. Mail merge
  671. Mail merge
  672. How to sort Khmer Unicode?
  673. Truncated text using vlookup to linked worksheet
  674. Excel 2003
  675. V look up and data that goes out when copied in range
  676. Calendar control
  677. Tough one
  678. How can you format a date in the header/footer of Excel sheet
  679. Scroll bars
  680. Conditional maybe IF question
  681. EXCEL 2003 VB
  682. Count cells with numbers and ignore cells with errors
  683. Separating text
  684. Macro Data Input
  685. ?Formatting cells?
  686. Any function to determine the smallest common factor from a list?
  687. Macro to run relative to current selected cell
  688. Display characters present after a specific character
  689. list all the files on my computer
  690. Losing Original Cell Format when pasting in cells
  691. How to lookup a value in excel?
  692. Formula
  693. 0 instead of false
  694. time v cost calculation in Excel 2002 (XP)
  695. Time Code in Cell format ?
  696. 17 digit number not inserted
  697. Looking up a variable in one worksheet and copying information from another column to another worksheet??
  698. IF formula question
  699. averaging data
  700. duplicated values
  701. How to filter only the first level in the hierarchy
  702. run macros on protected sheet
  703. Task Pane in Excel
  704. Conditional Formatting
  705. run macro on opening
  706. my.xls
  707. Use one array as a reference for another
  708. Conditional Formating based on a different cell
  709. Recognizing 2-digit years
  710. COnfused about the addtion formula...
  711. boxes with information to enter
  712. Separating a chart from another on same worksheet.
  713. Couple of Office 2007 questions
  714. Inputting cell value from source cell based on value in adjacent cell.
  715. Where can I find list/table of functions/formulas
  716. how can I change input statement to show only stars for password ****
  717. Combining Information from Multipole Worksheets into One...
  718. Excel won't start. Previously worked fine
  719. A simple way to change several cell refs to absolute ?
  720. How can I create a document that can be wrote on but not saved?
  721. How to search column, copy row, and copy to another sheet in same
  722. Looking for Construction estimating spreadsheet
  723. Filtering
  724. How to call a cell ?
  725. Adding certain numbers based on...
  726. Custom Key word
  727. DV Lists that update each other
  728. Shortcut Key --- A Challenge
  729. Course Graders
  730. IS THERE A WAY TO CLEAR WORKSHEET EVENTS USING ANOTHER MACRO
  731. Alternate row shading with a filtered spreadsheet
  732. Last non-blank cell in a column
  733. Deleting Macros
  734. How to clear a value but not the formula?
  735. How do I delete several hyperlinks in an Excel spreadsheet?
  736. Analysis Services add in - features lost in 2007
  737. Adding numbers based on partial text in adjacent cells
  738. text entry
  739. Remove Year from Date
  740. can we do this with solver
  741. Modify Custom Toolbars in Excel 2007
  742. The count on my pivot table is wrong - HELP!!
  743. Assigning number values to text strings
  744. Time Formulas
  745. conditionally join rows
  746. sumproduct
  747. Overcoming Nested IF limits
  748. Print all tabs to pdf when some have been added w/o breaking file
  749. if a1=b1=c1=d1....
  750. sumproduct
  751. Find and Replace without changing font
  752. How do I get a graph to make my entries equal 100% in aggregate
  753. RE: Data Upload from Excel to SQL Server
  754. cannot paste from clip board
  755. Help! Find Closest Coordinate Match
  756. Combining files in Excel
  757. Keyboard Shortcuts
  758. Individual cell selection in a range
  759. Re: Remove function
  760. Including today's date
  761. VLookup on same last names - different people
  762. Can you calculate a formula in the same cell where you enter the d
  763. Counting cells with duplicate values
  764. Removing trailing spaces in a spreadsheet
  765. Excel VBA Question
  766. Add-Ins and Multiple Users on 1 Computer
  767. Formating cells - "Too Many Different Cell Formats" Error
  768. How to show heading on page 1 only in Excel.
  769. Min function without zeros
  770. Include the info from 2 cells
  771. How can I keep zeros in the beginning of a number in excel
  772. Function to SUM only Subtotals
  773. Delete rows
  774. shared files individual user views
  775. custom format cell with text and numbers
  776. Creating stats
  777. Text to colums
  778. Pivot Table Report - HELP!
  779. mandatory field
  780. Formula Save Error
  781. I want the cell to be blank instead of zero
  782. Excel application publish to web?
  783. Activating a Worksheet?
  784. How do I do a multiple IF
  785. Excel: Blank Screen Stuck in Wierd Print_Area mode
  786. Macros - copying macros from one computer to another
  787. Not able to export data from IE6,7 to MS Excel
  788. PMT Function Help
  789. Creating Sheets from a List
  790. if based on cell formatting
  791. I need a formula
  792. Excel 2007 - Secure workbook with password
  793. Font and File Size
  794. Display size different.
  795. Verifying value of a cell
  796. How do you extend the trend line?
  797. Are double lined worksheet tab titles possible?
  798. How to get chinese fonts in excel97
  799. Help with Mulitplying Cells
  800. how do I sort a list a1 to a15, b1 to b15 etc
  801. Excel Advanced Search (Feature/Option/Plug-in)
  802. VLOOK UP
  803. i want default as Zero in date format cell
  804. format cells to display 20 long sentences in a single cell
  805. Count Cells Mutiple Criteria
  806. VLookup a given critera and return a value without duplication
  807. Macro to insert a formula based on a range
  808. Error in cell function
  809. create a formula in one sheet that would read data from separate sheet automatically
  810. import/export data from a workbook
  811. Referncing the current cell name in an Excel MACRO
  812. Count Cells Using Multiple Citeria
  813. 1 workbook, 4 worksheets, want to add rows in same place in all WS
  814. Wrapped Text Not Visible - Usual solutions don't work
  815. Conditional Formatting - dates
  816. delimited copy and paste
  817. Code To Refresh Query Table
  818. Importing text-files
  819. Using AutoFilter + sumproduct formula
  820. Importing external data 'won't fit' error
  821. Pivot Table
  822. Sheet/Cell References
  823. Macro: Filter Multiple header then extract to Multiple Files
  824. Why does excel turn numbers larger than 15 digits to zero?
  825. Pull parameter from worksheet for External Data Query to SQL Datab
  826. pick highest number from a list
  827. Drag with right mouse button acts like pen
  828. Creating a Custom Form
  829. Translate Column Index Num to Letter
  830. How do I write a superindex in excel? (e.g. for square meter m2)
  831. Change the Data in a Cell
  832. Auto naming worksheets
  833. Counting dates within a specified range
  834. Macro assigned to a button
  835. When I create a link from excel to visio it does not update when
  836. Help I need to know how to write a simple formula, not having any
  837. Reorgainizing Data
  838. Setting Range Dynamically
  839. Excel 2003 Save as Web page... imported into prior Excel versions
  840. Sort of a print problem
  841. Break phantom link
  842. Change Tracking by Windows Username
  843. FILE AUTO-RENAME
  844. Formatting Imported Text
  845. Bar Charts using data from =sum
  846. Office 2007 Lotus 1-2-3 Export
  847. Scientific notation in text cells
  848. Parameter Query Cell substitution
  849. is it possible to have an excel document as desktop?
  850. how can I limit the number of rows and colums
  851. How do I apply conditional formatting to even or odd numbers?
  852. How do if create IF functions using text as the logical test?
  853. Using Postscript and OpenType fonts in Excel
  854. Selecting multiple items from a drop down list
  855. formulae
  856. Covert string to date, etc
  857. Milo: Getting warning about Macros
  858. Increase visible cells when they are more 1000 using autofilters
  859. diferencia de fechas
  860. Validation ... (Days 01-09 only)
  861. Soma com parcela variável
  862. EXCEL GLOBAL DATE AND TIME STAMP
  863. duplicates in validation list combobox
  864. Right-to-left command
  865. Column headings
  866. DATE Question
  867. Dates import
  868. workbook windows disappearing!
  869. Reference Source Deleted & VBA ref adjustments
  870. Addind cell together with a rest.
  871. how can i "=MROUND(J33,50)"
  872. Combo Box and Macros
  873. Format multiple Worksheets Simultaneously
  874. Need help with weighted average
  875. Formula
  876. Cntrl-end goes beyond end after rows have been deleted ?
  877. Printing Multiple Worksheets on one page
  878. Visual Basic 6 - String Reading
  879. Lost ability to refresh external data
  880. my personal.xls file is causing problems
  881. Duplicate A5 worksheet with header & footer onto an A4 original
  882. Change colour of cells when content is altered/changed
  883. protect my .xls sheet from being “modified” and “saved as”
  884. Forms Command Button - Removal
  885. Cálculo no Excel sem mostrar colunas ocultas
  886. compteur de version
  887. Advanced Filter: Inverse
  888. Increasing number of unique entries in the drop-down list
  889. Discounting from a table of values
  890. I want to change the name of (52) worksheets.
  891. Formula?
  892. Error
  893. Excel Error messages when making lables
  894. replace or substitute a letter for a specific number
  895. Creating a Quiz...
  896. Repeat column headings
  897. Macro - Inserting text to a cell already containg text
  898. In making labels using Excel database I get the message "ODBC Exc
  899. Pivot Table Percentages
  900. Pivot Table Row Totals
  901. How can I have 45 mulitple sheets with 45 different acess rights to view to each sheet
  902. in excel i want to make a sheet unprotected from the protection
  903. error message - no clue what it is about
  904. Inserting pictures into worksheets
  905. State Map
  906. Colour index
  907. How to delete all the blanc cells in a worksheet and shift cells l
  908. Filling formulas
  909. Multiple Functions
  910. Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1
  911. progress billing / billed to date formula
  912. VLOOKUP
  913. Printing Macro
  914. check box
  915. Insert PDF from MapPoint into Excel or Word
  916. Yet Another For without Next Error
  917. absolute paste link
  918. Hard CR in a Cell
  919. formula for column letters
  920. VLookup for Conditional Formatting
  921. Office 2007 trial to include Excel services
  922. VLOOKUP not finding adjacent columns
  923. Excel: Combine and match two data
  924. Multiple Worksheet Protection
  925. replace letter of alfanumeric value by a specific number
  926. Set print area using macros
  927. Automatic printing
  928. Saving database access log in and passwords
  929. Want to compare EOY results
  930. Using SUBSTITUTE multiple times on single cell of data
  931. Help
  932. Can I create Multiple passwords to edit multiple ranges?
  933. Connecting an excel spreadsheet to a generic letter in Word
  934. Reformat of a table
  935. Re-Using Custom Lists
  936. checkBox help!!!
  937. Delete entire row if
  938. adding
  939. Automatic row insertion
  940. auto increment
  941. Converting equations into easy-to-understand words?!
  942. Lookup error
  943. need loan template that automatically calcs late fee
  944. Number Entry in Excell
  945. Formatting problems
  946. formula is text, not resolving to an answer
  947. date problems
  948. searching then averaging
  949. djasmahan
  950. SKEW and KURT functions
  951. Tracking Linked Cells
  952. Excel
  953. How do I divide a cell into two cells?
  954. Copying to blank cells
  955. ATP in XL12
  956. AUTO COMPLETE NUMBERS
  957. SUMIF need to add another criteria
  958. Hidden Columns No Longer Hidden after Copying Worksheet?
  959. Problem copying dates
  960. custom lists and custom formulas?
  961. Fields change order from MS Query to Excel
  962. Formula Question
  963. String Manipulation within VBA
  964. How do you change the font on workbook pages?
  965. worksheets acting perculiar...
  966. Formula to Add only the BOLDED numbers in a column.
  967. can i multiply digits of a number by a constant in excel?
  968. Automatically switching between worksheets.
  969. Pivot table - total sell price
  970. How to make a function in a cell update
  971. formula
  972. How to force a cell value to change if Linked cell moves?
  973. Page Setup Printing
  974. Match Last day of this month to last day of last month
  975. Pivot Table Value Filter
  976. Field not visible in ptable field list
  977. Printing XML Maps
  978. Finding last appearance of data
  979. Interactive Forms
  980. Sumproduct and adding the total time in a column
  981. Excel 2003 Subtotals and Grandtotals
  982. how do i design a template with one to many relationship in excel
  983. Excel 2002 - Pivot Table : Can I divide instead of sum ?
  984. Locking Cells
  985. Excel 2002 : How to get the difference in a block of data ?
  986. Macro to Find and Replace
  987. Clear BorderAround in VBA
  988. Nested Function
  989. Multiple Names in refers to field of Define Name
  990. Formula Sometimes Working Sometimes Not
  991. Sugges a formula/function
  992. Data Validation problem
  993. Why are screen and print column widths different Excel?
  994. FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA
  995. Highest, Second Highest , Third Highest and so on
  996. Compulsory Cells based on Condition
  997. Insert-Name-Define limit ?
  998. find partial text contained in another cell
  999. Destination workbook formulae become #VALUE!
  1000. Matching values in two columns