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. Changing column heads from ABC to 123
  2. Entering data
  3. Formula
  4. Rotate column headings - ???
  5. Protecting Spreadsheets
  6. Average Duplicates in Excel
  7. PC name vs User name for shared files?
  8. program for address labels for wedding invitations
  9. How do I set up alternate row shading with Excel 2003?
  10. Excel 2007 File New options
  11. Sum multiple sheets?
  12. I've dragged columns back in Excel
  13. Formula Bar in Excel
  14. Shaded out Unprotect Sheet...
  15. Move cursor one cell to the right after entering data
  16. Publishing Entire Workbook without Interactivity
  17. List
  18. Read From Files
  19. Format to: S-M-T-W-T-F-S?
  20. can I format numbers in the yuan currency?
  21. Isolating letters for a formula
  22. formulas in conditional formatting for 2007
  23. Error on a excel 2003 file to open in excel 2007
  24. again...
  25. How can i filter data type in a cell?
  26. how do i force users to first enter data in one cell before anythi
  27. How can I delete the contents of a cell without deleting the formu
  28. Formula for cells
  29. num!
  30. Count non-blank cells?
  31. Import raw data into different worksheet
  32. how to duplicate rows?
  33. How do I direct cursor to a specific cell?
  34. Selecting the value from a randomly selected cell out of a range
  35. adding time in columns
  36. Group into rows by every change of Column A
  37. Select All checkboxes
  38. LOGIC
  39. Lock Relative Cell Positions?
  40. Protecting Headers and Footers!!
  41. ComboxBox with Dynamically Defined Source, and LinkedCell error
  42. Excel mail MAPI error
  43. Formula to match data
  44. Combo Box
  45. How do I get the Excel2007 bar (w/ home/insert/etc) to stay down?
  46. Rotate the display of a spreadsheet
  47. Excel 2003 - Tab Function
  48. Showing Comments
  49. Extracting part of data
  50. "Save As" problem with Excel 2003
  51. Disable conversion from text to number from .csv file
  52. formula cant be entered
  53. Lists
  54. tabs at the bottom of my worksheet
  55. Extend formula hotkeys?
  56. referencing worksheets
  57. Cell appearance
  58. 2003: Autofit merged cells
  59. Empty Cell Custom Format
  60. Return search value, not starting position
  61. RE: How to upload a Macro "Add-In" file onto EXCEL 07 workbook
  62. Roundup in VBA
  63. Delete Rows
  64. Excel 2003 crashes when open new workbook
  65. SUMProduct / Count
  66. Publishing Webpage?
  67. formatting within a cell
  68. eliminate text wrapping within a cell?
  69. Hyperlink PDF Files
  70. Excel Book.xlt is not open as excel default workbook
  71. Create button to run Macro?
  72. Calculate days
  73. Autofill data in cell with other existing data.
  74. range limit
  75. conditional validation
  76. date code validation
  77. how to change the default cell format
  78. modify a line code
  79. ceiling
  80. Combo Box - Crashing for Excel 97 users
  81. merging data when the primary identifiers have changed order
  82. Copy as picture.
  83. Link between a cell and a cell on another worksheet
  84. FILES WON'T OPEN
  85. Can I open a file with access denied for no known reason?
  86. Sumif criteria
  87. How do I average time (in text format)
  88. fill colour
  89. Nested countif,or
  90. Can I create a custom header that depends on cell contents?
  91. Cell Contains Value
  92. COUNTIF with 2 conditions/columns
  93. Count to find the number of 100% 90% 80% in a column
  94. Stop a loop when certain data is found
  95. Time Formatting Problem
  96. Function and Sub
  97. Return value for a function.
  98. how do you put columns in alphabetical order by last name
  99. conditional formatting
  100. Sumproduct Question
  101. Linking Graph title to a cell
  102. refering to other workbooks
  103. converting
  104. Progress Bar
  105. Transferring data from column to another without VLOOKUP
  106. Need linked cell to be blank not 0
  107. Skipping Folders
  108. Hyperlink Error
  109. Convert Text to a Formula
  110. VB 6
  111. Sorting Cells with Conditional Formatting
  112. VLookup Pulling Data from one row above
  113. possible?
  114. Reporting on multiple worksheets
  115. Format results from using INDEX
  116. Need help with a Macro
  117. My data won't show
  118. SUMPRODUCT question
  119. Getting the correct reference cell to work
  120. error message saying no more new fonts may be applied
  121. Safely sending spreadsheet in e/mail
  122. multiple vlookup; index/match
  123. vlookup to populate drop-down
  124. Excel footer to look like Word footer?
  125. More Hyperlink Cell 'Relative' Questions
  126. Validation List
  127. 3rd Conditional format
  128. How can I get each worksheet tab name to pull from cell C3?
  129. tabs missing on Excel 2007
  130. Times
  131. picture detail
  132. Addins for Excel 2007
  133. Mass Changes in Excel using Wild Cards or other
  134. How to write a "change macro"
  135. Excell
  136. Pivot Table column sorting
  137. date
  138. How to separate numbers and alphabate from a cell
  139. Paste Word into Excel-no floating
  140. Formula Question (with a name)
  141. queries in excel
  142. Don't want to hide anymore
  143. Replacing part of a (too) long formula
  144. Using a macro to make a list from results
  145. Using a Macro to make a list from results
  146. #N/A
  147. If 2 columns have #N/A
  148. Calculating a date with term
  149. Multiple IF and VLOOKUP
  150. çok işlemli formül yapmak
  151. INDIRECT function
  152. Go To Visible Cells - In Excel 2007
  153. Excel - sumif not updating properly
  154. how to show the total in a pivot chart
  155. stop prompt to save on no changes made
  156. How to find & delete a particular pattern of text from values of a
  157. AutoSum turned off?
  158. Replacing an empty cell
  159. Upper Case Letters
  160. HOW TO SPLIT ONE ROW INTO TWO ROWS
  161. extract non zero valus from a list.
  162. sum a column range basing on financial year.
  163. Look up a value in one column and give a corresponding value
  164. How can I do an alpha sort on multiple spreadsheets for easy ref
  165. auto adjusting for calculation when a row is added
  166. Relative/Current Cell Reference in Hyperlinks
  167. I need the cell to read 0
  168. HOw to use Monte cARLO sIMULATION IN eXCEL?
  169. How to use Monte Carlo Simulation in Excel?
  170. couple of questions
  171. How do I analyze data using time periods?
  172. Sum of Alternate Cells
  173. Forcing Save as in the format of Excel 2007
  174. Deleting pages in Excel
  175. #N/A problem
  176. can you??????
  177. solver fourmela in excel
  178. labelprint.xlam file not found error appears when excel starts
  179. Moving data from one worksheet to another in automated, linked, or
  180. Retrieving printed unsaved sheet
  181. BAHTTEXT() Anyother such function return the value in Eglish Txt?
  182. Conditional Format (Todays Date)
  183. Linking 2 worksheets
  184. Turning off Close Button
  185. Excel 7, paste linked to word becomes black when word pdf'd
  186. Show difference between tow numbers as a + or - value.
  187. Customized keyboard shortcut on excel
  188. My tab key jumps to the next page, not the adjacent, cell, help...
  189. Concatenation and Copy Down
  190. Links in XL worksheet
  191. Contents Card
  192. I have 16 graphs. How do I print four to a page?
  193. I have 16 graphs. How do I print four to a page?
  194. MATCH function...AGAIN
  195. I cannot remeber my Excel password.
  196. How can I get JUST a stock price quote w/o all the comments?
  197. Calculation money entitled for official trip
  198. Listing top 3 numbers
  199. Can i open an excel file and print it automaticaly from outlook
  200. MATCH - HYPERLINK functions...COPY DOWN
  201. Last Value Greater Than Zero
  202. Lookup...?
  203. If function
  204. Error
  205. can I open a excel file made on a XLcomp W/A vistacomp. MSWord?
  206. averaging based on several criteria
  207. can you??????
  208. Count Number of Discrete Cells, Based on Another Column
  209. deeper/more conditional statements per cell
  210. How to assign text to forms
  211. set gridlines to print by DEFAULT in Excel 2007
  212. Page Break 10% and not adjustable
  213. Pivot4U Excel Add-in - Edit Pivot Tables in Excel Directly
  214. Open Excel 2002 Attachment from Outlook 2002
  215. Totaling Subtotals
  216. Change negative nmbr to positive
  217. Deleting Rows in A Pattern
  218. not enough resources
  219. Excel 2007 Macro specific table to generic table?
  220. Format cell to convert to Upper case
  221. Making weekend days working days - the system cuts the working tim
  222. Lookup values
  223. Fixed Footer
  224. Average same cell in multiple sheets
  225. Multiple Column Filter
  226. Renaming a sheet
  227. Splitting a multi-column table in single columns
  228. Conditional Formatting with Icon sets
  229. Reduce file size in Excel
  230. How do I turn 1 cell into 2 cells without adding columns or rows?
  231. Difference column in PivotTable
  232. Control Select doesn't shade cells
  233. Automatic updates
  234. Formatting Linked Info
  235. extra columns
  236. Assigning Row Number to TextBox
  237. Report Filter in PivotTable
  238. unhide all?
  239. Updated times stamp of last change
  240. exporting comments into a separate spreadsheet?
  241. Creating weekly summaries
  242. Tracking Changes by user
  243. Increase rows by 1 when moving data from col. to col.
  244. help with formula
  245. Excel 2007: Add year to footer
  246. How do I find more buttons on formating toolbar?
  247. need to average based on criteria
  248. External links
  249. IF statements
  250. Folder Network drive
  251. Complex Countif
  252. Excel 2007: Word wrapping in merged cells
  253. MATCH function
  254. Data sorting problem
  255. Paste link, showing #### in one cell
  256. TO mr t.valko...
  257. Formula/Shipping Chart
  258. why do my excel files keep disappearing after I read them?
  259. Group by
  260. Excel Lookup
  261. Matching cells to files
  262. Attempting to compare and deduct values based on date codes
  263. rounding error?
  264. average if nothing is there
  265. MATCH -- HYPERLINK functions
  266. Re: ActiveX
  267. Finding percentages
  268. Looking for a formula for comparing dates and decreasing values
  269. I want to Autoformat in Excel - like Word. How?
  270. All Files Close
  271. changing signs in formulas and cells
  272. averaging with a filter
  273. Data Transfer
  274. How to refresh a Scenario PivotTable Report?
  275. Sum If formula for between dates
  276. Hyperlink on Websites Addresses
  277. is it possible to reference a tab name within a cell by formula?
  278. If statements
  279. problem format or something else ))
  280. Macro Running Painfully Slow!
  281. Find / List all
  282. List specific worksheets
  283. autosum on a column
  284. Excell 2007 Gridlines and Automatic Colors
  285. datalookup
  286. Countif Conditions - Use of conditions that vary by cell value
  287. Get a text in for specific day sumproduct / dget
  288. Combo chart?
  289. How does one apply letters with accents
  290. Drop down menu display based on the value of different cell
  291. how do i force an value to "jump over weekends"
  292. WHY DOES DATE FORMAT CHANGE IN COLUMN
  293. Preventing other users from opening hidden worksheets
  294. Remove row & column headers
  295. transpose data
  296. Show a message but not in MsgBox
  297. Formating
  298. Stop cell reference in formula changing when insert column?
  299. If - Then - Now what?
  300. Barcode Sequence
  301. excel won't automatically open attached email excel files?
  302. Excel-Quick Parts Request
  303. Excel-Default Font for Headers and Footers
  304. Solver
  305. Hyperlinks don't work when sheet is hidden
  306. how to preserve PivotTable borders and colours on refresh?
  307. create a button in spreadsheet
  308. Pivot Tables
  309. using excel data for a word macro
  310. Joins semicolon seperated text in two cells
  311. Conditional Formatting Question
  312. Sorting a date by month, date and then year.
  313. Using Multiple Worksheets
  314. Macro wait 30 seconds then Complete the Macro
  315. CountA - using two columns of data
  316. Pivot Table Detail Refresh
  317. formula locking?
  318. "Send To" Missing From File Menu
  319. Floating a CommandButton
  320. Paste link
  321. Excel Not Deleting .tmp Files When Closing
  322. Moving worksheets to another book - 2nd book will not appear
  323. Vacation formula
  324. How can I export a document from Excel to yahoo senders
  325. COUNTIF SPECIAL NUMBER
  326. Macro Read Only If Statement
  327. Excel 2003 column formatting question
  328. Copying Excel Sheet for data that is reliant on an equation
  329. DAVERAGE
  330. Excel File on Treo to dial phone numbers - repost
  331. 2007 Compatability
  332. look up value on tab name?
  333. Combining date to one cell with uniform results
  334. conditional formatting OR formula
  335. List Box - Change Font
  336. Pulling data from multiple files
  337. excel text box tab
  338. important!
  339. Question about Advanced Filter
  340. Compound Document
  341. troubleshoot - mouse scroll
  342. Move Column Retain Formula
  343. Pick the low number in a column of Numbers
  344. Batch Convert 2007 Excel files to 2003 format
  345. Excel 2007 vs previous versions
  346. Adding different numbers
  347. Excel 2007
  348. Converting numbers
  349. Words equal numbers
  350. Unique values within a list
  351. Macro limitations
  352. Vlookup, Index, Match every instance.
  353. Slow Grouping of Rows
  354. Problem with Conditional Formatting and Greater than or equal too
  355. How to set up so that if I enter an "X" in one cell it would color
  356. Data Coding
  357. Return value in 3rd column based on 2 other columns
  358. Any way to hide a cell or row from printing?
  359. help ...
  360. COUNTIF - Not an Error
  361. CSV text data altered on file open
  362. Grouping Toolbar Disappeared?
  363. My exact "text" statement is returning a value of 0 for false??
  364. Adding into cell
  365. change A4 to letter default
  366. Spreadsheet Size Limitations
  367. Formula
  368. Excel formula question
  369. Deleting Rows in a Pattern
  370. How can I make the sheet tabs bigger and wrap the name on 2 lines
  371. How can I make the sheet tabs bigger and wrap the name on 2 lines
  372. How to Change the Cell Padding
  373. averaging info from three columns
  374. Compare and Copy
  375. Remove a character from a number field
  376. Referring to Cells
  377. Saving Pivot Table views
  378. Excel hanging...
  379. Problems with "Send to email recipient" in Office 2007
  380. Working with multiple sheets
  381. Using Match and Index
  382. how do i draw up a table to do my own 5 generation dog pedigree
  383. need error loop in pivot table routine
  384. highlight cells that have dependents
  385. scroll to or hyperlink to a cell from a value entered
  386. lines of conditional format
  387. Automatically Highlight every 22nd row
  388. using web queries
  389. Cannot format my excel sheet
  390. character map
  391. Converting comments attached to cells into data
  392. Search and Replace Entire Cell Content
  393. cell format unpredictable
  394. how can you let macro determine to where to copy
  395. Assign Cell Values without a Loop
  396. Excel Lags When Keying Numeric
  397. count text appear how many times & put in respec col??eg 1st times
  398. **URGENT** - Using If Or And But functions ?????????
  399. Merge limited data field
  400. COUNTIF and wildcards
  401. Need magic Excel formula for Date calculation
  402. Mark active row in column A (VB question)
  403. Text Will Not Display In Cells
  404. Excel 2007 Macro Help (Excel 2003 not working in 2007)
  405. Earned Vacation time Formula
  406. averaging formula from three cells
  407. how to left-justify zero-filled cell Exl2007
  408. I need the cell to be blank instead of showing #DIV/0!
  409. need a formula to look up values in two columns
  410. Original Pivot Table Defaul Format
  411. Formatting/Formulas
  412. Vlookup Question - Reffering to a column other than the leftmost?
  413. Drop Down Box containing a symbol
  414. Fill repeating Numbers
  415. Index,Match,Small
  416. Excel files open in a blank window.
  417. Code to send email to address within selection in Excel workbook
  418. Linking Cells, What Formula do I use?
  419. averaging from another page
  420. Worksheet row limitations.
  421. Excel Lists - get an item in a list to automatically bring in info
  422. identify list used in a cell
  423. In Excel I type 24E1 in a cell it changes ...
  424. Is it possible to display a worksheet within a worksheet?
  425. Calculating an interpolation
  426. Calculating an interpolation
  427. how !!
  428. Print conditional formatting
  429. Name stays, everything else scrollable.
  430. Increase number of items shown in drop down list?
  431. Analyzing Access Report with Excel
  432. How do I create 5 Conditional Formatting rules in Excel 2003?
  433. Time conversion & adding
  434. can I have the cursor go to same row/column in each sheet
  435. START UP FORMS FOR DOG WALKING BUSINESS (HELP )
  436. Macro if and / or statement
  437. Conditional Formatting
  438. XY Scatter-problems with large data records
  439. Debug on userform
  440. Deleting Rows In A Pattern
  441. calculate a particular date
  442. Move entire row if it contains specified text.
  443. Convert list to table
  444. countif, range and criteria
  445. F9 Training
  446. how do I limit the number of rows when exporting data into excel?
  447. Excel 2007 GetPivotData Function
  448. Help with VBA
  449. Multiple files opened when Excel started
  450. excel 2007 time function
  451. Existing form in excel; added a combo box; tabbing wrong now
  452. Questionaire to evaluate the level of Excel
  453. VLOOKUP gets wrong value
  454. # sign appearing in text boxes, Why?
  455. how do i remove template help functions
  456. Problem using vlookup to get values from another file
  457. Using vlookup to get values from another excel file
  458. Find empty cell then stop
  459. match data
  460. conditional formating on dates
  461. Custom Cell Format - Please help!
  462. 'Calculation' showing on my excel spreadsheet (VLookups don;t work
  463. Limit on number of comments in a worksheet
  464. Listing values that meet a criteria.
  465. import external data problem
  466. Time convertion based on condition
  467. How do I protect an object in worksheets?
  468. How can I write 3/5 in a cell and have it look like 03-May back?
  469. Listing Multiple Finds
  470. Converting comments to data
  471. adding lines to a list
  472. REFERING TO CELL IN DIFFERENT SHEET
  473. Easy menu start
  474. If a number is between 1 & 4 then do X else do XY
  475. how do i make a continuous data table
  476. Filling in a table with changing range values
  477. How do I make a template in excel?
  478. Adding numbers
  479. how to figure
  480. Printing on large paper
  481. Excel - password protect error
  482. benefits statements
  483. Delete mass rows from excel
  484. Extract text
  485. Pivot Default
  486. how to make left side stay still and right side can move left to r
  487. linking different worksheets in a workbook for a formula
  488. Pop Up Calendar
  489. Delete Unnecessary Rows
  490. Averaging from a cell to the bottom of the list
  491. XLR files
  492. Digital signatures in Excel 2003 workbook
  493. List of CommandBars & Control IDs
  494. formula results in the status bar
  495. Right-click --> "Open as read only" option for a .xls from Windows...
  496. filter and save result
  497. Changing worksheet tab colors
  498. Consequtive total
  499. Custom Format Numbers to $$
  500. Thank you
  501. Tried the following and still can't get it to work
  502. Excel problems after winXP sp3 update
  503. Reverse Fees Linear Formula
  504. Help excluding some info from counta formula
  505. How do I find a question I posted last week?
  506. Printing multiple worksheets in a workbook
  507. where is "copy as shown when printed" in excel 2007
  508. Excel 2007: AutoFormat for PivotTables
  509. Turning off a Toolbar
  510. mr t.valko ..help
  511. Tried suggestions - file still won't open - help?
  512. Vacation and Backup
  513. Find Fast Vs. Find Not-so-fast
  514. Getting Compile error - on this line
  515. SUMIF help
  516. Rows collapsed as subsets of other rows
  517. NEED HELP 2
  518. Check Boxes Grouped
  519. merge same valu and total the amount indicated
  520. Sumproduct - please add extra funtionality
  521. Spreadsheet doesn't show
  522. vlookup more than 2 range
  523. IF formula - odd/even months and different names
  524. how do i elmininate old data from Report filter on pivot table?
  525. Printing more than one page - Excel 2007
  526. Multiple Column Auto Filtering
  527. SumIf formula from one column based on criteria from two other col
  528. How to return multiple results in a cell
  529. Product of Hrs & minutes times rate per hr to give a cost
  530. formulas
  531. Changing from upper case to lower case
  532. Your Office has stopped working
  533. Pop-up
  534. how do i design a macro
  535. Currency format in Excel
  536. Sumproduct by date
  537. If I change a point for a coma between two numbers format dont cha
  538. Add to My Places Option Tools Menu
  539. parenthesis
  540. NOW() help in xl could use some
  541. get HOUR check from NOW() cell
  542. Merged cells/wrap text
  543. Data filtering(?) Question
  544. Excel File Won't Open
  545. Validation Filtering
  546. Secondary Axis in a Pivot-Chart does not stay
  547. sheet tabs cannot be seen
  548. HELP ! Can Excel automatically do "Grouping"?
  549. Percentage of values in list
  550. excel on blackberries
  551. I require some assistance please
  552. UNexpected NPER results
  553. Help with Hr. Min formula
  554. received excel spreadsheet by e-mail, howd i open without excel my
  555. from daily data to weekly data
  556. Excel Timesheet Error
  557. thanks mike and gtvto6 but still stuck ;
  558. how do i turn off calculation of cells
  559. FOUND SOLUTION THANKS ANYONE WHO REPLIED
  560. cells
  561. NEED HELP
  562. How do i remove a constantly appearing % in a cell in excel?
  563. How to copy only nonblank entries in sheet
  564. Macros
  565. Link monthly balance to summary spreadsheet
  566. Wrong Teaching of Excel
  567. text and numerical values in two columns
  568. file sharing
  569. vlookup for more than 2 range
  570. vlookup
  571. Installed new heatsink fan lost all color options in excell
  572. Auto Backup another folder
  573. lookup
  574. disable key combination
  575. Using IF
  576. Error: The macro 'FreezeHeader' cannot be found
  577. inserting a number from a particular cell based on if/thens
  578. Update values in WkBk1 from WkBk2
  579. Trying to change the background of a cell if I type a certain word
  580. Using Lookup with GT and LT Columns
  581. deleting columns on multiple sheets
  582. Pivot Table?
  583. Excel 2007 Gridlines Disappeared
  584. Referencing sheets
  585. all General formats of the workbook changed to date format suddenl
  586. QUATTRO .QWP FILES INTO EXCEL
  587. Toggle show / hide group outline symbols with shortcut
  588. Problem with Regression function in 2007, Analysis Tool Pak
  589. Obtaining just the Year out of the date
  590. VLOOKUP not working
  591. advanced filter
  592. collating data
  593. How to show columns/cells in sheet but hide them in print?
  594. how do I change text direction in Excel doc
  595. dynamicaly linked themes
  596. How do I change the worksheet or workbook direction
  597. find the phrase with a group of text in a column
  598. Picking a name from a list
  599. use macro to set auto( about clipboard )
  600. #VALUE! (ANY HELP)
  601. print out specified range in macro
  602. all the general formats of the workbook suddenly changed to date.
  603. #value!
  604. Does Excel have an operator similar to LIKE?
  605. Macro to copy active worksheet to new workbook
  606. How to sum the last 7 number in a row?
  607. How to do this VLOOKUP OR FORMULA.
  608. how do i have a cell number increase by 1 each time file opened
  609. Sort with IF functions?
  610. color formula
  611. excel 2007 multiple data selection colour
  612. CHANGE RIGHT CLICK OPTIONS
  613. Show Codes for Data Validation lists?
  614. Running Balance
  615. Updating Downloaded Templates
  616. date range prroblem
  617. #DIV errors
  618. Update Cell in WKBook 1 From WkBook 2
  619. hyperlink
  620. VB 6
  621. Excel and "Real-time" feed
  622. Change of behavior in Combo Box
  623. Import to the next blank row
  624. Excel Footers
  625. Scan column for first of a list
  626. compare and move numbers
  627. Corrupted Worksheet
  628. Search Columns for a word and stop
  629. Locked cells
  630. Fixed 'Find' or 'Look up'? cell - is it possible?
  631. How do I count repeat Occurrences
  632. freeze pane: freeze from two worksheets?
  633. if and then
  634. A text to appear on a mandatory cell
  635. Restricting Cell from being Printed
  636. No need to use = sign in formulas
  637. how do I turn on document "editing time" found on advanced proper.
  638. FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADOVBScript, SAP - ABAP
  639. custom formating numbers
  640. Is there a formula that exists...
  641. opening Lotus 123 files
  642. WHERE IAM
  643. how do I insert Item numbers
  644. How to export large amounts of text data into single reports
  645. how to select no.'s in a column that differ by <1
  646. Source of historical intraday stock prices?
  647. Logical Test Question
  648. Formula for time, possible?
  649. not enough resources! please help
  650. Rounding to integers and adding plus sign
  651. location
  652. Slash Zero
  653. Dual Sided Printing
  654. Adding a line to my CF column graph - help!
  655. Shapes in 2007 from 2003
  656. Can not scroll worksheet
  657. Cursor group hang
  658. calculating time
  659. How do I sort by ranges?
  660. Conditional Formatting Row & Text
  661. Sum Total with minus in different cell
  662. HOW DO YOU
  663. help with formula
  664. Calculating time in minutes
  665. Rank If?
  666. deploying data
  667. Find worksheet
  668. How can I disable all hyperlinks in a spreadsheet?
  669. Inserting text into a PDF form?
  670. How do I make a Bar code ???
  671. Pivot table group help
  672. Export Format
  673. VBA code to fill down
  674. counts
  675. Excel shared workbook error only comes up on my system
  676. duplicate
  677. Deleting duplicates - kind of
  678. Date Question
  679. How do I undo a sort?
  680. Formatting and allow users to edit ranges (excel 2003)
  681. How to change the size of characters in Sheet 1, Sheet2, Sheet 3
  682. how to convert number of days to months
  683. Can fill handle be moved without mouse dragging?
  684. Why are some cells returning blank when I import external data?
  685. carriage return in text cell in excell
  686. changing Y axis
  687. Formatting Date Field
  688. FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADOVBScript, SAP - ABAP
  689. Pivor layout changes with refresh
  690. Add new subtotal lines
  691. Speed of Replace Range
  692. Advanced Text to Columns??
  693. Drop down lists
  694. Dynamic File Name Problem
  695. reading email
  696. Get data with certain conditon
  697. Slow speed opening XLSM compared to XLS
  698. Slow Saves with Excel 2007 on Vista
  699. Insert row/column error "Cannot shift object off sheet"
  700. Decimal Values
  701. Encryption...Password issues...help
  702. Excel 2003 - copying word to excel
  703. chart macro
  704. Selectively printing
  705. Colours in Excel 2007
  706. Paste and Past Link - Excel 2007
  707. Excel 2007 - Format of New Documents
  708. how,,
  709. Numeric values as character in CSV
  710. formula
  711. formating and date changes
  712. Excel hh:mm format
  713. Excel ROI Calculator
  714. Complex Pivot Table Function
  715. Complex Function
  716. Compare dates and unique identifier
  717. Look up from spreadsheet based on 6 criteria
  718. Excel: "Margins do not fit page size"
  719. copying row to row
  720. Convert a number to Text
  721. Form If IsEmpty Syntax
  722. Possible to create a customize Pivot Table Template?
  723. How do I give consecutive numbers to a form when I'm printing it?
  724. Disabling formula
  725. Average if
  726. rounding question
  727. Inserted raster image prints distorted
  728. Left, Right & If Function
  729. Internet amortization answers differ from function
  730. OFC 07 wrkbk saved short date format changes to general when reop
  731. change array to simple columns
  732. Logic Statement
  733. Transfer Comment to VLOOKUP Cell on Search
  734. True/False Comparison of Dates
  735. how excel and access self training is possible
  736. Picture popup
  737. How to calculate hours in a cell? Example [12-4] = 4 hrs
  738. Conditional formatting overwritten with copy
  739. HOW DO I: Automatically colour a row according to cell content.
  740. Selecting Autoshapes in Excel 2003
  741. Function buttons or shortcuts
  742. Change tab color based on current color of a cell
  743. Multiple inputs on a spreadsheet
  744. Excel 2007 and Autoshapes
  745. Where is the link? (non-rectangular reference)
  746. Always Create Backup - option is not working
  747. multiple wk sheets - running balance
  748. Print to Fit Problem
  749. Macro Button
  750. EXCEL 2007 Menus
  751. I want to print 1 page. Excel makes it 236 pages?
  752. Advanced filter criteria
  753. formula or filters
  754. Center text in Excel 03 cell by using the keyboard?
  755. Indented Bill of Materials?
  756. Display Size Limit In Single Cell
  757. Subtotals
  758. save only active sheet Button.
  759. excel
  760. SHIFT + CONTROL + DOWN ARROW is not working!
  761. dropdown list
  762. Excel 2007 crashes with large linked Excel 2002 workbooks
  763. convert to GBP - formula to identify 1st character and Acc type
  764. converting to regular date format
  765. 2007 Compatability Pack for Office 2003
  766. Vacation accrual Spreadsheet
  767. Combining a string of text
  768. Advanced filters.
  769. error says "file format not valid"
  770. Duplicates
  771. Formula
  772. Can I change the default cell selection highlight colour
  773. Selecting sheet with VB
  774. Importing Filenames for Memory Re-Call
  775. import filenames
  776. How do I interpret the result of a chitest?
  777. database and date
  778. Formula
  779. How do I show the current month in a date field?
  780. average values and reduce and simplify the worksheet
  781. bugs in microsoft exel 2007
  782. Look up 1 value and return a set of values
  783. Use and navigate through option button on w/sheet
  784. Search a value in all w/sheets and make a list.
  785. How to save Excel 2007 compatible with excel 2003
  786. Search a value basing on another value
  787. Search for occurence of any item in table
  788. Ignore blank checkbox-Data Validation
  789. Disable Do you want to save changes
  790. Move text
  791. How do I copy cell attributes between worksheets
  792. Convert numbers to text string
  793. Default column width for .csv files
  794. Excel 2007 seems to pause for 1 min before opening even small file
  795. Hide and lock cell formulas without affecting Macro?
  796. floating header
  797. Sum text
  798. wrap formula text
  799. can you
  800. add blank row in an if statement
  801. how do you?????????
  802. how ??
  803. Conditional Formulas
  804. Need Sum of 2 columns if one is filled?
  805. Web Query fails with "you need to upgrade flash" message
  806. How to print multiple pages per sheet
  807. resizing individual cells
  808. Text to Columns
  809. I want to add dashes in a cell which has both number and tex
  810. Deleting Duplicate Data in Two Worksheets
  811. Excel Question
  812. CLEAR ALL SELECTIONS IN THE ADD SUBTOTAL TO BOX
  813. running total where old data is replaced by new data
  814. Updating Pivot Tables
  815. moving average & rank
  816. Publishing a static table as html using jscript (Excel 2007)
  817. Re:"compile error in hidden module": DISTMOD -- ideas to fix it??
  818. formula to change figures into words
  819. Formula to change figures into words
  820. Problems with linking note books and switching to a new computer.
  821. two formulas
  822. Pivottable
  823. Paste conditional formatting rules
  824. using THREED function with VLOOKUP to sum across multiple workshee
  825. Cell contents get cut off when pasting
  826. Button to produce Popup
  827. Pasting Tables together in Excel - Contents get Cut off
  828. cant open short cuts
  829. Date formula excluding 1 day
  830. nest macro in a formula
  831. Hide columns if specific cell is blank?
  832. todays date
  833. Can I automatically change all positve numbers to negative number.
  834. Single cell access
  835. (1,100.00) hot key ?
  836. Date value won't work in formulas.
  837. Insert 8 Rows
  838. OLAP Pivot Table problem
  839. numbering rows in a simple spread sheet
  840. Why do dates change when I copy/paste into another sheet?
  841. Add half hour
  842. How can i hide cells using formula if the cell has no value?
  843. Concatenate question
  844. Cell format dialog box will not open
  845. how do you change the paragraph spacing in excel 2007
  846. Formula: figures to words
  847. How to Format a Nested Function (Bold)
  848. Sequential dates across worksheets
  849. Hyperlinking
  850. Capitalize text when input in cell
  851. How do I correct an incorrect total from a simple formula?
  852. Disable cell reference insertion with PageUp in cell edit mode.
  853. Macro that uses a cell value to copy another cell
  854. Exclude HTML code
  855. Select proper charts to resize
  856. Chart axis labels cut off
  857. Help, how do you open dialog box to filter a column
  858. Help, need macro command that will change #DIV/0 to 0
  859. Documenting spreadsheets
  860. help sorting multiple sheets
  861. Summing Fields 2
  862. secondary axis problem
  863. Advance filters for dates
  864. Making a Matrix into a column.......
  865. filtering
  866. File crash when I try to open
  867. How to delete names on worksheet?
  868. List of Permutations when 2 letter is taken at a time
  869. Recover Macro
  870. Summing up digits in a cell
  871. Custom View Grayed Out
  872. SUMIF funkcion example
  873. Convert multiple workbooks to different worksheets in 1 workbook
  874. can i use one workbook to perform instructions i another
  875. fORMULA
  876. Sum
  877. separate 2 different lists
  878. How to display month in 2 digits?
  879. Summing first 2 characters of a cell (some non-numeric)
  880. Forgot the Password
  881. enter
  882. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :(
  883. adding cells upto and including a specified cell
  884. Converting Text to Function
  885. Refresher on for Next Loops
  886. excel template download issues
  887. Efficient data clearance in Excel spreadsheets
  888. Repost for Ron
  889. Custom Format ... (#,##0.0_"lbs"@
  890. make all cells in same row match cell formatted with fill color
  891. Count Characters in a cell
  892. Find and remove data from a column
  893. Listing of excel files in My Documents
  894. only one sheet tab shows up
  895. In Excel, how can I show very long text in a single cell?
  896. Check if all formula's in a column are linked to the same file/folder
  897. insert an extra row or collum
  898. Web Query question
  899. Excel Opens EVERYTHING!
  900. Strike-throughs and equations
  901. Adding Picture to Locked Spreadsheet
  902. How do I save sort settings in Excel 2007
  903. Macro
  904. adobe to excel
  905. Previously answered question
  906. VBA View Settings
  907. moving totals
  908. If Statement
  909. Adjust %'s across cells
  910. Merge rows from 2 XLS files using a common key field.
  911. Is there a way to short this substitute formula?
  912. IF functions - more than one condition
  913. RE: Setting macro security level to "low" permanently?
  914. Rounding up to the nearest 1/8"
  915. Selectively replace cells based on two ranges of criteria - nestedIF() statements?
  916. Scrolling Behavior
  917. Need command line to change the results in a cell from #DIV/0 to 0
  918. Continuing Macro
  919. Need No leading "0" and 3 decimal points?
  920. IF-more than 7 arguments
  921. Transpose list of address into rows for mailing list
  922. Summing Fields
  923. worksheet/file name :1 :2
  924. Sum Based on Exception
  925. Sumif cells of a certain format
  926. Password protected Excel File
  927. todays date
  928. Excel 2007 - Formulas not carrying over
  929. Nothing shows in formula bar!
  930. True/False Comparison
  931. select cell by variable name
  932. Keyboard Shortcuts for Paste Special Values and Formats
  933. Formula Not working
  934. coverting numbers format
  935. Data Validation List Not Showing
  936. Hiding rows which equal zero sum value
  937. Dialogue Box
  938. If And/Or statement for comm calc criteria
  939. HOW DO I ALPHABETIZE MULTIPLE PAGES OF A SPREADSHEET?
  940. Auto pull 3 cells into 1 cell at different location? (Excel)
  941. Excel 2002 : Need patching for formula failures
  942. copy conditional formatting
  943. Countif with two terms
  944. Merging Two Columns
  945. adding one less every time
  946. Excel - Mail Merge
  947. Toggling on/off auto calc
  948. Typing on Excel
  949. Multiple picture inserts via dropdown lists
  950. Right click on rows and columns does not give menu
  951. Conditional Formatting Colour in a Column Graph (Excel 2003)
  952. excel and word
  953. Office 2003 Pro
  954. How to auto add data based on value in another column
  955. Need command line to change "#DIV/0!" into a "0" (zero)
  956. Excel Header
  957. Reverse Macro after it has run
  958. Too large a spreadsheet
  959. Converting Rows to Columns
  960. List of Permutations
  961. Count empty cells with a specific term
  962. military format of time
  963. Excel 2002 - Program breakdown while saving
  964. How to make a worksheet unchangeable by other users
  965. Pivot Table showing number "1" instead of actual result
  966. sumif with two different terms
  967. all the general formats suddenly replaced with date format.
  968. Olaptools
  969. IF AND OR BUT NOT SURE
  970. "Excel cannot complete this task with available resources"
  971. Invisible sheets
  972. Display a Custom Dialog Box
  973. Check Box Tool or Control Tip
  974. Formula
  975. Error Message - File will NOT save
  976. Formatting in Excel
  977. Counting colored cells
  978. Excel Changes My Last Digit to Zero
  979. Color coding by items
  980. Print Preview
  981. Label printing
  982. I need the cells to change based on age of date.
  983. How to show hided lines in excel
  984. Record keeping of points, etc.
  985. Excel Shape Macro
  986. Excel 2000 Cell Comments Did Not Carry Over from Office 2003
  987. Printing multiple excel files
  988. Return the value of a column heading
  989. 8 hour day
  990. Color a calculated percentage cell text red if results negative
  991. Adjusting To Current Row Range in Marco
  992. Can't save spreadsheets... file in use
  993. Any real good books to learn Excel 2003 that..
  994. PIVOT TABLE - MULTIPLE RANGES (ITEMS' SORTING)
  995. Creating a histogram and line on the same chart
  996. How to reset all the configurations Excel 2007?
  997. Linked Files - How to find reference
  998. Sharing Excel Files
  999. Spreadsheet opens very slowly
  1000. Code not working as expected.