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. Sorting movie titles? skipping The, A, An etc?
  2. Images in Excel 2000
  3. Best way to inser file property into and excel sheet (cell)
  4. Custom Formats
  5. how do i get annual percentage difference reports in excel
  6. Rounding
  7. combo boxes on a form
  8. How do I insert a "hard return" in a cell?
  9. Column Headings Scroll out of view
  10. can't undo
  11. How do I insert the degree symbol in a column of numbers?
  12. multiple lines
  13. Counting lines when using a filter
  14. How do I create a customer database in excel
  15. Change default font in exising workbooks
  16. Autofit makes rows too tall
  17. .xls to OE address book
  18. Working with minus figures
  19. Cancel a Link and a Macro
  20. Keeping track of loan payments and interest
  21. Setting Precision when using &"Characters"& in a cell reference
  22. Which excel viewer does one use for Windows 98?
  23. Marking all lines with same value when a second value is found
  24. excel group sorting
  25. how do I display a worksheeet in full screen view
  26. Rounding Formulas
  27. Interesting TIF file problem
  28. Update cell based on date range
  29. Automatic date
  30. drop down arrow missing from pivot table
  31. Round whole numbers up and down
  32. All values automatically change to zero
  33. what's the formular for time in payroll
  34. More than one formula in a cell??
  35. How do I change *.CSV excel file to column seperated file?
  36. Merge Question
  37. equation help in excel
  38. Attaching Help File to a User Defined Function
  39. What is a shortcut menu?
  40. What's "can't shift items off sheet" in Excel?
  41. Change number of markers in a graph
  42. Cell references - HELP!!!!
  43. Importing Excel -> Outlook Calendar
  44. how do you delete blank rows in a spreadsheet using an "if" funct
  45. Auto enter text if tick box checked
  46. how can i change a value in a cell from a formula in another cell?
  47. drop down arrow missing from Pivot table
  48. how to run a macro from a formula?
  49. Conditional formatting
  50. Finding the Best Price
  51. Opening Excel files in Explorer
  52. From Rows to column
  53. copy data from one worksheet to identical sheet in different workbook
  54. Mround to nearest 5 c
  55. Hyperlink from one sheet to the hyperlink on another
  56. Subtracting Cells formatted with Date AND Time to get hours?
  57. Input Box
  58. Problems with "Worksheet_Change"
  59. How do I stop Filter Mode from appearing in the status bar
  60. Setting default quantities
  61. Workbook Print Settings
  62. How do I Link 1 List to Another
  63. Drop down lists
  64. Problems Creating html files with excel sheet
  65. calculating a rolling mean
  66. Using forms to enter Data into an Expense Sheet.
  67. formula for inverse tan of a number with answer in degrees
  68. song list
  69. Deleting unwanted and empty rows...
  70. "RADIO BUTTON"
  71. how do i get excel on xp home edition
  72. Print problem..
  73. Arrow key doesn't move to cells but scrolls page?
  74. Time-out for InputBox
  75. make a list from the beginning and the end
  76. Weighed average if the adjecent column contains blanks
  77. How to assign a macro
  78. Why doesn't the spreadsheet file open.
  79. Re: Locate and Move specific cells
  80. how to auto insert rows in Excel
  81. Clearing unwanted or historical entries from header/footer dropdow
  82. How to Search for word in the Entire Workbook
  83. Excel XP cells are links
  84. Converting multiple worksheet to a single page worksheet
  85. Pivot Table Error
  86. Subtotaling problem
  87. Excel
  88. When I open my file, another file appears??
  89. PING Bob Phillips
  90. How do i lock sellected cells in a spreadsheet?
  91. multiple columns / rows to be referenced through a listbox
  92. excel 97 xml import
  93. How do I get a footnote to give the date Monday, 4 July 2005
  94. Extract middle initial
  95. Sum of Calculated fields in Pivot Table
  96. Self Calculating routecard
  97. PivotTable - calculated items?
  98. Pivot Tables - Row Selection
  99. MS Office 2003 Installation
  100. Create individual files from a row
  101. Excel won't allow me to paste certain Turkish characters.
  102. standard form
  103. Sum amount if = 2 value's
  104. paste special keep odbc link
  105. Marriage of two formulas
  106. How do I open Quattro Pro 8.0 to Excel 2002
  107. pane freezes when file is opened
  108. How to change the right-to-left worksheet to left-to-right workshe
  109. Assistance with bubble charts
  110. Message "class not registered" opening sheet with macros Excel 97
  111. Compare records in multiple sheet -> report
  112. Schedule a macro running
  113. Removing grids
  114. dd:hh:mm help
  115. Default file location keeps on changing
  116. wrap cell
  117. Cell color based upon cell value
  118. when I right click on a excel worksheet, I do not get the dropdow.
  119. Pls Help Me!!
  120. how do I compare occurances of countif of two values
  121. how to insert row or delete while the auto filter is turn on?
  122. How can I get the excel software only?
  123. setting maximums or minimums
  124. Count letters
  125. Automatically Add in 56days to the date
  126. golf handicap
  127. how do i colourfill validated cells ?
  128. Copying Formats between workbooks and worksheets
  129. text boxes and superscripts
  130. help me. How to delete a menu
  131. Reinstalling MSO-Pro-XP
  132. How do I conditionally build worksheet from existing worksheet?
  133. counting number of particular items in a list
  134. Is this possible with my chart?
  135. Oracle odbc
  136. Upgrading Excel with technical features for engineers, please
  137. Pricing scale selection
  138. Removing all duplicate records except one copy
  139. Date Formats
  140. How to select and deselect rows in Excel
  141. How to select and deselect rows in Excel
  142. Can't open any files due to my non-existant virus scanner
  143. whichever is greater
  144. adding to an exisitng number
  145. Working with a range
  146. Excel if then formulas auto copying
  147. Get External Data
  148. Include comments on another spreadsheet
  149. how do I format cells to change date and time to just date
  150. Why am I getting a two-headed horizontal arrow cursor in Help?
  151. hiding gridlines in selected cell areas
  152. Sort without moving buttons
  153. removing the word (blank) from pivot table cells
  154. How do I add a zero in front of a number in general format?
  155. Where do I find the help topic
  156. Why is my Excel spreadsheet's sorting not being remembered?
  157. excel command that counts conditions met in 2 columns?
  158. Size of a Workbook
  159. Hiding rows based on a value
  160. Currency Formatting
  161. Need help with a formula for calculating based on a rage of dates
  162. "New Web Query" function
  163. Excel automatically copied data from one cell to another...
  164. query database
  165. Activating a Hyperlink
  166. "New Web Query" function
  167. Summary of Data from a Range
  168. Can I assume the program has crashed?
  169. WHY DOES 1E4 TURN INTO 1.00 E + 04? THANKS
  170. Minus Display
  171. Data Labels still looking for help
  172. Stop scientific format
  173. Enable 'BOLD' functionality in protected Excel spreadsheet
  174. Converting whole number to TIME
  175. Excel gridlines not behaving
  176. change dots to dashes in an account format (xx.xxxx.xxxx) to xx-xx
  177. How do I import external data populate rows instead of columns.
  178. Shortcut for copying formulas referencing different worksheets
  179. HOW DO I PRINT MULTIPLE COPIES IN EXCEL
  180. CubeCellValue add-in
  181. How to calculate date and time
  182. IF Formula
  183. Data Label Format
  184. Can I expand the column count in excel 2002. Or limited to 256?
  185. Macros for copying and pasting
  186. Format problem
  187. Copying Excel schedules to different Outlook Calendars
  188. Drawing info from another source document
  189. Transfering Dos to Excel
  190. Validation List
  191. RE: hiding columns, error message says cannot shift objects off sheet
  192. Template Wizard w/Data Tracking in Excel 2003 Pro?
  193. Count of unique entries
  194. formula is displayed as literal text instead of formula result
  195. different length columns
  196. Getting an error message "Cannot shift objects off of sheet"
  197. How do I strip out some parts of a column of text data?
  198. Formula question
  199. Pivot Table - identifying datasource
  200. Fast way to search many cells by column for text strings
  201. Check Box that Locks all cells on it's column
  202. Check boxes - when one box is checked, I want a 2nd box to auto ch
  203. calculating results in formulas
  204. Auto Populating cells from a master spreadsheet
  205. Is there a way to Sort data by color in Excel?
  206. Why isn't this formula working?
  207. Openning Excel by double clicking on the file name in Explorer
  208. Macro to remove contents of cell and move all other contents up one row
  209. criteria 1(a,b,c), criteria 2 (T,F) - Results (3 answers) achievab
  210. How can I create a new line in a cell in Excel by hitting enter?
  211. date and hours issue
  212. Link excel and word in mail merge without losing your data source?
  213. array function
  214. Determining a Date
  215. *URGENT* - Complex formula needed
  216. Adding buttons in a sheet to sort data
  217. Lookup
  218. Formula which adds together worksheets
  219. Excel Read Only
  220. Matching cells
  221. dragging
  222. Excel Hyperlink to specific Access object
  223. Capacity
  224. Compare and consolidating duplicated rows
  225. when i open a file a new excel window opens. how do stop this
  226. Change FORMAT
  227. compare numbers and mark duplicates
  228. How do I automatically show passed dates in red in Excel, please
  229. PivotTable question
  230. How to make a flexible cell reference?
  231. Can anyone help? Please?
  232. How can I make an excel cell flash a color?
  233. Is there away to save a spread sheet at the same time each day
  234. How do i sort items using two rows per item in Excel?
  235. Code for workbook protection
  236. If Function
  237. data duplication check ?
  238. Double filtering
  239. Add-In causes excel 2003 to crash on startup
  240. Formula problem on network
  241. NEGATIVE IN BARCKETS AND UK DATES
  242. Ensuring deleted data cannot be recovered
  243. where can i buy excel?
  244. Conditional Summing
  245. #N/A
  246. Inserting zero
  247. Definitions
  248. Can't find macro in an Excel file to delete it
  249. Rectangle object in Worksheet not amenable to word indenting and Undo problems
  250. scheduled hours total
  251. Initial Formula Calculation
  252. can one cell contain more than one independent number
  253. Proper Do Loop Construction
  254. Negative Time Values
  255. print one standard letter to address to diff. costumer
  256. Where do I find a template for a high school template?
  257. Printing by row
  258. time sheet claculation
  259. Waiting for data to be returned from Microsoft Query
  260. requires that merged cells must be identically sized?
  261. How can I extend the text to the margin in excel
  262. Broken Links
  263. How can I improve the snail-pace peformance of Excel 2003?
  264. Filter list on additional worksheets
  265. copying formula into non-adjacent cells, EXCEL2003
  266. making changes to excel file on Windows 2003 small business server
  267. Converting a muliple page worksheet to a single page worksheet
  268. COLOR FILL
  269. Creating columns
  270. Filepath
  271. copying formula question
  272. Filepath
  273. HP Tablet PCs
  274. Lost contact info, how do I get it back?
  275. Can Excel email someone when a cell goes + or - a value?
  276. Spreadsheet Timecard
  277. why wont an excel doc open with new msn office
  278. show text after formulas
  279. Exporting excel to text file
  280. Named Ranges
  281. Check Box Printing
  282. Time Problem
  283. number "1" added to filename
  284. Excel 2003 Undo greys out after few minutes - Not saving
  285. OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem.
  286. generate report thru pracle to excell
  287. Excel Dates
  288. floating cells
  289. In Excel how can I assign values to a Yes or No question with IF
  290. How can I print a different header on each page of an Excel Sheet
  291. Need invisible/shaded/highlighted cell
  292. "Disk is full" error when opening Excel 2000.
  293. Cut and Paste issues
  294. need help w/ corresponding cells?
  295. Can I transfer files back & forth from excel 2000 to excel 2003?
  296. =VLOOKUP(E4,Serial_Prefix,2) Return value in next row.
  297. File in use error
  298. Templates
  299. vlookup search for more then one answer
  300. How can you change the color of the selected range?
  301. Correctly copy cells with a macro
  302. Can you tell Excel to send emails through Outlook?
  303. How do I remove ALL hyperlinks from a large worksheet?
  304. Trying to Open Tools in Word closes program
  305. Does excel have a log of when documents were viewed?
  306. Copy to Location
  307. Running a macro at a specified time
  308. Show Rows Button
  309. Linear Optimization
  310. Solver Addin
  311. How do I stop spanner from running in Excel.
  312. How do you calculate average time?
  313. Excel Font Problem
  314. automatically change cell colours
  315. Adding a Drop down menu to a column
  316. Macro - message box if find nothing
  317. How do I unprotect a protected worksheet that has passwrod protect
  318. Strange Excel problem when opening an Excelbook
  319. Using angled column headings and borders
  320. On the keyboard, how do I toggle between tabs on a spreadsheet?
  321. How can I autofill a series to reference non adjacent cells?
  322. Auto Filter out text or blank rows
  323. date fields
  324. Spell Check
  325. Change a number to round up without a function
  326. Give multiple charts on a worksheet/workbook same header or footer
  327. Print area/range
  328. IF funtion
  329. Randbetween
  330. FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.
  331. Any way to keep an image if publish Excel interactively to web?
  332. colorsetting of the Excel filter knob
  333. Moving sheet
  334. Paste and automatically move cells
  335. Splitting Cells
  336. How do I copy a filtered subset of data to another worksheet?
  337. Variable control tip text
  338. Convert Hrs:Min to Decimal Hrs
  339. Creating a line chart with two X-axes!!
  340. Copying Formatting and Value
  341. Extracting time
  342. Copying to an autofiltered list
  343. sorting error
  344. Excel weirdness!!!!
  345. macro to copy into different worksheets
  346. Etiquette for hyperlinks
  347. sumproduct
  348. Calculating differences in dates
  349. Database-Query and AutoFill??????
  350. F-key allocation
  351. How to show data greater than 10 in pivot table
  352. Make Excel opnening CSV files work properly again.
  353. count occurances of years between two year brackets eg >24 & <50
  354. Extracting numbers from a cell
  355. Offset Situation
  356. Pivot Table - Multiple Worksheets
  357. Automation issue
  358. Excel should allow macro on a shared workbook.
  359. watermark in excel.
  360. about converting numbers to text.
  361. How to enable the sort function for a protected sheet
  362. Identifying links
  363. insert row problem
  364. How do I copy formatting in a cell reference
  365. Formula Help
  366. Can't launch downloadable Excel CSV files from internet explorer
  367. Tab Order
  368. Time problem, Auto calculation???
  369. Re: Control Box Problems
  370. How can I shortlist cities based on the country selected in Excel
  371. column heading
  372. How do I open excel book on another computer using same excel pro
  373. Reading dbf files
  374. If Then Function - highlight cell
  375. Link or Copy Excel Data to Calendar (for scheduling) for Visual Aid
  376. is there a way to search with vlookup to match more than 1 column
  377. AutoComplete/AutoFill
  378. Format change after printing in excel
  379. Choosing the square character as a delimiter
  380. Missing "Export to Microsoft Excel" option in Internet Explorer
  381. Translating function names
  382. Consolidating multiple sheets
  383. Repeat a command in a Macro
  384. Workbook page is not normal size
  385. non nested-if way to change (0) to 0?
  386. Calculated fields in the Sub Grand Totals
  387. Setting up a form to input into selected worksheet
  388. pivot table row subtotals
  389. Formulas containing variable input
  390. Statistical add-ins
  391. Cells to always reference the C drive
  392. Highlight Sort Column
  393. Copying multiple Worksheets
  394. adding titles to data
  395. Clean Up Code - consolidate steps
  396. calculating with dates
  397. Get highlighted numbers to SUM instead of NUM @bottom of screen?
  398. Active X controls
  399. Division by zero in automated subtotals
  400. Using 'GoTo' in a Macro
  401. Conditional format when #N/A
  402. How to Paste without changing row height
  403. How do I sort protected cells?
  404. How to create a Pivot table from text file with more than 65000 rows?
  405. Vetical Filling blanks in a list
  406. Delating pictures without "del"
  407. Excel Macro
  408. Nesting Combo Boxes /Returning an Array
  409. Export/link a course schedule from excel into calendar format
  410. Another Date Question
  411. Do any of the Grade book templates using Excel average grades?
  412. EXCEL CELL problem
  413. Query disappears from worksheet
  414. How to allow multiple users to update workbook (on network)?
  415. How to center a title across a range of cells in Excel ?
  416. Formula for the word "between"
  417. How do I set a comments location
  418. Dropdown list from another spreadsheet doesn't work if close sourc
  419. Conditional Formating
  420. I need to merge text from an Excel doc. into a powerpoint slide?
  421. How to show dropdown list from another workbook without running it
  422. csv drops decimal places
  423. Automatic Quote Numbering
  424. Copying as Picture Link - using Macro
  425. macro quandry.....??
  426. Trying to shorten (or use new) formula
  427. Tyring to shorten a formula ..!
  428. Excel document protection
  429. how do I remove Carriage Returns from a column in a spreadsheet?
  430. Need quick help formatting cell
  431. When I move scroll bar in excell the contents do not move with it
  432. mailing one sheet from workbook
  433. how do i count time numbers whit a negativ sign ( ex -19 hours, 25
  434. Mouse right click problem
  435. Mouse right click problem
  436. Can I print a list of all of the worksheets within a workbook?
  437. beregning af tider med negativt fortegn
  438. Delete row depending on criteria
  439. Opening two separate instances of Excel
  440. How can I convert a formula to a value in excel?
  441. Want to auto hide rows in excel when no data in a certain column.
  442. Increment dates
  443. retaining fonts when placing excel worksheet into pagemaker?
  444. Find a net in a column
  445. copy formats column width & row heights between Excel WORKSHEETS?
  446. Formatting number cells
  447. Removing link to another workbook
  448. Open file
  449. Slight Problem
  450. Sheet Protecting password
  451. Is there a keystoke to navigate between worksheets in a workbook?
  452. Help!
  453. Page display is abnormal
  454. If and Or statement
  455. Hiding Non-Duplicated Entries
  456. file save as
  457. Using data forms
  458. Password to open file
  459. last digit in string gets changed to 0 (16 characters long)
  460. Spinner Button Reset
  461. Shift/Control Key locked
  462. break links problem
  463. Lost Toolbar / Right click disabled
  464. How do I convert a column from USD to GBP
  465. help with sumif to calculate column
  466. 2005 Excel User Conference
  467. font size in a drop down list
  468. Help wit text in formula
  469. paper size different in different office
  470. Formulas Translator Tool
  471. background color
  472. PDF hyperlink issues
  473. Startup macro
  474. How to Replace Numbers with Phrases
  475. How to Replace Numbers with Phrases
  476. Short-cut for Paste Values
  477. Can you calculate no. CHARACTERS
  478. Recalculating Formula - Getting the wrong answers
  479. can I use the 'fill color' as part of a formula
  480. Sum filtered values only
  481. Data Validation does not work when selecting another cell.
  482. TEMPLATES
  483. Format date in excel 2000 like '31st January 2005'
  484. Formatting Cells
  485. Format date in excel 2000 like '31st January 2005'
  486. Returning the formula in a cell
  487. Format date in excel 2000 like '31st January 2005'
  488. Password Protecting
  489. How to compare two tables in Access 2000?
  490. Format date in excel 2000 like '31st January 2005'
  491. Format date in excel 2000 like '31st January 2005'
  492. Format date in excel 2000 like '31st January 2005'
  493. How do I automatically update a chart range in Excel
  494. How to increase the maximum rows in the worksheet?
  495. SUMIF using two columns in both Range and Criteria
  496. help:missing data in excel
  497. How do I use <= in a lookup array?
  498. How to calculate the day before last two working day of each month
  499. Names and Subtotal in office 2003
  500. Removing shared workbook protection
  501. Prevent Excel closing all workbook instances when clicking on "X"
  502. Background Printing
  503. How do I create a command from a list box
  504. Issues with sorting
  505. Opening a file and enabling macros automatically
  506. Pivot Table
  507. matching contents
  508. Custom cell format problems
  509. Matching contents
  510. How do I use an Intellimouse to scroll listbox enteries in ExceL?
  511. burning hyperlinks on CD's
  512. Show Filename Only in ComboBox Pulldown
  513. Problems using Excel 2000 to open/save file saved in Excel 2003
  514. how to create multiple hyperlinks within a dropdown list
  515. How do I maintain my date format, when I copy a sheet, in excel?
  516. How do I Select Multiple entries from Valid list for a Cell
  517. Formating Latitude and Longitude co-ordinates
  518. I need to add mew rows for different spots.
  519. how to create this formula please
  520. reversed columns
  521. LARGE function does not segregate between identical max values
  522. Mail merge works with Forms but not with Labels
  523. Jump to the item in a list as the first letter is pressed
  524. Merging data to one cell from many
  525. Template for Excel to keep running record?
  526. Help! Formulas
  527. "No more new fonts may be applied in workbook" - but not adding ch
  528. Excel error message
  529. Number format for Combobox
  530. How do I find an unknown value on a line made from known data?
  531. How to convert numbers to corresponding letters? Ex: 123 to abc
  532. Combine to Sheets...
  533. Creating Relative Links in Excel...
  534. Percentage function formula
  535. Data Validation with Formula
  536. Filtering
  537. LAPTOP KEYPAD
  538. Formulas
  539. rotate rows and columns in a spreadsheet
  540. How do you format a sheet to fill the entire page to print?
  541. File Association
  542. Export from Access
  543. Text in cell
  544. Averaging/Rounding Equation problem
  545. Conditional formatting font
  546. Page Numbers in Excel
  547. Images get distorted when printing
  548. formating military time
  549. How can I resize columns and rows to inches?
  550. dynamically enter name of last modified by in spreadsheet on save
  551. Excel97 faster than Excel2000!!
  552. conditional formatting
  553. Conditional formatting
  554. change column name from letters to numbers?
  555. End Of Excel
  556. suddenly when i use formula it just show - or 0
  557. How do I transfer macros in excel between two computers?
  558. Convert xls files
  559. Need help with macros
  560. Tab key moves
  561. Date/ Phone log
  562. How to show 2 MAX values in a list
  563. vlookup??
  564. Automatically clear values from a range of selected cells
  565. Error Message on some files
  566. MSCAL.Calendar
  567. Fatal Error!!
  568. password protect individual worksheets
  569. Problem printing more than one copy in excel
  570. Disperse one worksheet into several...
  571. Find text in cell, copy row to new sheet
  572. ADDRESS function - dynamic input cell
  573. How to create a line chart with two X-axes in Excel
  574. Date sensitive cells
  575. Data transfer
  576. Averaging
  577. Excel - shellexec error: 2
  578. how to copy old price data onto new stock list if match exists?
  579. Calculating working hours
  580. where can I find a excel based questionnaire template?
  581. Change the input in a sheet by OptBox
  582. Countif(table;(">"&A1)&("<"&B1))
  583. Excel2000/2002 migration problem
  584. Compare dates (one cell not in date format)
  585. IF NOT
  586. CUMULATIVE ADDING IN A COLUMN?
  587. Completely Stumped
  588. Password protection of Excel Sheet linked to Bloomberg Data
  589. excel timesheet and drop down boxes
  590. Excel sheet not loading
  591. Template Wizard with Data Tracking
  592. How do I get a field in excel to auto complete with a check mark
  593. IF NOT or IS NOT function
  594. data validation
  595. COLUMNS IN EXCEL
  596. IF NOT or IS NOT function
  597. have put a passowrd onto an excel file and now cannot remember it
  598. routing slip
  599. Reference cell contents
  600. sort numbers based on initial digit.
  601. Set a password in Excel that changes after after a fixed time
  602. External links
  603. Downloading from Bloomberg!
  604. make excel files executable
  605. Question about formatting addresses
  606. Time and Invoicing
  607. Excel Documents in Windows Taskbar
  608. Excel Charts and Restricted Permissions
  609. Vlookup Multiple Returns #REF
  610. Jump to data in a list as first letter is pressed
  611. Is there some way to pivot nested tables or subtable in excel
  612. automatically open .txt file with all fields as text?
  613. Conditional Formatting options
  614. Linking Excel columns in two different excel programs
  615. Time stamp in Excel Sheet
  616. Exporting excel to text file
  617. Pivot Table with two row header?
  618. How do I do a search and replace in a textbox in Excel?
  619. How do I format the tabs of a worksheet in Excel?
  620. DateValue & Vlookup?
  621. Conditional Format for Numbers
  622. Windows Explorer maximizes over XL 2000, if opened w/ explorer
  623. adding worksheets together
  624. turn a column into a row or visa versa
  625. Sub Total Cost by MFG
  626. Message Box "Value"
  627. Merge cell values
  628. Dash in format
  629. hyperlinks
  630. transpose 3d cells to a column in single workbook
  631. Convert Social Security text to number?
  632. Different display for same file
  633. Very easy question about filter!!!
  634. Protecting A Workbook from being saved/written over
  635. Get Msg "Cannot shift objects off sheet" when hidng columns" Why?
  636. Formulas stop calculating
  637. Cannot change formats of cells???
  638. Social Security Number
  639. Can anyone give me the equation to convert watts to Decibels?
  640. Re: Next Cell
  641. Bob Phillips followup question on text macro
  642. Excel not detecting that a file is currently being edited
  643. use replace command to change the contents of formulas
  644. Combo boxes and Protection
  645. tab order
  646. "Arranged" files scroll together
  647. How do I set up a cumulative column, without entering it manually
  648. Comment position after filter
  649. Counting blank and filled cells within a range.
  650. Hide columns
  651. what is the max no. of nested Ifs can an If Statements have in EXC
  652. sumif help...
  653. multi function cells
  654. Suppress Zeros in a Pivot Table
  655. Protection issues
  656. dynamic range
  657. A small problem for you but big for me!
  658. how do i read an 2000 office Premium Excel file? I don't have the.
  659. Use of Now() in Excel
  660. calculations across sheet and other workbooks
  661. How do I find replace special characters?
  662. 2005 Excel User Conference
  663. How do I input currency symbols in Excel?
  664. How do I insert currency symbols in Excel?
  665. Conversion of Dec numbers to Bin, Oct and Hex and visa versa
  666. Deleteing empty rows
  667. Re: Excel - Saving
  668. Spell checker
  669. New mbr needs immediate help with formula.
  670. Numerical characters in a cell
  671. Making pick list conditional on selection from previous pick list
  672. Extract sheet name/number to cell
  673. VBA Function to explode string
  674. Active sheet
  675. the attribute "nullable" is not supported in convert excel to xml
  676. Clicking on restore window button changing the freeze pane in exce
  677. Executing of excel Macros.
  678. Conditional formatting of date
  679. Re: Calling a common XLA Library file, stored on a network drive :)
  680. Zero with a slash
  681. DFS RENAMES MS EXCEL FILES TO ALFANUMERIC!!!
  682. Newbie - needing advice on formatting webform data
  683. How do I convert excel file into ASCII text file with alignment?
  684. i have a document i need but i don't have excel
  685. Begineer with (seemingly) hard problem
  686. Macro Button
  687. Excel 2003 crashes loading excel files created Excel 2000
  688. Select Text Files from Combobox
  689. Lookup question
  690. stop highlighting cells when launched
  691. reverse/manipulate order of numbers?
  692. Update Links to current Directory??
  693. LinEst with operator
  694. Scrolling chart
  695. Completely Locked Out
  696. Copy cell values across separate sheets
  697. Conditional Formatting
  698. How do I omit/prevent "" in tab delimited text
  699. how do i create a quiz using excel?
  700. Can Excel reveal factors for success?
  701. Excel to Html
  702. Obtaining information from a database for a worksheet
  703. I want to email only 1 page of my excel sheet how do I do that
  704. Sort a numeric field
  705. Strange behavior w/ Text, Button, & Check Boxes
  706. clean characters
  707. How do I resolve too many different formats in a spreadsheet?
  708. Link between similar sheet
  709. ActiveWorkbook.Protect password:=range("rangename") does not work
  710. Macro Recorder-Relative relation
  711. Excel File fonts
  712. Subtracting lunch breaks from different shift times
  713. Book
  714. Autocomplete numbers help pls!
  715. Workbook Protectionand stiil use Comment function
  716. how do I save a column to a file (in ascii format)
  717. merging cells and maintaining the fonts size of each cell
  718. Opening Excel spreadsheet in MAC
  719. how do i import a file list in to excel
  720. Hyperlinks to network files
  721. Moving rows
  722. Sorry, my clock is off
  723. move page up and down in Excel?
  724. VBA IN EXCEL
  725. Words wrapped differently on screen and on print preview
  726. AutoFilter toggling in VBA (How to use correctly)
  727. How do I produce a number in parentheses?
  728. open data excel w98 on xp program help
  729. customising the Excel invoice
  730. Colour Banding in pivot tables
  731. =(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response
  732. How do I create a form that can be filled in on the computer
  733. How do i copy a spreadsheet with the formulas?
  734. Copy from 1 sheet to another
  735. Scroll the screen view with the scroll bar
  736. Excel 2003 Slow Function Argument Window
  737. HOW DO I TOGGLE FROM FIND AND REPLACE TO A CELL EASILY?
  738. Custom drop down menus
  739. horizontal page breaks
  740. Copy and paste
  741. Selecting a filepath based on cell contents
  742. Column additions query
  743. How do I link a picture to a text cell
  744. Conditional Formatting
  745. where to find engineering drawing symbols?
  746. If I change page margins headers don't line up???
  747. Copy from merge cell
  748. How do I copy a formula/paste w/o losing the cell content?
  749. concantenatring 2 cells with with a line break
  750. I want to set up a form in excel where I can place a jpeg or pic.
  751. Excel Simple Calculations help
  752. prevent Excel from pasting icon when it starts
  753. Use checkboxes with linked external data?
  754. extract comments
  755. print button
  756. How do you control scroll rate when click and drag to select cell
  757. Search Range for Criteria in given cell and produce results
  758. How to change the return of a textbox from TRUE/FALSE to YES/NO?
  759. An array formula to sum row max
  760. Excel: how to merge data from 2 workbooks with 1 col. in common?
  761. export access to excel. change access & update excel at same time
  762. naming .xls file based on a cell in excel
  763. How can I work with more than 15 numbers
  764. How do I unlock a cell in a page set up for pricing? changefactor
  765. Using VLOOKUP to draw data from two columns
  766. How to post sample data to this NG
  767. Elimate year (either YY or YYYY) in data
  768. How to remove duplicate entries in column?
  769. How do I copy data in single cell format to a merged cell format
  770. Conditional SUBTOTAL
  771. how do i get excel to show mm/yy
  772. Printing
  773. Working with Pivot Tables
  774. Locking down worksheets
  775. sorting question
  776. Opening Attachments
  777. how do i get excel to show mm/dd in Funcation bar
  778. Moving Files in Excel
  779. Copying Worksheet
  780. Concatenate Countif formula for VBA fill-in
  781. How do I stop automatic insertion of rows in Excel?
  782. Excel showing old or new version of file for 2 - 3 seconds
  783. hyperlink greyed out on shortcut menu in Excel
  784. Why won't pasted values from a formula appear in a pivot table
  785. Getting Excel to treat merged cells as one cell when printing
  786. templates on network drive
  787. Cell data overruns into adjacent cell(cells).
  788. Formula to always point to C drive (peer to peer network)
  789. How do you make the little autofill box in Excel go away?
  790. How do I save a filtered subset of a worksheet?
  791. HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
  792. exporting excel to csv large fields save as "####"
  793. Formatting
  794. Need to convert Office 97 Excel doc to Office 2003!
  795. External lookups won't load
  796. Page Numbers in worksheet background
  797. How can I move Project tasks into an Excel outline?
  798. Debra Dalglish
  799. Zero Suppression
  800. Clipboard
  801. Conditional Formating in Excel
  802. Fit large amount of text in 1 cell
  803. IF formula question
  804. How do I type 24 square metres using arithmetical notation
  805. Graph formats after updates
  806. How do I automatically generate dates?
  807. RE: How do I type 24 square metres using arithmetical notation
  808. PivotTable and column widths
  809. Excel macros should be able to record pauses, thread.sleep(23489)
  810. offset a looked up cell
  811. Repeat statements "x" number of times...
  812. virus scanner has blocked this file
  813. HOW DO I ENTER SAME DATA IN EACH CALENDAR DAY AT SAME TIME?
  814. Printing one column
  815. Reports from rows
  816. Why is font so small in the autofilter dropdown
  817. Hyperlinking to Many Pictures
  818. macro/new sheets
  819. Macro to link Sheets to main workbook
  820. Convert data from rows to columns
  821. Two Excel tables in MS Query
  822. Background colors are printed but not shown in normal vieuw
  823. Export html page to Excel - support files folder
  824. Combo Box Moves
  825. how, in excel, can i generate a number, eg consecutive order nos
  826. USA to UK Dates
  827. Merge cell & Copy Data from different cell
  828. Data Validation
  829. Protect multiple worksheets
  830. how do i get answer is 1 from CELL("color",sth) function?
  831. cannot open an xl97 file
  832. How to apply survey weightings
  833. How to change the order in which excel addins gets loaded?
  834. how do i save excel workbook every 30 seconds.
  835. return decimals only
  836. would like to know the formula amount and display word
  837. a data entry form with combo box
  838. how do I count cells with only red font?
  839. LOCATING A CHART SAVED IN A WORKBOOK
  840. How do i open a file in a new version of Excel
  841. Counting Rows/Columns for Copying Formulas
  842. Green Triangle in Cell
  843. How do I create an Outlook distribution list from an Excel column
  844. Remove middle initial from "first name middle initial"
  845. Automatically put negative sign in cells with positive numeric dat
  846. windows explorer will not open an excel spreadsheet.
  847. Help
  848. Help replacing text with Yes or No
  849. scrolling in VBA editor
  850. Sort by 2nd word in a cell?
  851. Answering InpBox prompt
  852. Can I freeze multiple rows?
  853. Adding value to drop down list
  854. Showing 3:54PM instead of 3:54:03PM
  855. How to display multiple pages on one large monitor
  856. Excel validation drop-down: how show codes with descriptive info?
  857. formula to return certain cell
  858. Linking cells in a worksheet to other worksheets in a workbook
  859. Formatting problem
  860. mileage reimbursement formula
  861. Why do pivot tables not read numbers that are copied and pasted
  862. if statement with text
  863. excel file .xls
  864. CVS file won't open in Excel 97, Help Please!
  865. Simple Simple Excel usage question
  866. Adding a line after a date
  867. Why is "send to mail recipient as attachment" greyed out in excel
  868. named range, data validation: list non-selected items, and new added items
  869. How to get a listbox to move when scrolling down spreadsheet
  870. data validation lists
  871. Phone number format from 000.000.0000 to (000)000-0000
  872. Why does excel grow to 34mb with 2pgs, no pictures and autoformat?
  873. Pivot Table Sort & Top List
  874. opposite of IsNumeric
  875. Has anyone built an Excel spreadsheet to calculate churn?
  876. Populating another tab.
  877. Can I set up a formula to lookup a value for a condition
  878. Refresh Imported Data - Does the Excel file have to be open?
  879. Referencing
  880. How do I only calculate cells which have a filled color format?
  881. reference to a bimonthly date
  882. Social Security Numbers & Leading Zeros
  883. Visio Text (Number) Automation
  884. VBA to set AutoFilter to List all rows with same values in column?
  885. How do I change data that has been entered in a column to a row?
  886. GRAPHS PLEASE HEL
  887. Date dependant values.
  888. How do I find duplicate entries in Excel
  889. Read-only problem
  890. Regression with more than 16 variables
  891. Put comment directly in formula
  892. Continuous page numbers in workbook of multiple worksheets
  893. Is it possible to make a Button on a tool bar to launch an Add-in
  894. Getting message can't save all data in excel xls file
  895. how do I forecast a 15% increase over 7 months?
  896. Asking Excel Solver to use binaries, but selects other values
  897. In Excel, sorting columns automatically by clicking column title
  898. shortcut to scroll to last cell in row or column
  899. Format numbers / Concatenate
  900. Divisão da planilha.
  901. Stacked Bar Chart Over 100%
  902. Opening Files/Folders
  903. Formulas
  904. Text Alignment in Excel Cells
  905. need to increment value
  906. Open Excel files/folders
  907. Changing default font for copy / paste
  908. Copying font and pattern dynamically
  909. How do I use flash drive in Excel.(selected drive is not in use)
  910. graph with one column and two lines
  911. Last Column(=spaces) is Dropped When Importing from .Txt file
  912. Comment Box
  913. Workbook Headers & Footers
  914. Printing/Displaying File Properties
  915. Excel Autofilling to 65543-need macro correction
  916. How do I un-embed images in Excel and save them to another folder.
  917. Move page breaks
  918. A pivot table report cannot overlap another pivot table report.
  919. Synchronizer: in my opinion, best diff tool for excel.
  920. How do I stop macro alerts for a spreadsheet with no macros in it
  921. Printing issue
  922. Report help
  923. Sorting in Excel
  924. Pasting mutiple paragraph text into a single cell
  925. Possible to view spreadsheets without scroll bars?
  926. drop downs & data validation
  927. Creating a link between cells in two different spreadsheets
  928. Logical ELSE statements
  929. How do I print excel document duplex (double sided)?
  930. Date Format
  931. date Format
  932. Date Formatting
  933. Spoolsv.exe & csrss.exe services
  934. Is it possible to use 'grid' as a value in vb to process XL data?
  935. Reference cells from another worksheet problem
  936. When calling a different file, can I make the tab equal to a cell?
  937. How to link cells?
  938. Background changes conditionally
  939. Visual Basic
  940. Protecting single cells or a range
  941. Show minus figures with brackets
  942. java message with VBA
  943. FORECASTING SALES (please let this be a worksheet function)
  944. apply a formula to multiple cells
  945. Slow print preveiw Excel 2003 SP3
  946. Making list of items to truck monthly usage
  947. Pivottable
  948. How do I calculate the Root Mean Square (RMS) of line of equality
  949. Conditional Formatting
  950. I need a template to track expense + VAT when building a house
  951. totals
  952. How do I make a column in Excel into two columns for only A3-A8
  953. Drop List
  954. word wrap question
  955. Protecting Workbooks in Excel 2003
  956. go to - special - visible cells only - takes too many key strokes
  957. I deleted MS Outlook from my start menu, now EXCEL won't work?
  958. exceL NOOB needs help w/sales tracking
  959. converting fractions to decimal
  960. cannot open a file
  961. Excel Save As... text with special characters
  962. dropdownlist- I want user to choose a # but can I add definition
  963. How do you sort a date range by month?
  964. Excel - saving file
  965. Sorting from a list with data on different cells
  966. Automatic Date Update
  967. Count values bigger than cell
  968. adding scroll bar to comment boxes
  969. Wrap Text from one cell to another cell
  970. Import wizard limitation
  971. Cell always equals 'C: regardless of computer
  972. Shadow/duplicate excel file .xls:2
  973. How to copy subtotalled cells to a new worksheet (in a macro), wi.
  974. I need an excel plug in to save workbooks in adobe acrobat format
  975. calculating time/dates differences
  976. expert with formulas needed again
  977. Can you Find and Replace values with in a formula?
  978. XL2000: "Filename is Not Valid"
  979. Search for most recent date from list of dates
  980. How can I set a default font for a comment in Excel?
  981. Time as number
  982. Exporting excel to text file
  983. How do I change column label from number to letter?
  984. Formula needed
  985. Sorting alphanumeric
  986. Copying and Filling Cell With Functions
  987. VBA Question
  988. Adding Stock Quote to EXCEL
  989. How To....
  990. Workbook Protection
  991. How can set up Excel to be able to print checks?
  992. Drop down menu help
  993. Excel Sort
  994. find and replace
  995. clickable buttons
  996. Runtime error for macro that works in workbook created in
  997. "Links cannot be updated" error
  998. Page Breaks
  999. Excel formulas
  1000. What happened to Pivot Table "Show Pages"?