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. Merging of cells while in shared workbook
  2. formulas in excel
  3. Concatenating a Text and a Date without losing orginal Date Format
  4. change imperial to metric
  5. How can I change cell color using conditional formatting
  6. Cells are selected but aren't displayed as selected
  7. Excel formula fails to update
  8. display values between two dates
  9. Extended System Info
  10. VBA setting formula for a cell causes "Wrong data type" error
  11. Interest Rate Givien IRR ((please help me to solve it)
  12. Purpose of double negative
  13. =If(Macro)
  14. Formatting Date
  15. Print job
  16. User-Level Sharing
  17. Excel 2007 Beta Version
  18. printing
  19. Two Excel sessions spawned at startup
  20. selecting next empty cell
  21. complex formula
  22. set of numbers, i.e. [1..48]
  23. How can I write a fromula to subtract 1/4 from 1/2 and so on?
  24. Very Long Calculation Times
  25. Validation doesn't work
  26. In an excel cell, I want my numbers indented less than 1 character
  27. calendars
  28. Excel load message Compile error in hidden module AutoExecNew
  29. Delete Entry Based on Selection
  30. How To Beam Excel 2003 file to Windows Mobile Excel 5.0 (pda)
  31. How do I assign a letter value to a range of data?
  32. How do you format data that is part of a drop down menu?
  33. Userform List box to Text Box
  34. Lookup 2 values
  35. save as w/sheet
  36. Personal.xls
  37. Cell format in Excel
  38. How do I create and save .odc and .oqy files in excel?
  39. worksheet menu bar "disappeared" suddenly
  40. Making chart with hidden Data
  41. Need to store changing values from one cell
  42. Spilting Data in the same cell
  43. Multiple criteria/Countif question
  44. If I have date, can excel calculate the day for me?
  45. SHOPPING CART
  46. How to show or hide outlined data option in a protected worksheet?
  47. Saved-workspace weirdness, questions
  48. Conditional SUMPRODUCT
  49. I want to combine 2 workbook data bases and remove duplicates
  50. How do I create a cell reference to return name of the tab?
  51. Number Formating Cells (Time)
  52. Work schedule development question
  53. change an icon
  54. Automatically save a file in another directory
  55. formula question
  56. formula
  57. If a cell contains "preferred" then do this
  58. How do I remove a flash object "stuck on" my spreadsheet?
  59. File in use error message on a non shared workbook
  60. Bond prices convert to decimals
  61. When I select a cell in Excel I cannot deselect it. Ideas?
  62. Charts and formulas
  63. Spreadsheet Linking to Calendar
  64. How do I combine cells? ex. first name, last name columns
  65. Limiting files to a single computer
  66. Pivot Table - hide if no data
  67. Excell page moves horizontal not vertical
  68. restore
  69. AutoFiltering
  70. select next empty cell
  71. when certain number is typed in a cell to display a message
  72. if then date formulas
  73. inventory
  74. 'anchoring' or 'grounding' part of a formula
  75. Extra excel windows
  76. linear growth rate graphing calculator
  77. How do I eliminate the green triangle throughout my spreadsheet?
  78. Maximum amount of worksheets in single file
  79. ascii conversion
  80. need a large spreadsheet
  81. Making Percentages
  82. printing labels from rows
  83. How do I quadruple numbers starting with 1, 2?
  84. create
  85. Calendar Holiday question
  86. How import table and have Excel sort automatically?
  87. can you put formulas and labels in the same cell
  88. open the time formula automaticly in B1 after tabbing from A1
  89. all my top rows are now numbers, how to set it back to letters
  90. Importing External Data From Several Files
  91. Paste Word Check Box Form Field Link into Excel
  92. Like the DAYS360, Datev& Time Function is there one for 365 day ?
  93. How would I add a loop for this?
  94. Eliminate anti-rollback in Excel 2000
  95. List
  96. Linear trend function: 5 year increment
  97. Getting data from one excel sheet into poreset tabs?
  98. How do I count 2 columns of data that meet a certain criteria?
  99. Pivot Table
  100. Adding up hours and minutes
  101. "Uncombining" Text
  102. cant save read only file
  103. convert text into Formula
  104. Lotus 123 files
  105. lock folder
  106. How do view and edit ALL hyperlinks in a sheet?
  107. Standard font in a "New Microsoft Excel Worksheet.xls" wont change
  108. picture size can not change to web quality
  109. Printer message
  110. Hi Alllen
  111. Excel Query
  112. VLOOKUP NOT WORKING
  113. Windows application error message
  114. How to find values in string? - Urgent!
  115. storing real time data
  116. Find future dates
  117. Cell format
  118. change lower letters to upper letters
  119. Compare data from one column/spreasheet to another?
  120. is there any way to have more than 3 conditional formats per cell
  121. SOLVER ADD IN
  122. Rounding in Excel
  123. printing a worksheet with VB buttons or text boxes
  124. How do I stop copying the cell protection in Excel?
  125. In-Cell Drop down color
  126. How do I create a checkbox in MS Excel?
  127. Using Drop Downs Or Combo Boxes to Look up and display Info
  128. How do I put text and a cell reference in a text box?
  129. How do I copy or cut multiple rows to move to new sheet?
  130. How do I convert Excel Worksheet into address book in Groupwise
  131. How I know if a file is using a custom addin
  132. SUM Daily to Month
  133. showing source data from a graph
  134. Pivot Tables: Locking Certain Features
  135. Auto-capture data that changes daily
  136. How can i stop users inserting and unhiding rows and columns my workbook
  137. VBA equivalence tp to DOS "echo off"
  138. macro needed
  139. Multi-field listbox in an Excel form
  140. How do I enter an Average Formula?
  141. copy non-consecutive rows
  142. Current Directory
  143. Index/ Match enhancement needed
  144. MS Excel Query
  145. How send e-mail to a group of addresses on Excel worksheet?
  146. Creating a lookup
  147. How do I copy all cell data between sheets automaticaly?
  148. Flag Data?
  149. excel won't sort on a column of data
  150. Why do some grid lines appear on preview but not when printed?
  151. delete rows
  152. My addin in other computers
  153. keyboard shortcut for " insert copied cells" ?
  154. akh
  155. do you require up dates for office excel 2003
  156. Excel 2003 - how to hover over a cell and have a value show up
  157. Set negative numbers to zero. Do not calculate with negative valu
  158. HOW DO I SHOW A ZERO VALUE FOR A FORMULA THAT RETURN A " FALSE" ?
  159. Empty Cell Validation
  160. Replace with Grouped Sheets
  161. drop down list variable
  162. Conditional Format
  163. Conditional Formating. Remove condition, keep format?
  164. consolidation calculation
  165. Writing to notepad file
  166. How do I insert a copied the row to multiple places in Excel?
  167. tabbing from cell to cell
  168. Counting Rows
  169. Calculating Cells Taking Forever
  170. Formulas
  171. How do I retrieve a accidentally deleted file in Excel?
  172. a .xls file
  173. Missing text from copy/paste
  174. lost all excell files
  175. Print 2 pages with different formats
  176. vlookup
  177. Event (BeforeSave) - How to test VBA code? Dave P. can you hear me now?
  178. compare and copy
  179. I want to sort on titles but wish to ignore, but not delete, the .
  180. RE: entering emails without hyperlink creation
  181. SUMPRODUCT Help
  182. VBA memory
  183. Why does Excel not save all the time?
  184. How to filter out all the partial dates from a big list of dates?
  185. formula to get the spreadsheet address to print on the spreadsheet
  186. Can I link a color format from 1 cell to a cell in another tab?
  187. Excel - Buttons Changing Format
  188. Uploading excel files: Useful and Cool
  189. sort behavior in shared workbook
  190. Complex Formula for Yearly Averages
  191. How can I remove 4 of 9 numbers from a cell for the whole column?
  192. How do I round a number to the nearest thousand in Excel???
  193. Modifying a Formula
  194. Password Protection Problem
  195. Would it be possible to extract info from this site?
  196. item numbers in a list that update if a row is deleted
  197. return value in a cell if check box is checked
  198. Can I filter a row depending on the colour that I've highlighted it with?
  199. How can you darken the tabs and number rows and top column heading
  200. moving a paragraph to the next page.
  201. fixed formatting on a protected sheet
  202. Cell Select
  203. numeric keypad not working
  204. sumif using multiple criteria
  205. change column heading names from numbers to alpha characters
  206. Closing Excel, new (to me) behavior
  207. how do I change column numbers to letters
  208. Excel Formulas
  209. Finding Buried Text
  210. how do I change the columns to letters not numbers
  211. Cell Defaults
  212. HTML in cell appears as text
  213. ... I want to chart data from 30 separate worksheets ...
  214. Chat
  215. XLStart...
  216. How do I split column?
  217. timesheet problems!
  218. Is anyone having problems with nested subtotaling in XP Excel
  219. How to convert Value to words?Eg.Rs.1000/- to Repees One thousand
  220. Static Date Insertion Formula
  221. sort in numberical order
  222. Macro lookup is not working good?
  223. Cannot print a complete page of labels
  224. creating a filtered list
  225. Returning a result from a single charater within a cell
  226. Negative Time
  227. Multiple Data Representation on Graphs
  228. Trying to Split and delete
  229. Hide Error Message
  230. Static Date
  231. forgotten password
  232. Dont show formula in formula bar
  233. forgotten passwor
  234. How do I creat scrol Bar in cell?
  235. How to sort data with off-sheet dependents?
  236. How to save a worksheet seperately in addition to part of wrkbook
  237. where can I find help with excel formulas?
  238. SumIF Statment
  239. But not working properly
  240. How to disable copy of protected excel worksheet?
  241. create a formula to muliply hours times dollars per hour?
  242. Autoformat numbering...how to stop it
  243. Inputing and sorting Roster data
  244. Parameters for an excel formula
  245. What do I need?
  246. Disable Exit button on a UserForm
  247. VBA equivalent to "echo off"
  248. How to i work beyond the Excel limit of a max row of 65,536?
  249. inserting new columns
  250. Expanding numbers and letters in a cell
  251. Is there a character limit within a cell?
  252. Media player import to excel
  253. Formula Problems
  254. Quantifying Calculation Steps in a Workbook
  255. HIGHLIGHT THE ROW I'M WORKING IN
  256. calculate future age date by birthdate
  257. macro help please
  258. Clipboard Full Notification
  259. What is the right function
  260. Making sure all dates are accounted for in a sequence
  261. Optimization Tips
  262. how do I eliminate leading "0s" in an alpha numeric cell
  263. Gathering Data from Another Workbook
  264. deleting from within a cell
  265. Is it possible to...
  266. [group]
  267. Inserting rows between each entry
  268. Bold text in check box
  269. Difference of time in hours or minutes
  270. how do I combine identicle worksheets into one sheet
  271. inputbox type 64 (array)
  272. Change the default $ setting to € on invoice template?
  273. sorting by first column then by second column
  274. Adding external Data
  275. Network Share Problem
  276. Change text into time
  277. how can I return entire row for column value returned
  278. Finding a valid cell in a row
  279. Can I use autosave in excel 2003 instead of autorecover?
  280. Hyperlink HELP
  281. Forms/ Check Box
  282. finding common data
  283. Informational Pop-ups
  284. Plotting in Charts
  285. Exporting from Excel to CSV results in wrong characters
  286. How to make a conditional format recognize a formula in a cell
  287. How do I get the text to continue on the next line when its long
  288. How do I set the save default not to include .xls in name of file
  289. Retrieve multiple data rows data from a very long list and copy t
  290. Change a letter grade to a numerica GPA
  291. Formula Help - Squaring three highest numbers
  292. Question
  293. Formatting Data Pasted from Web Based Table for Summation
  294. Opening workbook
  295. how does the AVERAGE function work?
  296. Can Borders Be Made Permanent
  297. Compare data and automatically enter data.
  298. how do i enter the formula?
  299. how do i add pdf convert option to Excel
  300. Code to calc
  301. VLOOKUP in VB
  302. How to select font with a strange name
  303. Removing part of a number in Excel
  304. Come selezionare solo celle con font rosso con visualbasic
  305. Data Validation and Filtering
  306. Tab worksheet
  307. Consolidating data - removing consolidation
  308. Export Calendar to Excel along with daily notes?
  309. Creating a List
  310. Copying data from one spreadsheet to another quickly
  311. link Access DB to excel WS to share certain data, not whole DB, ho
  312. CELL SPACING
  313. Partially fill cells
  314. checking and comparing formulae
  315. How do I set up a graph to show a number of different criteria?
  316. right click does not work to tabs
  317. values not appearing in autofilter list
  318. Analyzing Numbers
  319. Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?()
  320. Problems opening file
  321. My Excel is not mulitpling numbers correctly?
  322. Find $ in a string of text and return numbers
  323. Reformatting a column
  324. Single Range for Multiple Operations
  325. Sum if question
  326. Print Area
  327. Hours calculation in 24h format
  328. filter
  329. Autopopulate from a different sheet?
  330. Display filename in cell
  331. cell shows all the data, click out of it, end of data disappears
  332. Billing Due date spreadsheet?
  333. Two Worksheets similar data
  334. MS query--can it handle parameter queries from Access?
  335. Turning off merge-warning
  336. time formula
  337. Deleting a worksheet but retaining values from the worksheet.
  338. Deleting a worksheet but retaining values from the worksheet.
  339. Save problem for linked excel spreadsheet
  340. conditional format
  341. create a filtered table
  342. Can't open Excel Files
  343. Convert name-value pairs to table in Excel?
  344. Excel 2K- Is Page break view limited to 16 pages?
  345. Excel is changing the comma symbol in formulas to a square box ?
  346. Deleting empty rows automatically
  347. Colored dropdown list
  348. Create a pseudo Calender?
  349. I want to compare the values in two columns
  350. Template for a small hotel
  351. formula is displayed instead of the result
  352. Why can't I record "flag for follow up" as a Macro?
  353. Delete columns values inbetween
  354. Column seggregation
  355. Data Source for excel graph
  356. Show color on screen bur not on paper
  357. Changing printers does not correctly apply printer settings
  358. I need a macro to transpose multiple columns A1-Z1, A2-X2 etc
  359. How to display result of calculations in engineering notation?
  360. placing numbers in one column at intervals of 2nd
  361. Need data from one worksheet to be in a list in another worksheet.
  362. Locked cells in a database
  363. demial number being replace by a square box...weird
  364. caused - an integer or decimal number may be required
  365. convert .xls to .doc
  366. Remove specific Pivotcache fields
  367. Recommended books for formula's
  368. Protect on column from a workbook
  369. .wks fil not recognized format if opening w/ Excel.How do I open?
  370. formatting time cell
  371. Order Entry
  372. Array Formula
  373. develop a macro which takes password protection on and off
  374. how do i create a start up message each time a document is opened?
  375. Locked formula within a named Database
  376. How do I get a comment to show up in Office Assistant icon?
  377. Conditional Formatting
  378. Make productive
  379. visual design question - fixed column with
  380. How to change Template Comments/Tips?
  381. VB Cell Formatting
  382. How to convert currency Amount in words in Excel ?
  383. Cell won't center contents
  384. Text Search in an Array
  385. Delayed reactions
  386. adding a dash
  387. Delayed reactions
  388. how do you subtract from the bank balance
  389. help
  390. i want to learn office
  391. Keyboard shortcut in excel
  392. MS query
  393. Force Selection of Custom Views
  394. Spinners
  395. Rename Columns and Row
  396. Excel hiding rows
  397. How do I print 2-sided in Excel using 2 different sheets?
  398. Share marcros between users in Excel
  399. Intellitabs
  400. Help!!! My worksheet is frozen!
  401. AutoInstall Add-in (Excel)
  402. How do I add cells to a balance sheet which will include new sum?
  403. Pasting from another spreadsheet changes formatting
  404. Trying to create a form for data entry
  405. re-name colomns i.e A,B,C, etc
  406. Show formatting marks
  407. Exporting from web page into Excel
  408. How do I go directly to editing a worksheet in excel?
  409. how to do nested IF formulas
  410. Data not entered yet - formula calculate blank
  411. How can I keep a form and yet use it?
  412. Ignoring code to shut a workbook if it is already shut
  413. How do I stop fractions from being reduced?
  414. Please Help Calculate Time Between 2 different Dates
  415. Where is a list of Command Button uses?
  416. getting several hundred n-counts
  417. whats the big "Page 1" that appears across my spreadsheet?
  418. How do I remove a space from the middle of a line of numbers?
  419. How can I set up records for a bowling leaque
  420. Pulling data from another worksheet thru a formula
  421. text file
  422. Copying One column into Two columns
  423. Autofill formula to next row
  424. Shortcut Key not working
  425. Excel and zip codes
  426. Editing embedded Word file in Excel JUMPS to top
  427. Removing leading/trailing spaces
  428. Protecting a shared worksheet on a network
  429. unprotect check box in protected worksheet
  430. Import Qucikbooks Problem - formatting
  431. How to show file path in formual bar when linking workbooks?
  432. new windows for new excel file
  433. Row colors overlay the gridlines...how do I show gridlines?
  434. FORMULA REQUIRED
  435. Pivot Table Glitch?
  436. Autofilter using the contents of a particular cell
  437. Auto-import csv into Excel?
  438. Lookup Help
  439. Vertical line isn't vertical!
  440. Filter dates by the day
  441. Selecting Cells
  442. conditional formatting
  443. Macro Help
  444. Opposite of Text to column
  445. All objects are coloured white for every new worksheet.
  446. adding more columns/rows
  447. Splitting Column in to 2 columns
  448. Splitting comma separated lines of an address for mail merge.
  449. Improve workability of this discussion group website
  450. How to change collumn heading numbers into letters?
  451. Dialog box appears when opening Excel says it can't find a file?
  452. range name does not exist
  453. Handle to a cell (Row and Column)
  454. project information into other cells
  455. selecting cells which contain formulas but return blanks
  456. FILTER applied to many coloumns
  457. NEWSREADER
  458. Formula to count klik from a mouse
  459. Copy and Paste from ANOTHER WORKBOOK
  460. "openinf file..."ENABLE MACROS...DISABLE MACROS"
  461. Time Sheet Problem
  462. average(if())
  463. Macro
  464. average(if())
  465. Getting handle to Row # dynamically
  466. Changing a Number in a Column Using Arrays?
  467. text import wizard in 2007
  468. fist page landscape, second page portrait
  469. Add to Favorite in Office 2003
  470. can not find the pivot function in office 2007
  471. A farm Template for animals, offspring, type, grain expenses
  472. How do I make an embedded excel spreadsheet flow over pages in wo
  473. Need formula help
  474. I need to clean a database
  475. excel and power point error on log on, word opening slowly
  476. multi level worksheets
  477. Can anybody suggest me a teplate in excel (daily activity report)
  478. Excel won't create file from template. What to do?
  479. Search engine for text
  480. I want to use an IF Statement in excel to check cell pattern-how?
  481. password protected logo
  482. How do you create a check mark in Excel?
  483. i want to put my date in with no / exp: 02021951
  484. Summing words
  485. vlookup with indirect
  486. Cell indicator
  487. Conditional Format based on 3 other cells.
  488. How to make cell width different than the column width it lies in
  489. How do you format a number into a date?
  490. Appending Text
  491. More zip + 4 problems
  492. How to default links to RELATIVE reference
  493. Customized Toolbars
  494. please help with Links in excel
  495. My sheet tabs disappeared with entered data. Can it be restored?
  496. Mail Merge Data
  497. What does "Calculate" mean in the Status Bar?
  498. Zip + 4 format column then must double click to change - why?
  499. Time/Date subtract >24 hours
  500. I have Error 1919 Error Configuring ODBC dataSource Database
  501. Why cant I click an excel file to open it w/o opening excel 1st?
  502. Formula Countif
  503. Prevent color printing
  504. Wrap/print question
  505. Re: Auto refresh pivot table
  506. bind data to active x listbox without macro
  507. matching
  508. how do I retriive a spreadsheet I previously deleted
  509. Quick Code
  510. Unwanted Object when pasting.
  511. Conditional Formatting
  512. Variable range addresses for use in array functions
  513. Macro breaks my links.
  514. Information on Excel capabilities and application interface
  515. How can I sort a column by the last positions of each cell
  516. How to conditionally format entire row from contents of one cell?
  517. Comment Boxes Don't Respond on Web Site
  518. display number as feet and inch in single cell
  519. auto number rows when printing
  520. Can visual basics hide rows based on cell values?
  521. Conditional Formating & Fill Effect
  522. Trace Dependents for range of cells
  523. how can i change margins/apperance on a downloaded .txt file?
  524. list that alphabetizes itself w/each new name
  525. Using IF command
  526. Hyperlink Address and SubAddress not concatenating correctly
  527. will macro created in excell 2003 work if run using 2000
  528. Cubic Spline Function
  529. Margins do not fit page size!
  530. Count Highlighted Rows
  531. How do I eliminate :1 or :2 of a spreadsheet?
  532. VALUE WITH A CIRCLE
  533. Sharing workbooks
  534. dynamic link
  535. Web-based Survey
  536. Spinners - minimum and maximum
  537. Forms buttons
  538. Spreadsheet links
  539. excel screen wont display colours when filled
  540. how do i automatically update % figures daily
  541. Can an IF statement insert an picture?
  542. My hyperlinks stop working on saving the workbook
  543. replacing with a tick
  544. TO RENAME & COLOR THE SHEETS
  545. Formating a picture to fit cell automaticaly
  546. is there a limit to how much text can be entered in merged cells
  547. Dynamic range
  548. Format Cell to Overwrite Decimal Separator in Options
  549. Furigana in Excel 2003
  550. how can we drug some one with the help of key board
  551. "year" date function
  552. Using value of last cell with a value in a column
  553. combining cells and array from different sheets into an array to pass to IRR()
  554. Add word in cell changes to word TRUE
  555. Highlighting cell / lookup
  556. how to make a bar chart
  557. sum within the same cell
  558. Excel docs not saving as excel docs
  559. If Statement returns true when false?
  560. How
  561. If
  562. How do I control fields tabbed to on protected sheet?
  563. anyone ever hear of a formula beginning "xlend"?
  564. auto populate cell based on previous cell drop down list selectio.
  565. eliminating the 0 in DIV/0
  566. Excel
  567. How to move data from spreadsheets to spreadsheet?
  568. Halo 3
  569. why can't I see pics from an excel spreadsheet?
  570. Slow speed Excel with Centrino duo
  571. Database Formula
  572. How do I make it so that the active cell follows the cursor keys?
  573. subtotal in a list
  574. How do I display heights (6' 2") in Excel columns?
  575. back up excell file
  576. screen wiil not display fill colours but will print them
  577. Where do I get the slash sign for Excel?
  578. Excel: Relative worksheet references?
  579. Mobile Excel Question Please
  580. Quick search required
  581. "formula is too long" AND test for whether double-quotes are next-to text or number??
  582. Getting no of hours from start to finish
  583. Formula
  584. How to randomly assign numbers to names?
  585. remove hyperlink of many cell at a time?
  586. copy and paste using vb code
  587. Run-time error '1004':
  588. Excel 2007 Conditional Formatting barely works
  589. cell formular
  590. How do I code authorship into a footer?
  591. Excell- am stupid and need help figuring out how to write in cell
  592. I am stupid and don't know what the heck I am doing wrong on this pivot table
  593. how do i open quattro pro 7.0 (.wb3) file in excel 2003?
  594. USING VLOOKUP AND HLOOKUP
  595. How do I name a range of dates?
  596. Cell formular
  597. How do I not print the column letters A-Z but keep the row #'s
  598. 75% 100% 54% 64% using 75%as 40% 100as 20% 54as 20% 64as 20%
  599. Not able to print 2 N-Up in Excel...help?
  600. HOW TO ENLARGE QUANTITY OF COLUMNS
  601. linking
  602. templets for petty cash voucher
  603. Copy and paste has got complicated. Help please
  604. Sizing charts
  605. TIME FORMATING
  606. Error: method 'select' of object_worksheet' failed
  607. Print area defined
  608. Conditional Format Problem
  609. Finding the column which a value was drawn from
  610. Change text (8:30 PM) to military time (20:30)
  611. Sorting Help
  612. Random selection of text cells
  613. Advanced Filter in Excell
  614. Creating a Utility Cost calculator
  615. Converting a symbol to a numeric value?
  616. Creating a spreadsheet in excel to track inventory
  617. Avoiding "0" importing blank cells from another Excel file
  618. Named ranges which seem to reference old workbooks/worksheets
  619. need church forms
  620. need church forms?
  621. subtotal on 2 columns
  622. Combobox and data validation
  623. Cell formular
  624. Plot ( NEED HELP)
  625. Need a "Tailored" Highlighting Macro
  626. Looking for pivot table functionality that shows detail instead of count
  627. Data Table Questions
  628. Excel Font - e-mail
  629. How do i download UK version of the Invoice template ?
  630. Can text in one cell be split into several cells?
  631. Schedule a Macro to run every 5 minutes
  632. Pivot Table
  633. Previous Month End
  634. Old hyperlink information in a block, not what is currently there
  635. Time Division Question
  636. New sheets inserted in a workbook comes out mirrored
  637. Filter entire columns
  638. File conversion-text encoding issue
  639. Rounding Problem
  640. scrolling numbers in auto filter?
  641. Find a Range of Data
  642. Show time stamp when a value is entered
  643. Time & Date Stamp 2 worksheets
  644. Displaying Cell Formulas
  645. Displaying Cell Formulas
  646. Entering Dates for a Prior Year
  647. Reversing date from column to Row
  648. Sun IF two data types are the same in a single column
  649. Circular Reference quits
  650. Generate a value from user selection in list box.
  651. vlookup function does not work when range is hidden
  652. linked cells not working
  653. Macros
  654. Need help!
  655. Help,,,my keyboard is locked and can not enter characters n excel
  656. average >150
  657. Link worksheets
  658. Variables in the subject line of an e-mail hyperlink
  659. Autocopy formula to cells
  660. Save a csv or text file in Excel 2000 with choice of separator
  661. How do I set the last cell in a worksheet?
  662. Excel 2003 Help Files
  663. Large function with multiple criteria
  664. Convert Project template for Excel
  665. Reseting named ranges.
  666. How do Icorrectly use the LookUp feature when the cells contain wo
  667. why won't excel print my document?
  668. Limiting a cell to an upper value (and passing on the difference)
  669. Amount Spent vs Budget
  670. Why doesn't the equation correspond to the graphic?
  671. Font Colours / negative numbers
  672. why exist a formula for excel and another for vba? pmt, payment
  673. Create Excel Template- Weekly Appt. Schedule by 15-min increments
  674. change background color
  675. locked keyboard
  676. filter options in excel 2007
  677. CONDITIONAL FORMATTING
  678. differences between XL VBA for the Mac and for Windows?
  679. Auto Complete Question
  680. Can password be removed on Excel WS from terminated employee?
  681. Unable to line up decimal points in some columns.
  682. creat a macro to save a copy with different file name
  683. Conditional formatting for part of a cell
  684. Creating a Worksheet
  685. can you use a text colour as a formating condition?
  686. Problem Adding new Combo Boxes
  687. similar function for SUBSTITUTE in excel?
  688. Bonus Calculation
  689. Formular to add to a IP address
  690. Excel highlighting issue
  691. Counting
  692. Conditional format
  693. How do I set up checkboxes in excel?
  694. How to stop excel from rounding ?
  695. Creating Chart from Two Rows of Data
  696. how to merge two spreadsheets and remove duplicated entries.
  697. Measurements in cells?
  698. Linked Workbooks
  699. Protecting a worksheet which has button controlled macros
  700. Formula Precedents
  701. Grouping Problem in Pivot
  702. Count number of occurences within a time range
  703. Excluding empty/zero values in graph - highlight area in chart
  704. Send spreadsheet as email message
  705. Accumulating elapsed times.
  706. Date comparision
  707. stats from data GQ
  708. Empty rows
  709. Linking check boxes so if one is true the other shows false
  710. How to find & replace a formula sequence with * in it?
  711. pivot table-get unique count
  712. Why do I lose data in a shared workbook?
  713. Rotate text 180
  714. Limit to Categories in Paste Function Dialog
  715. Workbook tabs
  716. Show field or range name in a cell
  717. Compare Side by Side - Have I gone mad!!??
  718. Is there one or combination of Excel function to count unique entr
  719. A way to auto insert at top of each column with each entry?
  720. daily tracking of expenses
  721. How do i set up a list that sorts as Number/letter/number in orde
  722. Autofilter/Spinner
  723. Looking for opposite of a value in same column
  724. Lookup/count blank cells problem
  725. How do I remove an unwanted check box from an Excel spread sheet?
  726. How do I remove year from date
  727. If function
  728. how do I print gridlines for Excel wooksheet
  729. Paste Link shows '0' for empty cells
  730. Report Manager question
  731. adding multiple cells together
  732. How do I align decimals in Excel when not all numbers have % sym.
  733. "General" format default
  734. IF or VLOOKUP or whatever
  735. option to keep zero at begining of number
  736. Custom number format codes for negative numbers
  737. Passwords and Encryption for Excel 2003 for Validation Purposes.
  738. can two people use the same excel doc at the same time?
  739. How do I label flow connectors in and excel flow chart?
  740. Hyperlink from an Excel/Word document to an Outlook folder
  741. Printing Unprotected Cells Only
  742. CompareValues
  743. Hyperlink
  744. Data export from Crystal to Excel
  745. Date and Time Response- before/during/after Business hours
  746. Relative referencing in Microsoft Excel between worksheets
  747. In excell how can I print the borders in my cells?
  748. Macros on excel
  749. Find using IF
  750. EXCEL XP question...
  751. EXCEL wont open from Explorer, must open EXCEL then find file
  752. Highlighting in Excel
  753. How do set data validation using cells on a different worksheet?
  754. How do I turn off the autofill option button that comes on?
  755. Organize many excel workbooks
  756. Pivot table heading
  757. Enter data on one sheet duplicate on another?
  758. formula returns #value
  759. want to replcae from"comma(,)" to "dot(.)
  760. Loading Data into Multiple sheets in 1 book
  761. Custom colors for cell shading in Excel
  762. linking in excel
  763. Excel selection issues
  764. Lookup the last occurance of a value in a list
  765. Social Security Number formatting
  766. Loss of column gridlines
  767. preventing formula deletion
  768. copy and paste formula using vb code
  769. Rounding to Multiples of Integers?
  770. ASP Excel interaction
  771. When I try to move the cursor with the arrow keys the whole page
  772. decimals only.
  773. When I try to move the cursor with the arrow keys the whole page .
  774. Excel crashing when shared
  775. Date and Time Picker
  776. display dates with ordinal numbers in excel
  777. How do I output csv files from Excel with quotes round text fields
  778. ISNUMBER and IF Functions
  779. RE: Postcode validation
  780. different values depending on how text file is opened
  781. .XLS to .CSV files
  782. CHANGING POSITION OF AUTOFILTER LIST
  783. if function in excel should 12 loops
  784. How to find out the cell location
  785. Hindi Language
  786. Mail Merging: From Filtered data to Word
  787. DATE WRONGLY TYPED IN NUMBER FOMRATE
  788. Help - gridlines not printing in Excel(Office)97
  789. CheckBoxes: How to reset
  790. Weird appearance of range names and links in new file
  791. Sharing common column data on several worksheets?
  792. Suggestion for new cell formats for Feet and Inch
  793. Randomly Choose Two Numbers
  794. Shortcut for "Ctrl+Shift+1"
  795. Tab between cells
  796. multiple cell fuction results in fraction format
  797. Round to nearest foot (12 inches)
  798. How do I set a default in Excel so documents open in new window?
  799. Using Named Range with protection on the worksheet
  800. Future Value Calculation
  801. Create a Word Table from a Excel Macro
  802. IF Functions
  803. design cross plattform question
  804. Creating A Breakout List from a Summary List
  805. Excel hangs when remove some cells
  806. Macros
  807. Macros
  808. Formula for finding next cell with data?
  809. rate of return formula
  810. macro paste by matching dates
  811. Calculating an Implied Interest Rate
  812. OOPS
  813. Print Report W/Sub Report
  814. Printing Pivot Chart in 2007
  815. Strip workbook of macros, VBA, MS Query, etc.
  816. look for parts off contents in a cell
  817. Linking one single cell to a lot number of cells .
  818. delete non numberic characters
  819. Print Preview and Page Break View do not show on my computer
  820. Pivot Table Layout
  821. fiscal quarter conversion
  822. median in a pivot chart?
  823. Is there a feature and function list for EXCEL?
  824. Print same Excel sheet several times but while changing footer?
  825. Pivot Table - Filter
  826. cannot adjust page breaks
  827. deliver rosta 5 staff x 35hrs cover 24hrs p.a.
  828. Excel hyperlinks
  829. HTML Controls
  830. IF Function with the link to different lists
  831. Can a drop down list include multiple cells?
  832. recently used file list
  833. change SUMIF formula into a vb code
  834. naming cells
  835. Excel instance won't quit
  836. Find, copy and paste
  837. MATCHING AND PASTING DATA
  838. CORREL versus COVAR/STDEV^2.......why different?
  839. Multiple Columns to Single Columns
  840. comment won't change font
  841. Percent Formats
  842. Save assigned button
  843. Trying to write vba code to import another spreadsheet...
  844. Complicated formula or macro
  845. Formatting part of text
  846. How do I left justify center section header
  847. How to suppress auto-calculation when opening an older version fil
  848. Linking powerpoint chart to excel
  849. Excel 2003 Much Slower When Opening Row Groups
  850. Excel addition formulas
  851. Formula help
  852. sum formula in excel
  853. Can I set up a drop-down box with a calendar?
  854. Cell Referencing
  855. Excel - Importing Text Files
  856. Verifying your credentials for opening content with restricted pe.
  857. How to get individual dates from a date range
  858. Sumif between 2 dates and specify criteria
  859. "Text to Columns" for many columns in Excel 2003
  860. XL2000: Error Message: The Picture Is Too Large and Will Be Trunca
  861. assigning macros
  862. a number of coulmn in a spreadsheet
  863. keystrokes for highlighting fields in subtotal
  864. Row blacked out
  865. Question regarding the making of a selection in a certain column a
  866. Counting Words
  867. Shared workbook does not display data...
  868. Goal attaining formula
  869. Generate Numbers (not random) Like a counter
  870. pivot table that will show the kilometers/liter
  871. GIF image on web-page corrupts data fetched with Web Query
  872. How to change case in excel? MS Help is no help
  873. Excel,how to turn off "send to" function when highlighting cells?
  874. hundreds separator
  875. How to print selected rows of database
  876. Installation Error
  877. Problems with date formatting
  878. toolbar
  879. How do i locate/highlight duplicates ?
  880. Rate Calculation
  881. how do i change measurement units from inches to centimeters in ex
  882. Printing
  883. pivot tables not updating correctly
  884. Can I increase the number of coumns in a worksheet?
  885. Reusing formula
  886. Cannot Start Microsoft query
  887. Underline portion of footer with VBA
  888. formula
  889. formulas that matches data and subtract dates
  890. Excel Sorting help
  891. Word with embedded Excel object which has reference to addin
  892. Phrasing
  893. Can I use excel (or any program) to alphabetize names?
  894. Excel Window suddenly disappear
  895. How do I get files to open quicker
  896. How do I eliminate the green triangle throughout my spreadsheet?
  897. adding a code to calculate how much time is lost
  898. How to format cells so they display A01-222-333-7777 or D01-222-3
  899. Problem with Table Formatting
  900. Why can't I get a curser to complete Excel form received?
  901. How do I create a dialog box to pop up when logging out of a docum
  902. auto-filter messes up the formulas
  903. Data Analysis Recalculation
  904. Date formatting help
  905. Disable "save" option on close.
  906. Aspen Plus in Excel
  907. Count how many times a certain value is in a certain range
  908. Trying to unhide A-K
  909. "Wrap text" makes row larger than text resulting in white space.
  910. Genealogy
  911. Wrapping Text and Cell Expansion
  912. Creating a single workbook from multiple workbooks
  913. Hyperlink Within a Cell
  914. pivot table + explorer + hyperlinks
  915. Pivot Tables
  916. move selection after entering data
  917. Excel Macros
  918. Excel 2003 won't save customized changes
  919. SUM function doesn't calculate with blank cells
  920. "Sum" formula not working!
  921. Open Books with VBA based on certain string
  922. protect cell ranges in spreadsheet and have data filters on
  923. CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)
  924. adding and subtracting using vb code
  925. Missing sheets in a shared workbook
  926. Adding a Hyperlink
  927. If-Then-Else Statement
  928. How to replace '0 with a 0?
  929. Scientific Formatting takes over - how to stop...
  930. Pivot table - repeat header on new page
  931. Formula
  932. Excel 2k3 query path to current directory
  933. LEFT Worksheet function
  934. Date formulas
  935. "#N/A" Result From VLOOKUP Formula
  936. Excell vba getting error after searching 256 columns
  937. Upper / Fill Series Function in Excel
  938. Protect Sheet: clicking in cells removes all previous text
  939. Protect Sheet: clicking in cells removes all previous text
  940. How to add todays date (static) to the current active cell using m
  941. Excel Formula w/ Time format
  942. Does a format in Excel change when another user opens the file?
  943. Personal.xls error - "file Is already open"
  944. Saving a text file macro
  945. vlookup / if ?
  946. forms, web queries, etc.
  947. Parseing Text strings
  948. Data sharing
  949. convert number to word
  950. Pivot Table Still Dropping Data
  951. Creating Column and Rows labels in excel 2003
  952. The Formula Bar disappeared. How can I get it back again?
  953. In Macros within the autofiltered icon to change data how possible
  954. pull down arrows for list "disappeared" in 1 worksheet but not oth
  955. adding a group of numbers in Excel
  956. Code returns TRUE instead of value
  957. Not working HELP
  958. Mod function
  959. Error message in macro to insert new row?
  960. % in a cell
  961. text in a formula?
  962. Excel graphs
  963. Tax % in a cell
  964. adding and subtracting using vb codes
  965. how do i format carriage returns for each cell in excel?
  966. excel 2003 formatting toolbar
  967. Saving Error
  968. Custom formatting for text cells
  969. header & Footer in excel
  970. Calculate % (7.75) in a cell for a different cell
  971. option explicit
  972. how do i pad cells so text not at edges
  973. Validation - Ensure Cell values match
  974. adding worksheets
  975. Cell name
  976. HOW DO i GET THE CONTENTS OF A CELL TO BLINK?
  977. Excel 2003 Maximum File Size
  978. Convert date format from 20060801 to 1st Aug 2006 (or similar)?
  979. In Macro How can i Change Autofiltered data one by one
  980. Jump to a cell and then back again
  981. Comments get deleted in a shared Excel file
  982. how to hyperlink entire column in Exel sheet
  983. hyperlinks fail after saving
  984. hyperlinks fail after saving
  985. copy and paste with multiple selections in Microsoft Excel
  986. copy and paste with multiple selections in Microsoft Excel
  987. Microsoft Excel
  988. How can i Change Autofilter data from top till bottom in macro
  989. Conditional Format
  990. Pulling data from sheet to mastersheet
  991. after 15 digits in excel sheet i am getting zeroes
  992. template for tenant invoices
  993. How do I make my spreadsheet so part of it has it's own scrollbar
  994. Column References in Macros
  995. Date problem
  996. What defines the column width intervals?
  997. Sorting
  998. How to keep 0 for military time
  999. gas mileage template
  1000. I format for date but it is calculating