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. = (other sheet, but transposed!)
  2. What calculation can I use to find income on a fixed investment?
  3. Pivot Tables and Column Labels
  4. Averages from different worksheets
  5. Sales Taxes
  6. Sharing workbook, show last user change?
  7. Buttons for ", & ?
  8. Linking a cell to the previous tab?
  9. Sort and print .pdf files into one .pdf document via VBA code?
  10. Linking to a worksheet in a separate workbook
  11. Returning To Previous Worksheet - Help with sebastienm's code
  12. Saving data in Excel
  13. Formula Conditional formatting on numbers
  14. Creation Date
  15. using an IF function for a total
  16. date format help
  17. can numbers be assigned to values, replacing values for numbers
  18. excel 03- sheets stay grouped even when I ungroup
  19. Sorting Sorting Sorting
  20. Customize Icons In Toolbar
  21. Clipboard in Excel
  22. How do I do this?
  23. Excel Spreadsheet Not Saved Dialog Error
  24. Recalculation of formulae disabled
  25. conditional drop down list
  26. Replace Function
  27. Pictures not showing or printing
  28. "word unable to open data source" message when trying to do mail m
  29. Managing Data in Cells
  30. How do create a formula to add IP addresses?
  31. pivot table data display in cell
  32. getting font color to stay black!
  33. After 2 days of frustration...Formula
  34. Sumproduct Average
  35. Go To Dialog box
  36. Input original save date
  37. Multilple linked Cells with Combo box
  38. Lining up data from concatenation
  39. Is there a way to sort by format in Excel?
  40. Subscript shortcut?
  41. Best way to learn/use macros?
  42. #REF in Sheets that refer to Pivot Tables
  43. Count Function 2 Columns
  44. save workbook created from templete to a specific folder
  45. scheduling problems
  46. How can I save a file in Excel 2007 beta 2 as a .dbf extension?
  47. Format entire column with Calendar activex control?
  48. COUNTIF statement with 3 criteria checks
  49. Lookup multiple workbooks
  50. Help me Get the Cell Contents Bar Back Plz
  51. Globally change print settings for several worksheets at the same
  52. help with value in formula
  53. How do I turn off the autoformat that converts 1-0 to Jan-00?
  54. I copied over a previously saved copy but it didn't save the info
  55. using countif to add dates
  56. Hyperlinking e-mail addresses from a listing to show a subject lin
  57. How can I obtain a calendar that will go from Jun 06 to Sep 07?
  58. Excel slow recalculations
  59. auto sum font
  60. Frequency questio
  61. conditional formatting on words
  62. I have 5 columns of data and want to create combinations based on
  63. Hit email excel sheet, instead of print, how do I get normal view
  64. Max columns?
  65. How do I create a link between columns from a data chart?
  66. exporting chart
  67. Vlookup
  68. Change Year Date In A Formula Throughout The Spreadsheet
  69. Programming (macro) breaks due to translation
  70. Sorting a List
  71. Moving Between Worksheets Using Same Cell Address
  72. Go to last cell in column
  73. Source for NYSE data
  74. Assistance required
  75. linking worksheet information
  76. Help with Macro
  77. Excel features that might replace these Lotus macro tricks?
  78. Conditional formatting grayed out?
  79. I am wanting to set up a template for customer monthly statements
  80. Pivot Table subtotals
  81. Excel should allow tab groupings.
  82. How can I replace multiple data in excel ?
  83. Dynamic Table
  84. how do I fix the column width?
  85. delete if
  86. using conditional formatting to mark repeated names in list?
  87. July - UK Excel User Conference
  88. Remove all macros and objects in Excel, Save and Quit
  89. Help on formula
  90. Pivot Table Formula
  91. format plan into tables
  92. The clipboard althouth available is not working, why?
  93. Excel Format cells Alignment Orientation 180 degrees?
  94. Counting Question
  95. Can a creation date be added to a footer
  96. macro to bold number of chars from end of a string
  97. Inserting Dates
  98. Creating and Controlling a User data Entry Sheet
  99. dates problem
  100. Print Preview Macro
  101. question for indexing a table
  102. cell content in header/footer?
  103. Insert csv data into polished xls file
  104. How can I plot data in different columns to same curve
  105. Want to run two macros without errors
  106. two macros
  107. Customise the location of the header and footer of excel
  108. "Go To" dialog box
  109. cursor focus in excel
  110. Excel
  111. Drop-down Menus
  112. Check if cell entry belongs to a name list-how?
  113. backround text
  114. How do I alphabetize sheet tab names?
  115. Using foreign characters
  116. Cell borders when converting 123 doc to xls
  117. Re: How do i enable "Group" & "Ungroup" in a protected sheet
  118. Offline office help will not work in excel word or visual basic
  119. Excel/Outloook query
  120. Can you use a vlookup to bring in a picture?
  121. Adding values for multiple worksheets
  122. "Cannot access read-only document" (I get this error when I try to open an Excel file)
  123. Query counting cells in a row that exactly match cells in another
  124. World Cup bracket help
  125. Can only print ~3 pages from Excel to Adobe PDF
  126. Excel Text Import Wizard - bug
  127. HYPERLINKS IN EXCELL 2007
  128. format part of text in a cell?
  129. Bingo Ball
  130. Pivot Table Query
  131. What causes this message?
  132. Cronological sequence formula
  133. Formatting Footer
  134. Using Pivot Table Values
  135. Excel - Remove Formatting Error
  136. Fill cells if adjacent cell match criteria
  137. Cell only updates when I go into formula bar
  138. Pivot Table - Compare 2 fields?
  139. Using 'return' button in Excel for Macs
  140. using the formula Average(start:end!b4)
  141. application.run doesn't work
  142. Filter (triangle color)
  143. Sheet activation
  144. Selecting subsets using combo boxes or list boxes
  145. Importing data file
  146. I need multiple header rows
  147. Excel does not open a basic worksheet
  148. Annoying automatic date-formatting on import... how to remove it?
  149. Smart Tags in Excel fails to recognize stock symble OI.
  150. COUNTIF formula multiple text exclusions
  151. colour index matrix
  152. Pivot Tables - In Depth
  153. Import external data from AS4000
  154. is there a formula for calculating daily compounding on a CD?
  155. IF function
  156. Save as web page (Maintain formulas)
  157. Switch for no spreadsheet
  158. Status Bar
  159. Can't enter break mode at this time
  160. Merged Cell Conditional Formatting Borders
  161. Nesting SUMIF
  162. Sorting Data
  163. A challenge for an Excel Master...
  164. excel form not functioning correctly
  165. I am losing comments when i merge work sheets? Any one know how t
  166. Refresh Pivot in Locked Sheet?
  167. Check box - true/false - i'd like a third option n/a
  168. Excel row height beyond the 409 limit
  169. Pop up MsgBox upon opening Excel File
  170. Finding and marking duplicates
  171. counting line by line matches of 2 columns possible in excel ?
  172. excel average function
  173. Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e
  174. Reverse column order with a macro
  175. Using a ListBox selection to query a database
  176. PRINT OUT
  177. auto date annoying
  178. Where is Solver
  179. Copying text from a text box
  180. Matching a Value with a list
  181. REferencing a cell from another sheet... and taking it's coplour with it?
  182. Excel 97 hide unhide problem
  183. sorting/grouping positive and negative numbers
  184. Where can I find a tax table (for reference) template for Excel?
  185. Turn off header and footer from auto appearing in a new worksheet.
  186. Can I sort a column of #s Rt to left? in a worksheet
  187. Conditional Formating a Block of Cells
  188. AutoSize Command
  189. High CPU in Excel
  190. Customize forms in Excel
  191. Conditional Format - Format Transfer To Chart
  192. Returning MULTIPLE values with Index and Match
  193. excel should let me change the menu than appear when right click
  194. look across row - pick highest value - take aplha code of column
  195. Pdf convert to excel
  196. How do I link part of an Word document into an Excell workbook?
  197. Autofill upwards!!!!!
  198. Conditional Formatting help.
  199. Getting only unique values.
  200. download from external source
  201. countdown days,hours,minutes,seconds to a specific date
  202. Inserting dates
  203. COUNTIF and OR
  204. Sorting every other line
  205. Lock all cells?
  206. Coloring rows of cells
  207. Date
  208. Macro Save As
  209. Can I use Excel, opening and editing files, online?
  210. Problem with Grouping Columns
  211. Order of calculation
  212. Filter info in Status bar - Other workaround?
  213. Character limit when printing
  214. Excel 2k Pivot Table refresh scenario
  215. Conditional Formatting
  216. macro to hidden worksheet
  217. Forumla
  218. Pivot Table Chart
  219. Excel Macro(s)
  220. Formula which changes color
  221. Caption Property
  222. help in countif formula.
  223. Logical Format showing 0/1 and not True/False.
  224. How to roll up the group of lines?
  225. Advanced cell validation help needed pls
  226. Copying word tables of different column width to excel.
  227. too much info in one cell in excel how do I make it 2 lines?
  228. Excel
  229. help
  230. help
  231. inverting the error function
  232. Excel Problem
  233. help in using count if,,
  234. Can't Download Data in Thai Script
  235. changing a password protected file
  236. Schedule help
  237. Format sequence for phone numbers?
  238. Timeline graph?
  239. need formula for 80% and above
  240. Data table is not updating correctly in excel 2003
  241. How do I make a copy of a entire workbook?
  242. Datestamping a file created by a macro
  243. How to make a living "growth" barometer (will go on a web site)?
  244. Save Excel 2007 as Web Page - no interactivity?
  245. Help With Formula
  246. Need cell formulas to return the day of every Monday in a month based on year entered
  247. Combo Box Help
  248. Help with a tricky formula......
  249. How to save file in a macro taking new name from cell contents?
  250. Distances between Postal Codes
  251. If Formula
  252. Preventing Duplicates
  253. employee payment statement form
  254. Macros in Excel 12
  255. "Can't Enter Break Mode"?
  256. Ribbon vs. Menus
  257. Calculate number of weeks between dates in Excel 2000
  258. personal.xls doesn't launch in COM
  259. formatting dates
  260. Userfrom problem...
  261. Viewing Excel sheets on the web
  262. What formula do I use to get individuals ages from their birthday
  263. Calculate multiple results from multiple input values?
  264. Formulas
  265. copy pasting dates from one sheet to another
  266. Modifying links without updating values..
  267. Using the "count" function..
  268. Please help
  269. How to lookup values in Access db?
  270. add/subtract dates problem in Excel.....
  271. autofill
  272. How do I calculate the number of business days?
  273. Disable Allow ActiveX prompt
  274. How do I append data to an Excel workbook using a template?
  275. Logging into a website
  276. Goal Seek is REALLY annoying me...
  277. Need to convert years into days
  278. Formula resulting in 0
  279. Column Headings Numeric
  280. Is it possible to past objects on protected sheet via linking?
  281. HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL?
  282. PLEASE SORT OUT THE CALCULATION SETTINGS
  283. Checking if you have a network connection
  284. Summing between Range
  285. Adding and deleting rows with formulas ****Need Help****
  286. Subtotal counting formula in cells
  287. Autofit didn't work to adjust row height to fit wrapped contents
  288. Excel 2003 freeze panes won't freeze top row only
  289. RE: Need conditional statement to paint a cell
  290. Format>Row>Autofit
  291. create macro to copy
  292. Return value in cell above the reference
  293. Is there an easy way to...
  294. Sumif Function
  295. Excel Security
  296. Linked file returning #VALUE! instead of data
  297. ADO programming in Excel-VBA
  298. How do I change the default font color in Excel?
  299. Pivot table page fields add values previously deslected
  300. LOOKUP Question [again!]
  301. Auto Fill, Every other column
  302. Can you copy custom views to another workbook?
  303. Comments
  304. Inserting Dates
  305. Excel 2007 BUG UsedRange/LastCell differences with Excel2003.
  306. Eval function with sum
  307. Finding matching fields accross multiple worksheets
  308. Opening Workbook resets calculation to automatic from manual etc
  309. any solution to the "too many cell formats error" in excel?
  310. Count Function
  311. Count Function
  312. How do I resolve number on screen printing as #REF
  313. Excel sheets
  314. Date problem
  315. sum if problem, trying to find best solution
  316. LOOKUP Question
  317. Printing from different locations
  318. Problem with notes query in Excel
  319. Cell formatting
  320. Cannot save external data into file excel system show not respondi
  321. How flip a selection before pasting - Paste special
  322. Checking Data in 2 spreadsheets
  323. turn off beep
  324. Excel VBA Tutorial
  325. Excel 2003 cells not linking
  326. Conditional formating
  327. Need spreadsheet examples of Profit max and cost min
  328. excel close everytime I receive an email with lotus notes 6.5.5
  329. automatic footer
  330. Excel 2007 Beta2 - Keyboard shortcuts
  331. assign macro to a lise
  332. Cutting every other row from a spreadsheet
  333. New Forumula Issue
  334. Customise Header and Footer
  335. Conditional formatting
  336. Can I do it without using macro?
  337. Excel - long paragraph across multiple cells
  338. How do I count crossing zero in a column of integers?
  339. networkdays vs days360
  340. How do I find a list of dates a file has been modified?
  341. Are there Rich Text Text Boxes
  342. Change Ribbon Tabs by hovering
  343. Question about different paste area sizes
  344. How do I change formula results by changing the text color of the
  345. percentages
  346. Excel font size changes
  347. Cells to be mandatory fill have a formula in it
  348. Deleted Columns replaced with formatted columns
  349. "Protection" AND Insert Worksheet greyed out
  350. Trigonometry in Excel
  351. rounding numbers in XL
  352. Unique Values
  353. excel * word won't print
  354. Improvement for office
  355. Printing cells with conditional formats & formulas
  356. Creating a concatenate text list by referencing an array
  357. Listing the names of your worksheets
  358. When I type "13" the spreadsheet shows "14." Possibilities?
  359. clickable URL in excel?
  360. Need to know how to write a calculation...
  361. Using macro to copy a part of a cell content to next cell
  362. Exception from HRESULT: 0x800AC472
  363. taking data from multiple cells and displaying in one cell
  364. Create a database of past and present customers
  365. Check for existence
  366. Startup
  367. Pivot Table Format
  368. Including the modified date in the footer
  369. Excel 2007 Analysis Toolpak
  370. when i push the "end" button the curser always goes to cell S47
  371. prompt for query refresh criteria
  372. Displaying Unix time as date and time
  373. download Microsoft Map for Microsoft Excel
  374. Pivot Table - Grand Total for Rows
  375. Text Box
  376. Can't open file in 2007
  377. Pivot Tables keep corrupting -- Office 12 beta
  378. drop down list in a cell
  379. Strange vlookup problem
  380. sorting contacts
  381. Working with Random Text & Combining Cells
  382. Cannot replace ~ in Excel
  383. Data Valadition window font size
  384. Excel closing question
  385. Defining a Text field based on its condition
  386. Sound alert
  387. I want to copy the active workbook name to a cell...
  388. Removing holidays and weekends , networkdays
  389. Removing holidays and weekends , networkdays
  390. how do you get a formula to not update when rows are inserted
  391. Go to cell referenced in a formula
  392. Boarders in 2007
  393. can't figure out LOOKUP with 2 variables
  394. Gridlines - Different Scale
  395. how can i hyperlink multiple cells to one file?
  396. How do you insert rows into multiple sheets in a workbook?
  397. Index, Match, Sum??
  398. How do I reduce the no. of rows & columns in a worksheet ?
  399. Open .csv file
  400. Formulae or format to change a number "1" into the word "one
  401. Can I change the names of multiple cells at once?
  402. Printing 2 sheets on 1 page
  403. MS Excel 2000 - Change PivotTable DataSource (Access2000 database)
  404. need 2 create refernce in formula thatpoints to cell in other tab
  405. How do I merge one cell into two cells?
  406. Pivot Tables - Grand Totals
  407. Recently Used Files List
  408. Text Box Length
  409. "end" + "down" commands not working
  410. CSV file into the Excel
  411. Why can't I merge 2 cells into one?
  412. PlS Help ABT STOCK TRACKER
  413. Can't open Excel workbook. Marked " cannot be accessed.
  414. Excel Solver Constraints
  415. Count number of values equal to MAX of a column
  416. Pausing a Macro
  417. Can word wrap and merged cells auto row height properly in Excel
  418. Protecting a worksheet / workbook with macros
  419. assign a macro
  420. Excel 2007: AntiAliasing for Charts
  421. Help displayed while hovering over a button
  422. Protected worksheets
  423. HOW DO I HIDE FORMULA IN A CELL
  424. SHIFT+ALT+ARROW(up/down) moves data in word.How about excel?
  425. workbook opens "empty"
  426. Pivot Table - Sorting on Sum field and filterin
  427. Copy to in Adv filter deletes data in lower rows
  428. cross-reference data from one file to another file
  429. Preventing error!!!
  430. Installation of Office 2007
  431. Installation of Office 2007
  432. Adding a Dos command in EXCEL
  433. How do I SAVE EXCEL FROM COMPUTER TO MOBIL PPC
  434. Opening a hiperlink
  435. Extracting data from a cell - please help
  436. Protect Execl data for different users.
  437. Excel Iterations? Conditional Operations?
  438. quick access bar
  439. Mail as body
  440. Print Preview
  441. How to import data from daily reports (excel) into excel database
  442. formula issue
  443. Voip Updated Howto,Voip AT Home,Voip Phones,Voip Conference Calling
  444. Macro Help Please?
  445. Hyperlinks
  446. How do I set up a default footer to be used in all Excel sheets
  447. How do I get Excel to open each document in a new window?
  448. How can I copy/paste a hyperlink address without the link?
  449. Transfer Email addresses from spreadsheet to email address book
  450. Paste under selected cell
  451. Cannot Load Library "LXBCPRP.dll using defualts error 126
  452. Link cells in Access to Excel using VLOOKUP
  453. COUNTIF, dates and blank cell criteria
  454. How do I import data from a closed Excel Spreadsheet?
  455. tallying a total dependant on contents of another cell
  456. Enabling automatic refresh
  457. Project In Los Angeles
  458. How can I Run a query from VB macro with out affect current data in the same sheet?
  459. Error in Formula
  460. Excel 2003- animated gifs won't work?
  461. Vlookup to Return a Range of Data
  462. Printing 2 worksheet duplex on same paper
  463. use VB code IF to automate filling in 11 columns
  464. printing worksheets
  465. automate a cut and paste of data from one work book to another
  466. My pointer no longer changes when moving around the worksheet
  467. SUMIF with two sets of criteria
  468. in order
  469. Autoselection of Spreadsheet for liking
  470. How to get more than 3 rows in Conditional Formatting
  471. Solver in excel 2007
  472. Absolute Functions
  473. Can text be full-justified within a cell?
  474. Neater "=if "transaction
  475. Excluding selected cells in excel
  476. Newbie: VBA? Macro? Please Advise...
  477. calculate hours
  478. XCEL 2 calculate week or bi-weekly accel. mortgage payment
  479. How to count data in 2 columns
  480. When I insert autoforms in Excel2003 they are not shown
  481. Change Cell Color when another cell is selected
  482. Excel cannot connect to web
  483. Making for adding and naming a new sheet
  484. how do i convert standard time format into seconds?
  485. Pasting HTML into a single cell
  486. I have lost ability to open xls spreadsheets sent in emails
  487. Sumproduct - Condition based on lookup of a Lookup
  488. Function won't return value in merged cells
  489. Average
  490. Easy macro issue (I think)
  491. excel 2007
  492. sorting help
  493. Excel Query
  494. Excel document was saved to word in error how do I get it back
  495. Sorting information into lists
  496. holidays
  497. Sumif()?????
  498. Importing Outlook Alias into an Excel 2003 macro
  499. More column shifts ...
  500. ungroup impossible using Excel 2003 ...
  501. Importing txt files one character per column/row.
  502. Cannot Shift Object off Sheet
  503. formula, move to previous cell when the current cell=0 or empty
  504. Why won't this simple VBA script work in excel 2002?
  505. Printing
  506. Cannot enter numbers in Excel 2003
  507. FREEZE PANES
  508. can i attach the same comment to different cells
  509. Relating fields
  510. Office 2007 Beta
  511. Excel 2007 Crashes
  512. funkcja prawidłowo obicza wynik formuły ale w komórce pokazuje wy.
  513. List for country names
  514. autocorrect
  515. Macro: Find and replace
  516. how can I use "filter" but keep "title" row in sight?
  517. increase font size in status bar: excel sums
  518. formula's
  519. negative numbers
  520. FillAdjacentCell.Formulas = True in User Form
  521. converting text into hyperlinks
  522. If you delete the contents of a cell in a worksheet in a group, w
  523. All variations of a set of numbers and letters
  524. #### in cell instead of date
  525. Search from highlighted cell
  526. Runtime Error! R6025 -pure virtual function call
  527. what is the key word for merge cell?
  528. How do I move cursor in an active cell without using delete/backsp
  529. why are my columns labelled with numbers?
  530. Mouse Pointer in Graph
  531. Multiple cells to one
  532. VB code to set iteration
  533. paste by date
  534. Pasting issue
  535. Finding errors
  536. Finding Smallest Value
  537. look up more than one cell eg grid
  538. wrong font
  539. Application.SendKeys "%{down}"
  540. Can't Figure what I did
  541. Boolean 0/1 instead of True/False
  542. external web query? (sites that require login)
  543. Numlock
  544. worksheet change doesn't always work
  545. Hyperlinks or buttons
  546. linking worksheets
  547. Advanced Filter problem
  548. Protect excel sheet and still copy text or object w/o unprotectin.
  549. How do you change the year but not the month automatically?
  550. Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha
  551. Date-related problems - max and datevalue
  552. calculating breaks
  553. Filter like data..help please
  554. How do I create a work schedule in Excel?
  555. Making a second column from data in first column
  556. find value in specific row
  557. Excel 2007 print preview
  558. Excel 2003 figures to words
  559. Amalgamate Several Worksheets into one file thru Data import
  560. Reusing grouping of non-adjacent cells
  561. Updating Links
  562. Concatenate Four Columns With Seperators
  563. Auto populate dates
  564. Referencing a 2nd file
  565. How do i round up the sum of a formula
  566. Insert Space
  567. How do I print a workbook a continuously (no page breaks)?
  568. How can I read a PC Excel file on a MAC?
  569. excel
  570. trouble with advanced filter
  571. Message box with no buttons
  572. Pull values from each .xls file in dir
  573. Page 1 in background
  574. What is the syntax for using the "IF" condition with an autofilte.
  575. about drop down list
  576. How can I get excel to autofill the next column?
  577. Excel Annualized Return Formula
  578. Soft-coding document name?
  579. Create a scroll bar in a Cell in Excel 2003
  580. Dealing with minus numbers in formulas
  581. Copy Worksheet from one Workbook to another Workbook
  582. Question about Copy/Paste functions
  583. formula to round up to nearest 1,000
  584. Who is missing ?
  585. drop down list issue
  586. Can parital cells be underlined w/o inserting blank columns?
  587. Page file usage
  588. How do I backup all of Excel and file content to DVD?
  589. how do I get a formual to stay constant in vlookup in Excel 2003
  590. Display data from cells based on a formula
  591. An excel file on the web as an reference
  592. time and resource mgmt
  593. Excel macro
  594. Macro on entry
  595. How do I highlight changes to an Excel 2003 spreadsheet?
  596. I need to print only odd pages & then even pages
  597. PLOTTING/CHARTING Help!
  598. find data in adjacent cell
  599. can i download excel software for windowa xp pro?
  600. is there an auto-numbering tax invoice templete for excel
  601. Short cut Key for NAME BOX
  602. theory of biorhythms
  603. how do I insert the address of a selected cell into a fixed cell
  604. How do I lock all cells in a given row together to one another?
  605. date in mm/dd/yyyy
  606. how would activate the previous sheet in macro
  607. business prices were sent but I cant view; dont have excel, what
  608. How do I get selected text within a cell to remain bold in excel?
  609. WHERE IS THE AUTOCORRECT OPTION IN EXCEL 2007?
  610. How do I fix a date format error in Excel?
  611. help with index to return particular cell value
  612. Note to Admin
  613. how do i add a word document into an excel spreadsheet?
  614. loan amortization- how can I enter 4.75 years? no a whole number
  615. {=COUNT(IF(etc))} question
  616. Importing data into Excel
  617. Password protect a sheet without Macros
  618. Advanced MS Excel charts with data optimization
  619. Search in excel by date located in a cell
  620. scrolling settings
  621. Method 'Range' of object '_global' failed
  622. i am missing work sheet menu bar
  623. Excel should show 10^9 (9 in superscript) instead of 1.0E+9
  624. VLOOKUP - more than one return required
  625. Web query - Unable to open
  626. Conditional Formatting Top 10 **HELP**
  627. Copy columns values into separate columns
  628. unique filter results in some non-unique records.
  629. Horizontal Filtering
  630. How do I import several csv files into one excel worksheet?
  631. Why do minimized workbooks in Excell not show file names?
  632. Why do minimized workbooks in Excell not show file names?
  633. Not sure if explaning this right but I'll try
  634. Cannot unlock excel
  635. AutoFill
  636. Date to TEXT. NOT to sequential serial number
  637. Read Only in Excel
  638. finding a date/time in a list that is closest to an existing date/
  639. Creating a 4-step filter
  640. LIBOR Days
  641. Excel Datalist functions / lookup summary
  642. conditional formatting glitches
  643. AutoIncrementation
  644. Separating Data Into Multiple Columns
  645. Conditional Formatting Bottom 10 with "ties"
  646. Subtracting dates into weeks...
  647. VLOOKUP
  648. Do the values in a range of cells include all members of a set?
  649. Converting text to excel
  650. data between worksheets
  651. Unknown # cells need to be in one column - Macro
  652. Hide a specific number in a cell
  653. forecasting and linking to a data range that is fluctuating
  654. Saving worksheet in new file with date AND cell value as file name
  655. macro for pasting
  656. How do I enable my mouses Horizontal Scroll in Excel 2007
  657. Value in cell adjacent to max of column
  658. Have a cell calculate only once
  659. Is there a way to switch data between two cells?
  660. What do I need to change to get menu's to open when using Alt+(?)
  661. MACRO QUESTION
  662. MACRO ADD ROW
  663. Autolabel Axis
  664. Merging spreadsheet data
  665. XLS comparison
  666. XLS to CSV Conversion - #'s convert to Date
  667. retrieve previous entries
  668. Finding external Excel files and crating a dashboard.
  669. Ratio Formula
  670. alphanumeric sort
  671. Adjusting a formula cell range
  672. Upper Case
  673. lookup
  674. Can you type a line over text (opposite of underline)?
  675. Pivot Table % of Totals
  676. Page Numbering
  677. Hyperlink to PDF file.
  678. Sharepoint Services -- Need Refresh Option
  679. email excel spreadsheet as body of message, not as attachment
  680. Excel 2003 memory issue
  681. page numbering
  682. Excel 2007 Beta - can't edit macros
  683. Copying store numbers and pasting them into a seperate workbook
  684. Multiple lines of text in a cell
  685. Filters
  686. Tab Names
  687. If statement that does nothing when false
  688. How to change #DIV/0! result for an entire worksheet ?
  689. IRR formula
  690. VBE auto opens--problem with code???
  691. Re: How do I set up the remainder to display in Excel?
  692. Extracting Dates
  693. SUGGESTION: Templating Excel
  694. Subtotaling-Displaying Other Columns
  695. Retrieve the file create date
  696. HOW TO COLOR ACTIVE LINE CURSOR IS ON WHEN MOVING
  697. Voip at Home,Voip Updated Howto,New Voip Phones,Voip Conferencing,
  698. Voip at Home,Voip Updated Howto,New Voip Phones,Voip Conferencing,
  699. Help using Transpose
  700. Number of different values in a range
  701. lookup count
  702. Changing defualt pivot table calculation
  703. Add-ins
  704. Is there a way to set up a template for new workbooks?
  705. How to sort Worksheet names?
  706. Data validation using multiple ranges
  707. find specific text and make cell highlighted
  708. Enable Macros
  709. Pivot Table - Remove "sum of" in data field
  710. Looking up data
  711. Macro help: File path in Excel 2000
  712. returning a specific cell value
  713. Automated currency symbols
  714. Add time and date stamp to Excel comments.
  715. Component not correctly registered Error opening Forms in Excel
  716. Ending a macro early conditionally on one cell being blank
  717. Custom Validation
  718. Weekday
  719. How do I send data to a person or BCC a group in excel?
  720. Conditional Formatting - Drawing Lines Between Sorted Groups
  721. How do I set Excel comments default font size
  722. Numbers to Letters?
  723. Excel 2007 Custom Error Bars
  724. History for Realtime measurement
  725. Excel 2007 MS Query prompt yields Syntax error
  726. personnal.xls
  727. need a formula which calculates points for a predictions league
  728. Code to create tabs in single excel sheet
  729. Code to create atbs in excel sheet
  730. Printing problems about Excel 2007 beta2
  731. URGENT IF STATEMENT: True if moving between financial year's
  732. Compile error: Ambigious name detected: Worksheet_Change **NEWBIE**
  733. organising reciepts
  734. Application opens but the file does not?
  735. Running Total - on a form that clears - No Accumulator!
  736. Possible bug in Excel 2007 with pie charts and 0 values?
  737. How add "%" sign to a list of numbers?
  738. How add "%" sign to a list of numbers?
  739. Create text file
  740. Access Macros in Office 2007 Beta 2
  741. Add a Section Break Feature.
  742. Excel
  743. XL 2003, True, False, 1, 0
  744. Trigonometry in Excel
  745. how can I get the word "draft" printed over my completed workshee.
  746. Help with Offset formula
  747. Getting the top 5
  748. Reading last cell
  749. Excel and Numbers
  750. How do I show the file URL in the toolbar in Office 2007?
  751. Match #1, 2, 3 with "A", #1, 2, 2 with "B", and #3, 3 with "C"
  752. How do I import Outlook email into Excel, as object?
  753. R2 Help Needed
  754. match names in 2 different columns
  755. Obtaining an average by typing the salesman you want to see and the column to AVG
  756. Column Words to Field Names
  757. Typing the name and the column and getting an average (for sales people)
  758. printing to PDF in Excel = weirdness
  759. Conditional Formatting limitation?
  760. Cell lookup
  761. Recover information
  762. Macro to stop Tools, Options, Edit
  763. Sort Arrows
  764. CountBlank for all Names in a Column, and another trick
  765. Code to Save As, then Open - can't figure it out!
  766. VLOOKUP
  767. E-mail Addresses in Excel
  768. difference between dates
  769. Sumif slow
  770. remove a dash from part numbers
  771. Grouping Workbooks Into One Window
  772. Ranking With Sum Product Formulas over Autofiltered Cells
  773. Transpose a cut section
  774. Grid printing for worksheets
  775. How do you remove duplicate phone numbers in an Excel spreadsheet
  776. Change Color in a Formula
  777. No "File in use" notification
  778. Sorting and Finding data
  779. Sequential numbering on a blank form?
  780. Move File
  781. If sum of an equation = 0, need to display blank cell
  782. Help Pls
  783. Excel journal or similar publication?
  784. Working with "record-oriented" spreadsheets
  785. what is the vb code to copy rows from one sheet to another?
  786. macro if statements
  787. Removing blanks / sorting - common methods not applicable
  788. Excel $ help!
  789. How can I save Excel am spreadsheet as pipe delimiter?
  790. Apply fomulas to additional worksheets as added
  791. Cell Color
  792. Can I create a list from the results of a file search in Excel?
  793. Test a Hyperlink
  794. Macro that saves excel workbook as PDF??
  795. Excel columns are now numbered instead of lettered
  796. Using RIGHT function in a VLOOKUP
  797. Excel2007Beta2: Selecting Range doesn't popup DesignTab
  798. IF macro
  799. Exact Copy
  800. Obtaining & using last cell in a column in a cell formula
  801. Controling the Worksheet_Change Event?
  802. autofill with number embedded in text
  803. Microsoft Date and Time Picker
  804. Excel column sumif is incorrect
  805. Sound+color alert if cell changed in another worksheet
  806. numbers sum to a specific amount
  807. Excel spreadsheets with data, Powerpoint charts... and VBA!
  808. How do I insert the date modified in a spreadsheet footer?
  809. complicated if then formula...need help
  810. Excel Chart Question
  811. 2nd Post - Urgently need Help on VBA Procedure
  812. Display Date Modified
  813. Excel FormTrouble
  814. Excel weird behavior
  815. How to find and replace in Excel for special characters?
  816. CELL NAME (A, B, C,) CHANGED SIZE
  817. Drop down list as part of a file name selector
  818. Excel Template with functions
  819. Sum Array
  820. Autofit with Merged Cells/Wrap Text Macro Problem
  821. How can I remove values under a certain value from a table?
  822. Formatting
  823. 2nd Posting - Need Help on VBA Procedure
  824. cells don't upate
  825. Data Validation
  826. Pretty Buttons...
  827. Adding rows in several worksheets along with formulas
  828. How to use Calender control as date chooser in excel??
  829. Pivot Tables lost link
  830. delete entirerow if date more than 12months old
  831. How do I display zeros in excel if they are the beginning characte
  832. Changing the code on an external link.
  833. Lookup and list
  834. Abstracting text
  835. Text file saving, setting file origin
  836. how do i update the date on a 2005 calendar template
  837. Why does caps lock automatically turn on?
  838. What is the maximum file size Excel can save?
  839. Transpose data
  840. Help with formula?
  841. Excel Save As issues
  842. Urgent help on VBA Procedure
  843. I think Linking
  844. Excel If/and
  845. People seeking help lack competency. Your HELP unhelpful
  846. Turn Off Hyperlinks?
  847. Complicated extraction of text
  848. Here we go again....
  849. calculating time with tenths
  850. page number shows in background
  851. Filtering Using Variables
  852. Auto Calculate
  853. Omitting A Row From Autofilter
  854. Round function in If statement
  855. change format of cells (bold, italic) based on one cell's answer
  856. Displaying negative numbers - inconsistent between desktop and lap
  857. Unwanted Rounding
  858. I'm Stumped
  859. How can I use SumProduct with a horizonontal and vertical array?
  860. How do I insert a filtered subtotal into overall summary
  861. Files open only when excel already open
  862. Huge increase in file size
  863. VLookup query
  864. Excel same Formula in different columns-calculate columnwise?
  865. SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text
  866. Challenge experts will LOVE!!, Can you get the formula??
  867. Cannot Open Webpage With Excel 2003
  868. how i can take file from adobe reader and make it read with micr.
  869. Converting a decimal number into time
  870. Excel should allow all open worksheets to close at once
  871. make row height automatic
  872. RANDBETWEEN funtion is missing from my new Excel.
  873. When I copy cells in Excel they go to my printer. How can i stop .
  874. Help with Default Excel file and template
  875. How do I select same day of month, 3 mths apart when day 31 of mth
  876. How to paste objects in a protected sheet
  877. Excel 2003 Formula
  878. how can I use eudora to send email from excel?
  879. Division Sign
  880. trouble ranking data...
  881. Change RADIX within Excel cell
  882. Want to view excel files in separate windows
  883. Transfer Macro code to another computer
  884. Pie Chart Labels
  885. Formulas do not recognize numbers
  886. test
  887. Counting days in month
  888. negative numbers as a zero
  889. Can I toggle between files easily
  890. XL 2003 & Sumproduct Question
  891. Performance not upto Office 2003 standards in Office 2007
  892. Resizing cells
  893. making columns flow down the page
  894. making columns flow down the page
  895. Ctrl + Home stopped working
  896. Is this possible?
  897. How do I create a crossover for old to new products,w/ explanatio
  898. Macro hanging up on 2nd use and later.
  899. Averaging percentages
  900. Zeros
  901. Can I wrap a row onto one page in Excel when printing?
  902. Help! - Lost function in Find & Replace!
  903. summing a volitile number of cells
  904. Cell size
  905. COUNTIF with non-zero format?
  906. Excel charts
  907. Lost formatting after special paste...
  908. sort last names by in alphabetical order
  909. Locking rows in Excel 97
  910. Slow Save
  911. Easy Printer Switch Question
  912. Data Source for MS Query
  913. Excel file
  914. Can't edit in cell anymore
  915. Importing list from Word to Excel
  916. problems with dates
  917. how do i open a file on my documents
  918. Lookup question
  919. Problems with Excel 2003 - Dashboards
  920. How do you link Check Boxes?
  921. Hours to minutes
  922. excel open in outlook if outlook is running
  923. out of limit data
  924. How do i calculate standardised mortality ratios using Excel?
  925. too many rows in csv file
  926. Formula for Mileage from Latitude and Longitude
  927. URGENT: Please Advise. SumProduct and Operand Question
  928. Month & year question
  929. DaVinchi Code
  930. How do I create a separate radio button set in the same sheet?
  931. formula using multiple ranges
  932. Duplicate Range Names by worksheet
  933. How to rename references from range names to cell references
  934. sumproduct - reading a variable value
  935. Excel VBA Help Files (*.chm) and Location
  936. Display number of day of month depending on the year
  937. Formula for changing all caps to lower case
  938. Trace Dependents
  939. Lists
  940. auto format problems
  941. Date Reference Oddity
  942. Formula to Remove Weekend Days
  943. Formulas not Updating
  944. Date calculations
  945. Pop Up Calendar
  946. Pivot Report - Remove 'Sum of'
  947. I want to change Exc Doc-save-e-mail, can receiving end trk chngs
  948. How to hyperlink in document so reference remains valid after a so
  949. formula's turn to results
  950. Conditional formatting - range of dates
  951. Conditional formatting - range of dates
  952. Worksheet Events
  953. weird> no more cell fill and text colour
  954. How do you sort copied from internet data in Excel?
  955. Cannot paste
  956. Merging of multipul data into single enteries.
  957. how do i extract data from pivot table to txt file
  958. Validation
  959. Run a Batch file with variables
  960. Dynamic Range with Function "AND"
  961. Excel '00, 1st file has macros, how to stop macro in 2nd file?
  962. Rounding and Ceilings
  963. Row Heights Incorrect Sizes
  964. I am making MIS tracker
  965. How do I create a counter?
  966. Move Word form to Excel
  967. More than 65,000 days.
  968. Ranking a List which must be within GROUPS
  969. multiple item entries from drop-down list
  970. funcao
  971. Userform and variables
  972. How do I generate Errors for Drop-Down Lists?
  973. Flashes
  974. preventing copying
  975. URGENT: Excel link to webpage and back
  976. Pivot Table Source Data
  977. Flashes
  978. Tools in excell,word & access not highlighted
  979. Replace dialog should put focus on "Find What" not "Replace With"
  980. Digits to character...!!!
  981. Text and Numerical data in a Pivottable without summarising?
  982. WANT AMOUNT IN C6-C100 TO = C3(550)
  983. Indirect.ext #value!
  984. How do I make Excel column headers alphabetical...
  985. Merging errors
  986. Solution to stopping IE opening excel workbooks without changing windows settings
  987. VBA - Not Excel
  988. EXCEL FILTERING
  989. How do I enable insert copied cells (option not available in menu.
  990. How do I enable 'insert copied cells' (option not available in men
  991. Changing row content with single cell click
  992. Suggestions for the Next Release
  993. Linking vs Data Consolidation Help!!
  994. ALT +Enter not working?
  995. what is the formula for adding up time intervals?
  996. How do I find Top Spenders?
  997. Formatting numbers
  998. Excel Worksheet
  999. Help with VBA
  1000. All 0's for Sums in Pivot Table