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. Macro Question
  2. Queries that will not select data
  3. SELECTING LAST ROW
  4. Are there any easter egss in 2003 or 2007?
  5. How do I compare interest rates on tax free vs taxable bonds?
  6. Image in cell.
  7. how can i open 2 different excel speadsheets at the same time
  8. Sort & Filter
  9. =PRODUCT
  10. EXCEL 2007 reading E as power of ten
  11. Previously used files, monthly clearout, how to stop
  12. Offset with hlookup as reference
  13. Budget Question
  14. Formulas do not generate result until formula edited
  15. Unique Entries
  16. Formula for Most Recent Date
  17. Clicking on cell
  18. Hide the line when cell B is empty
  19. Excel needs the option to unhide multiple sheets at the same time
  20. Protection on particular cells
  21. speak input box dialogue
  22. How to convert this date 07/12/2007 04:47:32 PM WET to the
  23. Identify Text on two cells
  24. paste option disabled after clicking copy
  25. LABELS
  26. Getting a differnece to multiply
  27. import excel data
  28. Finding the difference
  29. Excel comments
  30. golf scoring
  31. Selecting multiple cells, I can't see the cells highlighted
  32. locate to particular in a dropdown list
  33. How do you find the position of the first value (<> 0) in a list
  34. pop up box
  35. can i link a variable cost code with a variable sum
  36. Automatic tab titles
  37. Excel can automatically put in formulas...or not?!
  38. how to
  39. How can i auto hide empty rows in printing in excel?
  40. my keyboard is typing wrong characters
  41. Information Box
  42. Finding the average using conditions in a logic function - problem
  43. How to add numbers in adjacent cells
  44. Create a new workbook for all Unique values and new work sheets tothat new workboks
  45. in excel 2007 how can i see what I've selected?
  46. PivotTable Field Value List Update
  47. Excel 60 day trial
  48. Excel worksheet formatting
  49. Sorted Linked data doesn’t stay together
  50. 'formula' in pivot table
  51. Determine next level from a table
  52. LISTA RESUMO
  53. Can't view worksheet contents, but I can do Print Preview and see
  54. Userform Commands - Switching Question
  55. sum if and sum if
  56. Excel 2000 Hyperlinks and emails
  57. I need help with function
  58. Linking Changing Values Between Worksheets
  59. Consolidate 2 Columns into 1
  60. sumif
  61. Drop down list question
  62. rolling up data at various levels based on a numbering system
  63. "automation error" "unspecified error"
  64. Find first entry in a column
  65. How do I write a formula in Exel that will keep a running count?
  66. Re: Paste from Word Tables, ignoring Paragraph marks
  67. Moving Formulas to a different sheet
  68. Fill Drop Down with List
  69. How do I compare values in two arrays in Excel?
  70. After I sort a column can I add the date to separate worksheets?
  71. Counting Question
  72. Time
  73. Relocating row information
  74. Excel 2008 Default Cell Size
  75. Excel Advanced Filter
  76. how do i link multiple files (tif files) to one cell
  77. How can I keep "&" in the header?
  78. SEARCH WORKSHEET USING A NOT CRITERIA
  79. Converting text to numbers with a twist
  80. Combining & counting data
  81. Default Text Wrap Settings
  82. excel not working
  83. Help on this formula =$E$36-(G51>0)*$E$20
  84. VLOOKUP Issue???
  85. Can anyone help me with this formula?
  86. sumproduct
  87. Hiding Rows makes entire sheet disappear
  88. installing Analysis toolpak in Excel 2002 without the installation
  89. Unwanted Fill Color Changes
  90. READY BAR
  91. SUBTOTAL QUERY
  92. Rounding up or down to the nearest $.09
  93. Excel 2003: make a cell "float"
  94. How do you do a range selection dialog like those many in Excel?
  95. Help with 4 day work week schedule
  96. Macro help
  97. Shared Workbook Issue
  98. Office assistant
  99. One Last Query Question
  100. Brain Teaser
  101. Average of Pivot Subtotal
  102. Excel crashes when inserting a row or column
  103. Excel Database
  104. Ranges
  105. Printing multiple page wksht w/pictures
  106. If - additional criteria
  107. Excel Hel Button
  108. Archiving user selection from Drop Down (forms - combo box)
  109. Adding number of months
  110. Break Links using a macro problem
  111. Cool Macro
  112. How do I link an Excel worksheet to an Outlook email ?
  113. Re: Refering to a sheet in a cell
  114. Converting Lotus 123 Files
  115. Re: Refering to a sheet in a cell
  116. Lookup
  117. Macro Query
  118. Macro copy query One
  119. Re: Refering to a sheet in a cell
  120. Multi cell fill
  121. Name Formatting
  122. Need help using data from multiple worksheets to create a Summary
  123. Conditional summing when more than one condition must be met
  124. Update Bottom to start a Macro
  125. Can we find the stating date of the week in Excel or ms access?
  126. data validation when list is on a different worksheet? 2003
  127. convert txt file to excel
  128. How to use pivot table to count repeats of unique fields
  129. How to adjust chart auto'ly as new data is entered?
  130. Vlookup "#REF!" error when using last column of array
  131. lookup table multivalue
  132. How do I modify the decimal places viewed in complex numbers
  133. Combo Box
  134. inserting rows..!!
  135. why Isn't any of the experts helping me?
  136. Count quantity of repeated items in a column
  137. Macro to insert a hyperlink to external file
  138. How can i create a macro.
  139. Entries of ComboBox with Color
  140. How to compute date of next weekday?
  141. Macro Copy Workbook Query
  142. How do i alphabetize a list?
  143. Pasting into a cell with conditional formatting
  144. Insert picture from file (Need VBA help)
  145. Is there a auto-graph generator functionality in EXCEL/VBA? Hi all,I am not sure if this could be done, but in my mind, I want the folllowing
  146. Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to
  147. XL Runtime error '429' -- help please
  148. Sort by how many addresses per zip code
  149. excel print formatting issues
  150. How Do I ... select multiple shapes in Excel 2007 (similar to 2003
  151. Validate date entry in a text box.
  152. Entering large numbers into Excel
  153. Formatting column
  154. Excel Formatting
  155. Can't unhide left columns but can see them on print preview
  156. Combo Box Formatting
  157. 2007 Excel will not launch from file
  158. Excel Formula
  159. Subtotals
  160. Work hours with overtime
  161. Returning a value rather than TRUE or FALSE.
  162. Adding to a formula thru out a worksheet
  163. Autofill with different Columns
  164. Summary Sheet
  165. AVERAGING
  166. Formatting error message
  167. Loosing Formatting
  168. excel formula sumproduct and age ranges
  169. lost info
  170. Combining IF, OR, and the AND logical Functions
  171. Help with Counting.
  172. moving worksheets
  173. Copy of Header-Footer in Excel
  174. Insert Row Below
  175. Counting rows???
  176. Excel Formula Help
  177. IF function
  178. How to reference trendline equation
  179. CSV file doesn't save "xEy" style number as text formatted data
  180. Sumif
  181. How do I count unique email addresses across multiple worksheets?
  182. how do i show the calculated value in a cell rather than formula
  183. Convert linked files from 2003 to Excel 2007
  184. Opening a SS two copies of the SS open?
  185. conversions in excel 2003, and the microsoft calculator
  186. countif with multiple criteria
  187. Pivot table fields that are greater than 256
  188. Import External Data Problem
  189. sorting
  190. Summary data
  191. Excel - File format is not Valid
  192. Named ranges are causing a #REF error
  193. Sheet protection
  194. Dead spot in worksheet
  195. Conditional Formatting & Vlookup
  196. Format the command for the Currency button
  197. Conditional Formatting
  198. locate cell with specific text and select that column
  199. dragging formula to make selection
  200. FIX in Statusbar
  201. Text box to encode information to worksheets.
  202. Delete Web Toolbar when Open A Hyperlink workbook
  203. Number formatting
  204. disappearing bitmaps in worksheet
  205. copy files to clipboard
  206. Assigning Dollar Values to 'Buckets'
  207. from num to text - end sub
  208. Columns Drop Down Options
  209. Reduce File Size
  210. How to Split the table and keep the header on each portion.
  211. $ sign in SQL clause in MS Query
  212. Text Display Problem.
  213. basic on excel 2003
  214. Percentage displaying wrong
  215. List to a table format
  216. Formula that returns a hi-lighted row
  217. Pivot Table totals
  218. zip/unzip excel files
  219. Conditional Formatting
  220. Sumifs with error value in the sum range
  221. Conditional Format - Doing without using .Select?
  222. MS Query and Time Portion of Timestamp
  223. #value! error
  224. fill series of multiple rows and columns
  225. Lookup the Odd One Out
  226. Change sheet names for charts on the fly
  227. path too deep
  228. Print Preview - Mouse Scrolling
  229. Number Formatting
  230. Lookup one value and count in two ranges
  231. Incorrect row number in my excel spread sheet
  232. I want to place a checkbox in the middle of a cell, yet I want thecheckboxArea take up the entire cell.
  233. Fill format default
  234. lookup
  235. Using drop down lists on protected worksheet
  236. Time Conversion issue
  237. SumIf
  238. Protecting/managing links from my worksheet
  239. Locking column headers
  240. Printing the Compare Spreadsheet for Excel Add-in
  241. Custom cell format for percentage
  242. tab key use in a created template
  243. Number Alignment Question
  244. Date Between IF And Statement
  245. error "Excel has found unreadable Content"
  246. Cascading Drop-Down Lists
  247. Excel 2007 - Include Field Names
  248. fill in the blank form
  249. Can I use Mail Merge to fill in Excel worksheets
  250. Delete rows
  251. Sumproduct how can i use
  252. How to update column info based on column info from another worksh
  253. Locking only one cell in Excel 2007
  254. Copy row heights
  255. exporting from SAP to Excel
  256. Why do my row heights change when I close the Workbook (2007)?
  257. Highlighting Text within Cell
  258. Named Ranges & Calculation Times Query
  259. Page Setup when saving a worksheet as a web page
  260. pivot table
  261. Tab is skipping 10 cells, how do I stop this?
  262. Save as Command Line
  263. formatting problem
  264. Pivot table consolidation
  265. How to save formulas when creating templates
  266. Multiple subtotal rows
  267. Data return from SQL Stored procedure...
  268. How do i get the total count
  269. Excel Hyperlink-show link
  270. Cell formatting question
  271. single cell formula
  272. Countif...and
  273. Button with Macro to Email sheet to multiple addressees
  274. PDF Files
  275. How to turn off date autocorrection?
  276. Need help with complex pivot...
  277. How do you send an excel file as a link in an email in excel 2007
  278. How do you change the default number format in Excel 2007?
  279. How to get the Total count
  280. consolidating data
  281. emailing spreadsheet
  282. Search Results
  283. Autofill to Last Row but Miss Some Rows?
  284. Look up one number based on mulitple criteria!!!!
  285. 2008 East Coast US Excel User Conference
  286. Protecting Formulas
  287. Help with manipulating data in excel?
  288. Some mouse function disabled on creating dynamic link
  289. HELP Lastrow Range
  290. Wrong number format after exporting from sharepoint list
  291. pivot tables
  292. Conditional Formatting in Excel 2007
  293. Graphical Indicators Formula
  294. consolidating data in an excel worksheet
  295. How do I change print quality for whole workbook on incomin Excel
  296. Loan Schedule - Specific Requirements
  297. Any way to increase visual size of formula bar?
  298. Delimated Text
  299. Excel Header and Footer
  300. Excel Header and Footer
  301. Pagewise total
  302. Create Mail Merge to Print Directly On Envelopes
  303. RANKING WHEN THERE ARE 2 SAME NUMBERS
  304. privot table help
  305. difference office 2003 and 2007
  306. Formula from a single cell to a merged cell
  307. Excel 2003 XML not updating LastSaved field
  308. save a excel spreed sheet to a word document?
  309. Format a date within a formula
  310. selecting the two lowest numbers
  311. filter within a filter
  312. excel sheet selects more than one cell
  313. Hyperlinking Cells
  314. workbook password lost, how to reset or remove
  315. sorting data
  316. countif question using two negative number criterias
  317. Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene
  318. auto date changing on worksheets
  319. Set up an If Macro
  320. Paste Special not working
  321. IF function (copy cell) in a macro
  322. saving printing settings in excel 2007
  323. Automatically generate letter
  324. Named Ranges Extremely Slw To Calculate
  325. command button to unhide row
  326. How to find the numbers that adds up to a fixed sum from a pool of
  327. Losing date values upon conversion from EXCEL to CSV
  328. identifying cells brought in from another worksheet
  329. How to disable "There is a large amount of data on the clipboard..."
  330. Eliminate leading numbers - Excel 2007
  331. Conditional Formatting and Blanks
  332. Formula using formatted dates
  333. Autoshapes disappear after saving file
  334. Formula required to get the correct count.
  335. Formula required to get the correct count.
  336. Rows expand to fit text typed in?
  337. How To Retrieve Data From Last Cell In Column?
  338. calculate percentage of cells that have any value
  339. Creating form with "tick boxes"
  340. Conditionality - row to repeat at top
  341. hide drop down list
  342. Show email address
  343. linking sheets that have drop downs
  344. Tracking Project Progress using Conditional Formatting
  345. Hiding formulas
  346. Combine SUMPRODUCT with INDIRECT function
  347. Date Calculation
  348. Select one entry per group
  349. Trying Again
  350. count function
  351. Formatted Cell
  352. totalling values based on conditions
  353. Select multiple worksheets in Excel 2007
  354. constant multiplier
  355. Enable macros
  356. How to change sheet names via formula
  357. Excel 2007 will not read pxl file extentions, can any one help?
  358. Cannot save formatting
  359. Formula too long---is there another way
  360. sum unique in pivot table
  361. how do I retrieve deleted data/material from Excel?
  362. save as .txt
  363. Link won't break
  364. Conditional formating
  365. The sum amount total does not equal the the individual cells.
  366. Linking Workbooks
  367. convert minutes to seconds
  368. decimate rows in Excel 2007
  369. How to add an empty row after each data set of .
  370. IF function (copy cell) in a macro
  371. Pivot Table formula
  372. Autopopulate row number in A2 IF data is entered in B2.
  373. Simple but need help!
  374. highlight row differences
  375. what post hoc analysis does the one way ANOVA test use in excel?
  376. Numbers change when saving as a csv fle
  377. Password on Macro Button
  378. Unable to Open File
  379. Drop down selection auto format
  380. Standard deviation
  381. XML Spreadsheets help
  382. Permanently Disable AutoRecover
  383. VBA Integration with Outlook: Mail Item objects from .msg files
  384. Why is my spreadsheet increasing to maximum size automatically?
  385. Pivot data field settings seemed to be locked?
  386. Exporting large fields from Lotus approach to Excel
  387. Creating an "F" Statement
  388. RE: Can't insert row
  389. Macro to Search and Copy
  390. Selecting examples from a table
  391. Pivot table updating details
  392. formula copy or alternative solutions
  393. Can't insert a row
  394. Copy automatically figure to another worksheet
  395. Excell pop up
  396. Ignoring lines in a pivot table
  397. Font Formatting in Excel 2007
  398. RE: Font Formatting in Excel 2007
  399. Automatic sum of a column when the other column has the same vaule
  400. email hyperlink won't change when cell content changes
  401. Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets
  402. Attempting to weight
  403. In VBA, how do you format selected code all at once?
  404. Compare Data from two Worksheets
  405. Change cell color based on value in cell
  406. What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu
  407. Matching cells
  408. List Box
  409. macro that will change the font of a cell if i change a value
  410. PLZ I NEED HELP!
  411. Custom paper size in Excell 2007
  412. DV + CF
  413. #value error?
  414. Offset Formula
  415. how to add attachment in a CDO mail
  416. opened excel file from email & clicked save after modify . Where i
  417. Wildcards in If statements
  418. ACREDITE FUNCIONA!!!!!
  419. Vlookup, copy only certain values
  420. Autofill - A Long Way...
  421. i have about 100 worksheets, how do i "lookup" multiple criteria
  422. Calculate (Auto Fill) cells with numbers and text.
  423. has anyone had problems opening csv files in office 2007 ?
  424. How do I insert music into a formula for when a result occurs
  425. how to repeat the upper row formula without entry formula?
  426. Formula Question
  427. Copy rows automatically
  428. Non synchronisation in split screens in Microsoft Excel
  429. LOOKUP worksheet function
  430. formula auditing/evaluate formula
  431. Oh, just one more thing
  432. How do I export an .xls file to Qif file format
  433. Copying rows with specific criteria
  434. Moving to Column A using a macro
  435. all formulae entered show zero
  436. Drag and fill from other sheets
  437. Help making a schedule in Excel...
  438. Vlookup to the left?
  439. Macro, AutoFilter...
  440. FREEZING PANES
  441. Indexing
  442. Pls answer the following question for me for my assignment.
  443. Group in Multiple Pivot table
  444. copy data from one sheet to another "entry has to be same shape"
  445. Dragging to fill dates
  446. How do convert a ClairWorks Spreadsheet files to Excel?
  447. Animated Clip Art
  448. Can I import external data from an authentified url? 4 STOCK VALUE
  449. Sort 4 Columns
  450. VLOOKUP help
  451. Text to Columns Letters and Numbers
  452. is it possible to print multiple pages with different numbers
  453. How Do I ?
  454. Paste Special
  455. vlookup help
  456. REVERSE VLOOKUP
  457. Page Down
  458. Now ()
  459. Grabbing Formula Information from Another Cell
  460. Printing issue in Excel 2007
  461. Headers change on different computers.
  462. Excel & Greyscale Text
  463. Listbox Values
  464. How to convert positive figures to negative ones?
  465. How do I unmerge cells?
  466. Second to last entry
  467. Add-Ins
  468. batch SUM of LEFT and RIGHT values
  469. Making a comment using a cell?
  470. How do I prevent a text to columns while opening a csv file in Excel
  471. Linking tab names to a cell in the sheet
  472. Formula Assistance
  473. Matching Rows
  474. Compare and update spreadsheets
  475. sending email attachment from excel
  476. Printing whole workbooks on one sheet of paper
  477. Can I use Excel 2007 to generate Fr Reports in Accpac 5.0A?
  478. Extract data in a string
  479. Conditionally format cell to turn red after lookup match
  480. Macro Button
  481. Why is my excel sheet suddenly printing very small?
  482. code does not copy
  483. Excel Iteration Program
  484. How to use values stored in a combo box control?
  485. SEARCH IN SUMPRODUCT
  486. Help with my VBA
  487. Create a Fuctioning Checkbox
  488. Dynamic Custom Number Format
  489. Excel Web Services 2007
  490. Shapes and Conditional Formats
  491. Excel Formula help
  492. Saving a workbook/file to a CD or DVD
  493. How can i make it so i can always see the first 2 rows?
  494. Excel 2002: Can I save entire web page ?
  495. Need help copying cells into rows with spaces between
  496. Make Forecasts - How extensive is it?
  497. Need to add 18 months to a date
  498. Using SQL>Request with Excel 2003
  499. Transfer Word labels into Excel Spreadsheet
  500. 2007 Excel Auto Fill - Lower right corner
  501. Border Problems
  502. if i email my sheet & pivot to someone with ex2000 it doesnt work
  503. Drop Down List
  504. Need your help Excel Worksheet/Form
  505. Merging three cells into one
  506. Replace NA with Null - Access 2003
  507. Excel Properties Tab on Doc Save
  508. Click and drag
  509. Table Formatting in Excel 2007
  510. Opening Excel 2003 in Outlook 2007
  511. TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA
  512. Excel Spreadsheet
  513. Conditional formatting won't update until cell is selected: Excel
  514. conditional format using "OR"?
  515. is there a formula for working out vat without repeating *17.5%
  516. Excel comments unable to be edited
  517. Excel converts string in CSV file as number
  518. Word to Excel
  519. save excel file in tiff format in 2007
  520. Wildcard Character in IF formulas
  521. $ use for what
  522. Copy worksheet and rename sheet
  523. Search for data and return multiple fields
  524. excel sheet.
  525. Sheet renaming and use as data
  526. Save file as a .dwg or .dxf file
  527. Remove characters
  528. auto caps lock
  529. Identifying quarter to which a date belongs?
  530. Display text at random
  531. Precedents
  532. Prevent filldown
  533. Conditional Format a cell in time increments
  534. Find within an embedded document object
  535. Array to Populate ListBox Problem
  536. Indirect and sumif functions with multiple workbooks
  537. Formula needed for adding every nth column on another sheet
  538. Saving email addresses from excel document
  539. Create error message if number entered is greater than previous ce
  540. Adding a range with three variables
  541. Can't sum a series of numbers
  542. Labels on data points in chart
  543. auto group row and/or rows
  544. filling a single cell before the sum of the previous rows.
  545. Rounding by .05
  546. Selecting a range of cells in a macro
  547. how i can refer to cell in long formula go to another file
  548. MATCH() or VLOOKUP() across mutliple 65K sheets possible?
  549. remove spaces in front of text
  550. Pivot Table Help Needed!!!!
  551. Tidal Times
  552. Convertion of Star Office documents to Microsoft Office
  553. Adding values generated by "IF" Statement
  554. how do you add cell values to drop down list for other cells
  555. Excel 2007 creating reports for diffrerent products one at a time
  556. Macro for Pivot in MS Excel 2003 vs 2007
  557. automatically enter today's date as a static entry in Excel
  558. Manually changing a picture (shape) name property
  559. DISABLE AUTO CONVERT FOR GOD'S SAKE!
  560. Extracting URL from Hyperlink
  561. NESTED OR FORMULAS
  562. Find if there is a matching number in another column
  563. Remove Header/Title from list
  564. Dynamic Data validation Lists
  565. Open Form when file opened
  566. Delete Hidden Named Range
  567. Determine if column contains duplicate value
  568. deleted files
  569. Protect files from deletion
  570. Importing images to scale
  571. Paste Special in Excel 2003
  572. Another Lookup Question
  573. Counts based on rolling time periods
  574. Change color of row and column worksheet headers
  575. Formula only for visible Cells
  576. date sort
  577. Find account, move them to different sheet MACRO
  578. Regular expression search/replace in Excel
  579. ?can I wrap displayed formulas?
  580. find a value from 1 column in another column on another sheet
  581. random merged cells
  582. How to Average elapsed time values?
  583. How to return formatting to cells rather than value for "IF" cmnd
  584. Hide/Unhide
  585. Excel graphics fill options
  586. AutoCalc
  587. How do I take ownership of a document I
  588. Copy (Formulas and Formatting ONLY) no values to other rows
  589. Tool Tips for UDFs?
  590. how do i stop my arrow keys from scrolling?
  591. Publishing a spreadsheet online
  592. How do I add a label to a macro on the quick access toolbar?
  593. Forgot Password
  594. Hide/Unhide boxes
  595. numbers overlapping in line graph
  596. Count matches within two columns
  597. Link a .DWG file?
  598. Look Up Help Needed Again
  599. Constants in Excel
  600. Combine Text Cells
  601. conditional formula with date
  602. Chart title that changes dynamically?
  603. protect formulas in locked cells from changing if data is moved
  604. how do i make a cell turn red if value is less than 0?
  605. code does not work anymore
  606. Is there a macro to...
  607. How to combine information from multiple rows into one
  608. Reassign built-in shortcut keys in excel 2007
  609. dates and conditional formatting
  610. Excel VBA Coding for Printing
  611. Graph Data not displaying
  612. print/preview problem before saving an edited excel worksheet
  613. Seperating numbers from text
  614. Correlations, Group By Type?
  615. how to activate the scrolling within the worksheet?
  616. Excel - printing specific areas
  617. How do i convert a date into 3 seperate columns?
  618. Changing column headers from alphabetical characters to numbers?
  619. fill combobox depending on selection from another combobox
  620. Lookup unsorted list
  621. Dynamic Array (multiple columns) Question
  622. Stop my references cancelling
  623. Countif and
  624. How can I open .wk4 file with Excel 2007?
  625. Headers and Footers in Excel 2007
  626. REMOVE CERTAIN LINES IN A PIVIOT TABLE
  627. Meeting 12 formatted conditions
  628. How do I Subtract 6 months off a date in excel
  629. How to calculate Average
  630. Using VB Copy Entire Row but formulas and formats only no values
  631. how can I Delete data in a spread sheet and keep formulas
  632. Excel Changes Text Cells to Number Cells When Importing XML
  633. why does the highlighter independently jump to another cell
  634. Is there a BETWEEN function?
  635. Pivot version issue-riv
  636. pivot reporting wrong info-riv
  637. Named Range Used in Formula Error
  638. View Questions and Answer to questions I created
  639. Dynamically populate a Date pulldown menu?
  640. Shading cells whenever they change Months
  641. sumproduct
  642. tying 2 Excel spreadsheets together
  643. Forecast Formula Help
  644. Disable autoformat of "true" and "false" text
  645. Look Up Help Needed
  646. Email excel file help
  647. Excel 07 - Combining Number minus the excess wording
  648. Double Conditional Formatting
  649. Set total amount for an equation.....
  650. Excel 07 - combining number
  651. Defined Names issue
  652. refering to specific cell in the formula
  653. Match, VLookup possible formula needed
  654. Edit links
  655. Why is my worksheet smaller with a blue border and movable?
  656. Pivot Table
  657. Graphs as eps or tiff
  658. How do I turn off auto color fill?
  659. Excell Countif w/ more than one criteria
  660. Formula to sum selective data.
  661. Help! How do I insert a manual page break on a change in cell contents
  662. Why the arbitrary spreadsheet size limitations?
  663. opening extensionless text files
  664. Sumif question
  665. Sl. Nos displayed in the right side
  666. Hide the formula
  667. Lookup Formula - I think?
  668. Grid Line
  669. $ sign formats
  670. Restocking spreadsheet
  671. Formula showing 0 - don't want it displayed
  672. Seniority Years Formula needed
  673. Is there a way to Alphabetize worksheets?
  674. Stop automatic data reformat when refreshing a query
  675. Input boxes
  676. error when opening a spreadsheet in Excel 2003
  677. How do I add a formula to a macro?
  678. printing a filtered selection without blank pages included
  679. INEXPLICABLE FORMULA RESULT
  680. Excel formula bar
  681. Conditional Formating or IF Function
  682. WorksheetFunction not working correctly
  683. Outlook spell check
  684. Select a coloumn or row in a Pivot table
  685. Inserting a checkable box (checks when clicked) into Excel?
  686. delete both duplicates
  687. standard deviation plotting
  688. are there any templates for a daily calendar for Excel 2003?
  689. Creating graphs from data in other files
  690. How to House, 123 Street, Somewhere, M1 23X
  691. Can't change birthdate in cell
  692. Formula function(s) to do this? Or is it a formula at all?
  693. Column heading display numbers not letters
  694. Using a Macro in Excel to send an embedded sheet via Outlook
  695. index-match and another condition
  696. Hover / Coment in Save As Web Page
  697. After merging from excel to word i now cant open the excel spreads
  698. how do you show percentage labels on a bar chart?
  699. What is the letter description for paper that is 11x17?
  700. Difference between dates
  701. Conditional Column Display
  702. Printing Embedded Word Docs
  703. What is a 8.5 x 17 paper size also called?
  704. #NAME? - is there a way to stop this error message?
  705. Falta de espaço na célula para a inserção da fórmula
  706. Moving data between columns
  707. Coditional Format
  708. how to sum up values in the date criteria
  709. Subtoatal
  710. HELP! Extra Line Printing - Multiple Pages
  711. Conditional formatting: formula not working on other pc's
  712. please explain the difference between linking data from separate .
  713. Prevent from save if...
  714. #N/A values
  715. Color formatting issue when copying excel sheet from workbook to o
  716. some text formatting may have changed in this file because the max
  717. Extracting numbers from text
  718. Data Validation List will not Fill Down
  719. how to calculate hours worked daily & minus 30 min lunch, 7am-5pm
  720. counting by color
  721. Change size of drop-down list?
  722. How do i set up a counter?
  723. Folder shortcuts
  724. create an "if then" formula
  725. Max/min functions similar to SUMIF
  726. Don't understand this format
  727. No Workbook at Startup
  728. Vlookup data and numeric
  729. Data translation
  730. Condition
  731. How do I save a 689 character fixed field/record format file
  732. Compare EE #s & Copy Info
  733. Conditional format a cell in time increments
  734. Is this a bug in Excel 2007?
  735. Copying (and protected worksheets)
  736. Copying and pasting tabular text data
  737. Combine 6 worksheets into 1 worksheet - Summary
  738. Custom Cell Time Format
  739. Excel lack of compatibility
  740. auto grouping.
  741. Pivot Table Calculated Field Row - (For Balance Sheet)
  742. Formula Help!
  743. Conditional Formating
  744. Excel - Printing a page that contains an Embedded Word Document
  745. How to put save date in the header (or footer)
  746. Can I write my own help files (.hlp) for Excel workbooks?
  747. Validate if cell use data validation
  748. Excel Macro
  749. What's the difference between excel 2003 and 2005?
  750. Random Selection
  751. Pivot Table
  752. How do I copy a worksheet in the new Excel?
  753. Macro To Run Automatically For Any Worksheet Upon Opening Of THe F
  754. Formula to return column letters
  755. How can I hide a formula in Excel 2007 from other users seeing it
  756. Refer to adjacent cells as variables in formula
  757. Save as CSV results in an Excel file!?
  758. Workbook won't allow me to insert worksheet. How can I add one?
  759. questionnaire template
  760. How do I put a checkbox with no words?
  761. Data Fields in Pivot Table
  762. Page numbers appearing across spreadsheet
  763. Macro to Fit AutoShape over Range?
  764. Default Save Extension
  765. Error message - Errors were detected while saving FILENAME
  766. Cells not included in formulas
  767. Database problem
  768. excel spreadsheet compare
  769. Exporting Quickbooks Data into Excel
  770. Form a sublist from a list using lookup
  771. Formatting text within merged cell
  772. Unprotect workbook
  773. Commas drop off of number in mail merge to into Word
  774. Dating a file.
  775. Protecting Cells from changing or modifying long formulas
  776. Sorting by name but ignore the word The
  777. Why does my cell content display as '############'?
  778. Displaying BOTH formulas and values
  779. Timestamp for changes in any row of cells?
  780. Place zeros in blank cells
  781. Cells won't automatically update --- urgent!
  782. Count
  783. Print Landscape/Portrait based on level of grouped data selected
  784. Integrity of Column Headers
  785. Rotating on-call schedule M-F for 13 people?
  786. I am unable to unhide rows through the format menu.
  787. HOW DO I CREATE A SERIES INVOLVING CELLS ACROSS ROWS?
  788. Preserved cell formatting
  789. Need to find the name of the command buttons
  790. List Dependent Worksheet Functions
  791. splitting my cell
  792. LIST BOXES TOO WIDE
  793. Date value conditional formatting or Macro
  794. Multiple "IF"
  795. Import/export netCDF files to Excel
  796. Multiple "If"
  797. Creating a Macro? V2
  798. Balance of pivot table data
  799. Macro - Fixed text code needs replacing with variable text
  800. Add a mark in every row in a column
  801. Grey bar at left side of worksheet
  802. Equation
  803. What do I need to add to my macro to make the cell colors change
  804. How can I transpose reference cells by Auto-fill?
  805. menu float
  806. how do i veiw 2 worksheets on dual screens
  807. Data source name not found and no default driver specified
  808. search for words with capital letter at end
  809. Duplicate account codes that total amount
  810. how do I export excel spreedsheet to outlook address book?
  811. how to save the same file in other location
  812. help on a formula
  813. RE: dragging my formula
  814. Format Cell/Number
  815. Need to seperate every 6th row out of a column?
  816. QUESTION: How can I conditionally compute data in a pivot tables?
  817. RE: Adding LOOKUP to an overwrought SUMPRODUCT function
  818. RE: "" (double quotes with nothing between)
  819. Linking Information between Databases
  820. MS Excel 2003 - Autofilter for protected cells
  821. Column Headings in Excel
  822. Re: "" (double quotes with nothing between)
  823. IF NEGATIVE VALUE REPLACE WITH POSITIVE
  824. Symbols in a cell
  825. splitting up information in a cell
  826. Pivot Tables - Hide Zero Amount Rows In Office 2007
  827. Excel file does not open when selected
  828. PivotChart in Excel for Mac
  829. Copying down row to the next occurence in a different row.
  830. importing word document into excel
  831. PivotTable Row Count
  832. Prevent alpha character in numeric cell
  833. Choose items from a list and add to a string in a cell
  834. Excel 2007 Default Chart Template
  835. Sum if statement with a left statement
  836. Shared Workbook creating Backup when saved?
  837. open workbook b when workbook a opened
  838. Auto Fill Cells
  839. Can SUMPRODUCT work on changing arrays?
  840. how do i merge 3 files into 1 having the latest updates in 1 plac
  841. EXPANDING OPTION BUTTONS
  842. Fluent User Interface Ribbon Lost
  843. Column Headers
  844. higlighting worksheets
  845. Background color according to a specific cell value
  846. Simple Formula
  847. Cumulative Timesheet Entries
  848. Only show cells if they have data in them
  849. Creating an order form from a model number
  850. sum if column is equal to 2 options
  851. Very basic VBA question.
  852. How do I specify these date-range formulas?
  853. SUMPRODUCT - enhanced formula
  854. Formulas in arrays and named ranges
  855. Finding the MIN value, but greater than zero
  856. My list is too long. Cannot be opened completely in xcl.
  857. Formula to compare columns
  858. Logic Statements
  859. Advanced 'SUMPRODUCT' formula - MAX or LARGE??
  860. STANDARD DEVIATION AND GRAPH
  861. Cell References absolute?
  862. OFFSET & MATCH
  863. Excel Macros option greyed out
  864. Creating a Macro?
  865. hiding formulas
  866. Transferring latest date from a row to another spreadsheet.
  867. formula
  868. formula
  869. Adding top 10 numbers from 100
  870. Export excel comments to word
  871. insert objects problem
  872. countif in a subtotal function
  873. Re: Date to change format
  874. Re: cells containing text and numbers
  875. Match
  876. cells containing text and numbers
  877. Date to change format
  878. Macro for running on preotected sheets
  879. Delete a cell value if not "like"
  880. Cannot open Excel files from Explorer or email
  881. Auto Publishing
  882. Difficulty in structuring regression analysis
  883. Can't Edit Excel worksheet
  884. RESTRICT TO PASTE VALUES ONLY
  885. On exit from edit, Excel jumps to remote undesired cell.
  886. open access from excel ?
  887. The new seven wonders may be world wide it will be appear
  888. Can't enter break mode at this time ERROR
  889. Using Mouse selects more than 2 cells Excel 2007
  890. Pivot table - multiple data sources
  891. tender evaluation spreadsheet
  892. SUMIF with 2 criterias
  893. Macro to determine row of page break on modified presentation sheet?
  894. Decimal points data not displaying as expected
  895. WorksheetFunction help
  896. Can I sort horizontally?
  897. create a macro to automatically open excel
  898. create a macro to automatically open excel another excel file
  899. monthly & quarterly Summery
  900. Want A1 to receive contents of R (from MATCH()) and C (COLUMNS(R1)
  901. How can I open a .pxl file in Excel 2003?
  902. Is it possible to retrieve a program that has been saved over?
  903. Use a different worksheet in a different workbook drop down menu
  904. FORMATTING CELL TO ACCEPT MEASUREMENT
  905. Workbook/worksheets protected- can I allow tab re-naming?
  906. free pre-installed Office interfers with Office 2000 professional.
  907. How to summarize data and deduct on second sheet? (Formula)
  908. embedded wav files
  909. I want a dialog box when opened
  910. sort name records according to criteria
  911. excel 2007 compatibility issue
  912. How to put 2 tables side by side on the same screen
  913. Cell to return present month
  914. Excel Lookup help
  915. Excel 2007 automatically corrupts my data!!
  916. Need Help with ActiveCell.EntireRow.Delete
  917. Formatting based on date ranges
  918. Formatting based on date ranges
  919. Displaying zeroes in decimals
  920. A macro that fishes for colored cells?
  921. Strange Excel behavior please Help
  922. Limit workspace size
  923. How to delete at once empty columns in a table?
  924. inventory Add, Cost, Sold, Sold price - formula
  925. Formatting Formula
  926. stdev of an array?
  927. How do a make a column wider than the screen?
  928. Navigating with arrow keys
  929. Sorting in code
  930. How to embed picture that can not be copied or altered?
  931. Can Offset() be used in Excel cell formulas when filtered (visible-only)?
  932. Custom number format
  933. Formula for adding back value?
  934. How to avoid value losing zero in front of digits??
  935. Deleting Rows of Data
  936. Formatting in Excel
  937. Drop down lists and autofill
  938. missing data
  939. FILTERING
  940. Paseting filtered info into another sheet
  941. creating password
  942. CHOOSING FROM OFFERED LIST OF FUNCTIONS-XL2007
  943. Reference a cell based on Fill color?
  944. Need Help with ActiveCell.EntireRow.Delete
  945. fastdraft setting
  946. dropdown unhide sheet
  947. Excel Validation
  948. MS OFFICE EXCEL 2003: AUTOSAVED FILES
  949. What is a string while merging
  950. Macro- not re-password protecting
  951. combine 5 pipeline reports into one
  952. Remover number from one sheet to another
  953. Display text from a single cell in a column range
  954. SORT
  955. Lists
  956. How to erase pasted controls from an Excel spreadsheet
  957. troubles posting a message.
  958. "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully."
  959. Change row and column when copying formula
  960. Trouble opening hyperlinks to shared folder
  961. Data Source Trust Issues
  962. Formula Help Needed
  963. How do I display the last updated date in the page header?
  964. Merging excel into word
  965. macro to ask yes/no question and continue based on answer
  966. Some images dont display in Excel 2003 on one particular PC
  967. Validation List
  968. txt files into one spreadsheet
  969. Excel 2007 Error Message
  970. What's wrong with this if statement?
  971. Trim question
  972. How do I compare the data in Cell A1 with the data in Cell A2
  973. Filter not including added data
  974. Got to end of sheet - first column
  975. Select until blank row
  976. removing/ignoring time in a date time field
  977. Cell border won't print
  978. why doesn't this simple macro work in excel 2007?
  979. Bring focus to same cell every time opened??
  980. Making Excel speak to teach pronunciation
  981. Conditional Format
  982. #Value replaces formula result when file is opened. But why?
  983. formula for if/then
  984. how to make Excel linked to SQL Server 2005 worksheet editable?
  985. pivot table formatting
  986. URGENT - Excel as email attachment - jumbled
  987. Excel Newsgroup: Suggestion for sorting of postings by date
  988. Graphs moving
  989. Quarantine Workbooks
  990. Combining COUNTIF Criteria
  991. excel; hypertext from web addr?
  992. How to extract data from a column
  993. Command button align text
  994. Code cleaner
  995. Moving between cells when enter is pressed
  996. How can I color fill my drop down box for each individual text?
  997. excel transpose and references to cells in other sheets
  998. results incorrect
  999. Worksheet tab name
  1000. Non Breaking Hyphen in 2003