PDA

View Full Version : Microsoft Excel Discussion

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]
  1. Deleting Macros
  2. Scrolling in Excel
  3. Re: Deleting zero value cells
  4. Re: how to rearrange values in fields...?
  5. Re: how to rearrange values in fields...?
  6. Used Users' Poem
  7. Re: Excel locks up
  8. How do I remove Off-topic SPAM from a newsgroup?
  9. Re: Excel AutoComplete
  10. Use of Worksheet Tab Name
  11. Resetting Regression parameters
  12. color-coding cells and more
  13. Need to cast OleObject to ComboBox
  14. Colour format weekend days ?
  15. Re: Date & time field problems
  16. Re: Date & time field problems
  17. Increase Excel Precision
  18. Re: Looking for a "Simple" EXCEL Solution
  19. (excel) Änderung einer aktiven Zelle während der Eingabe wahrnehmen
  20. File locked for opening
  21. Excel crashes when copying worksheet to new workbook
  22. 97: initializing VBA libraries (1157)
  23. Unhiding several worksheets
  24. xls to htm?
  25. MS Excel Talks to MS Access
  26. rule of 78 templets
  27. Emailing Excel Sheet
  28. Creating a viewport of a worksheet/selection on another worksheet
  29. Replace Paragraph Return
  30. Excel 2000 - How to access hidden cell formula when protected with UserInterfaceOnly ?
  31. Converting horizontal data to vertical data.
  32. Length of time
  33. Help With Simple Combobox Programming
  34. Re: getting Sheet names
  35. Pivot.sourcetable property incorrect?
  36. plotting confidence bands
  37. Assigning values as codes
  38. Excel - Sorting Data Help.
  39. Re: How to update formula in other files
  40. Date of Birth to Age
  41. Refresh Graphic Image
  42. Refresh Graphic Image
  43. Refresh Graphic Image
  44. 2002-2000 (or VB6.3-VB6.0) problem
  45. Re: getting Sheet names
  46. How to fill down without changing the format?
  47. **Copy paste question
  48. Published spreedsheet as web page BUT I can't see it over the Internet
  49. Validation List not showing external source.
  50. How to paste Conditional Formatting to other cells but using different data cell
  51. Help ASAP. Changing number string into date?
  52. Not updating objects when changing datasource
  53. Postcode Problem
  54. formula
  55. Trouble with copy and past of formulas in Excel
  56. Problems opening a database
  57. Validation Issue
  58. Running Excel on Web Server
  59. How to hide sheets and VBA code in my Excel workbook?
  60. CTRL-C & CTRL-V have stopped working
  61. Excel+ODBC == read-only?
  62. Help Urgently needed
  63. =clean(a1)
  64. Print dialog
  65. Help: I want to force selection of a group of cells.
  66. Page Setup
  67. ? Sum(hh:mm)
  68. How to prevent access to hidden cells?
  69. Dave Peterson_ Re No Grid Lines
  70. Need help using a SPC tool
  71. Re: Cp&Cpk
  72. <HELP> Excel has too many issues (VBA) <HELP>
  73. Copying values not formula
  74. Paste from Acrobat Reader
  75. custom trendline confusion
  76. I have a league...
  77. Office XP Excel missing exit, minimize buttons
  78. No Fill is stuck
  79. Business forcasting help...
  80. HTML Web Site Row Range Question
  81. Inputting logs into Excel
  82. Help with cell referenceing
  83. Excel Report stops converting currency
  84. Re: Menu Bar
  85. Multiple Inputs in a Form (Inputbox) - Checkbox
  86. printing on 11 x 17 wide printer
  87. Re: Killing the Paintbrush Icon
  88. Split name cell
  89. column format won't change???
  90. sheet size - scroll bars
  91. Re: pasting across
  92. Re: Menu Bar
  93. Re: Combine all cell into One
  94. How can I sort or filter by COLOR ?
  95. Fixed decimals turning themselves on
  96. Basic sumif question
  97. How to paste a cut of an autocad drawing into excel.
  98. Cannot close Excel with X
  99. Smart tag?
  100. Thought you might like this
  101. how to rotate a textbox.
  102. Re: Macro Inst. to close out of the program
  103. Minimizing an Excel screen
  104. Table of contents from Named ranges?
  105. Re: Creating a Macro that will stay
  106. Help with displya of time formats
  107. Macth 2 Column and Return a 3rd
  108. Lack of Know how
  109. Excel remembers! How?
  110. Excel 2000 Runtime Error
  111. Renaming columns
  112. Cp&Cpk
  113. Postion of number
  114. Putting symbols automatically
  115. Rotating line chart orientation
  116. Countif
  117. Deleted all macros, but still get warning
  118. Pierce a cel so that formula is on all worksheets in a workbook
  119. MS Query
  120. excel error "no more new fonts..."
  121. Re: VLOOKUP Help
  122. Merging multiple sheets
  123. Slowness deleting columns
  124. Re: Cannot select range in other excel file....
  125. Re: File Name/Title Bar
  126. Re: File Name/Title Bar
  127. For Each Problem
  128. lookup?
  129. Checking of lines between 2 pairs of co-oridantes corsses
  130. Re: XOR in Excel
  131. F4 Repeat Default Restate
  132. how to save an icon made by mysellf.
  133. Printing problem.
  134. Probs silly question...
  135. url to stock price?
  136. Skip Holidays
  137. Formatting cell time format
  138. excel 97
  139. comparing two columns
  140. Filters
  141. Now() function question
  142. Data Entry across columns
  143. AutoFormat
  144. How to fit a row height to a cell contents automatically?
  145. hacking open password
  146. Re: Getting Stock Quotes
  147. Re: Most efficient way to save workbook?
  148. pivot table help!
  149. Changing all Formulas to Absolute References
  150. external data/web query
  151. random numbers
  152. how remove all text to right of a comma
  153. teaching entry level Excel
  154. Reference? Question
  155. comments
  156. Re: Pivot Tables and Scatter Chart
  157. Names of ranges
  158. Re: How to repair a corrupted Excel file?
  159. Email program hyperlink
  160. (?) Set default font and font size in comments?
  161. Re: formula
  162. Multi-cell array
  163. SQL in Excel?
  164. MOUS Expert Certification - HTML Round Tripping and Query
  165. SUMIF using multiple Criteria
  166. Can custom properties be displayed in a cell?
  167. Is a "real" absolute reference possible?
  168. Help!!!!
  169. Global named range ????
  170. how to calculate appreciation using excel 2000
  171. Help Protect Your Computer Today (Immediately)
  172. updating query
  173. Date value not recognized on computer
  174. Sow opening Excel 2000 worksheet
  175. no Name box
  176. Pivot Chart Format
  177. Insert Date sheet was modified
  178. Re: Column Labels Are Numbers?
  179. finding average within a range
  180. computer reboots when printing excel files
  181. How do I make histogram graphs look the same?
  182. how to automatically put creation date in a record
  183. Re: COUNTIF() data types problem
  184. Plotting parametric curves
  185. Put tab names in cell automatically
  186. How do I copy data from one cell to another.
  187. Re: Sort by colored cells
  188. Re: VLOOKUP Help
  189. Using COUNTIF with multiple criterium
  190. Plugging data from non-open Workbooks
  191. Re: Sorting into amounts
  192. Cannot move or copy sheet to front of large notebook
  193. Save As CSV problem
  194. Re: paste special
  195. ERROR on opening excel
  196. Re: Excel 2000 opens to PERSONAL.XLS
  197. Re: Pocket Excel: Find old version of Excel File because I saved this with unwanted changes
  198. error massage - "file format is not valid !"
  199. Validation rules changed upon condition
  200. Re: Read from txt file data
  201. Open Excel files linked on web page in Excel instead of IE?
  202. Geometry Question
  203. Drop Down in Cell?
  204. Re: Graph's default look
  205. Re: Read from txt file data
  206. grouping thread
  207. how to delete if condition fail
  208. Animation
  209. Function
  210. Custom Format
  211. Password Protected File
  212. Re: adding subtracting degree (not temp)
  213. Re: Seaparation of VBA Code and Spreadsheet
  214. Re: Significant figures, part 2
  215. Sheet Names
  216. Rows & Columns on a page
  217. changing digits or letters to barcode
  218. Date formatting question
  219. Dates changed in cells?
  220. help needed
  221. number format question
  222. Re: Regression Tool
  223. Re: Lock cells if other cells blank
  224. Re: Converting a Time format to string
  225. how to copy the first row to a new page?
  226. Invoice
  227. formatting pivot tables
  228. Using Excel to fill out scanned forms
  229. Re: Counting values in Excel - Office 97
  230. Site I found has some frre addins
  231. Help with charts
  232. CopyFromRecordset only pastes 1823 characters in a cell!?
  233. Re: Insert picture in header?
  234. Convert Text string to Array Formula
  235. Filtering text Criteria - Win XP - Office 2000
  236. Excel 2000 Menu Tools-Options does not work
  237. Excel as Active Desktop
  238. Re: Insert picture in header?
  239. Un-Hide Rows Help!!
  240. Change the Range of a Name
  241. Limit rows and columns
  242. Esgrow Balance Calculation
  243. Linking cell in Excel to Folder in Outlook 2000
  244. Chartingq
  245. Printed Curriculum
  246. XP Windows Explorer slows down saving of Excel files
  247. How to adjust width and height of cells in cm instead of inch or pixel ?
  248. Re: dialog box
  249. Pivot Tables, refreshing with additional data
  250. Increasing the number of files as recent files
  251. header with colored background
  252. Re: Setting colors of cells conditionally?
  253. Requesting formula help - Risk / Capm / beta
  254. Headings
  255. AutoFill To Unknown Column
  256. Rank function - can it be amended?
  257. Sorting after using VLOOKUP
  258. Re: assistance does not function in Excel 2000
  259. Converting from Lotus 1, 2, 3 docs
  260. HELP!! Trying to convert numbers.
  261. Data type issue in excel sheets
  262. Compound interest calcs
  263. Re: Graphing Trendlines
  264. Re: How do you add the totals of numerous worksheets...
  265. Re: Page Setup
  266. Two excel docs into one...with a common value
  267. Why does this work... ... but not this?
  268. PASSWORD PROTECTED EXCEL WORKBOOK
  269. 12 point decimal system
  270. Merged cells.
  271. Dynamic cell updating btw Workbooks?
  272. Re: Adding numbers automatically
  273. Changing a text field to a number
  274. 3D Updateable table
  275. Re: Arrays: why doesn't a two variable query work?
  276. Alternatives to VLOOKUP?
  277. Repeat last action
  278. Capitals
  279. Re: Extracting invoices in a month
  280. Re: SubTotaling (2 Criteria)
  281. Re: Extracting invoices in a month
  282. SOS!
  283. Re: SubTotaling (2 Criteria)
  284. Re: Adding numbers automatically
  285. Re: Percentage
  286. I make to write in a cell list validation?
  287. Re: Percentage
  288. Re: Inserting picture
  289. Re: Splitting and/or Merging Cell Data
  290. Re: euro converter
  291. Formulas not data 0
  292. Re: Splitting and/or Merging Cell Data
  293. macro that cleans single the unblocked cell
  294. Re: Converting Lotus 123r5 to Excel
  295. UNDO MACRO in Excel
  296. Significant figures
  297. Calculate time till my Holiday
  298. basic saving formula question
  299. VBA Import from Access using ODBC - then trying to manipulate some columns; import comes after
  300. call dll's from Excel asynchronously ?
  301. Break Cells
  302. Re: How to change the format of the default blank Excel workbook (Excel 2000)
  303. Re: Text entry with overflow to adjacent cell
  304. Looking for a consultant with expertise in Excel, finance, and accounting
  305. Look-up between two workbooks
  306. Re: Exporting Fixed Width Column ASCII Format
  307. Cell Editing Macro
  308. Use Arrray or else to find unknow
  309. Count appearences of a string
  310. Re: Normal Curve
  311. removing duplicate values from a column
  312. How to create in checkboxes automatically true
  313. About setting HPageBreaks agian
  314. How to find the differences between 2 Excel files???
  315. FUNCTION problem, Please Advise
  316. Re: Normal Curve
  317. Re: Export Excel file to pdf or jpg
  318. Help With Worksheet Operations
  319. Distinguishing between upper & lower case characters for vlookup .....
  320. Re: I make the leaf of report with a macro?
  321. Excel worksheet merge
  322. Toolbar Macros
  323. Re: Export Excel file to pdf or jpg
  324. Re: Ampersand In Header Doesn't Print
  325. Re: Ampersand In Header Doesn't Print
  326. Edit Cell Macro
  327. Short Course booking problem
  328. Re: goal seeking
  329. Double-click does not open file
  330. how to write dynamic link library for excel to use?
  331. Re: No click top 3 rows
  332. Anyone?
  333. Re: excel to exe
  334. Single Pivot Table from multiple spreadsheets
  335. Getting text file into excell
  336. Referencing a cell/sorting
  337. Re: Can the data range in a chart contain a formula?
  338. Using functions
  339. Years of Service Accrual
  340. Re: tell me if this is possible
  341. Re: Identify color in shape object.
  342. How does Excel determine the TEMP directory?
  343. rounding to 5 cents
  344. Disabling Pivot Table Interface
  345. Re: Q: Make all numbers positive?
  346. Re: macro as exe or the like
  347. Drag & Drop List
  348. Importing Fixed Width data
  349. Opening a file
  350. Date Subtraction
  351. Size of a user defined type with a byte array?
  352. Re: Wrong Dates
  353. Re: deleting rows
  354. write Macro or DLL to copy data from worksheet to memory
  355. Excel Macro Warning
  356. Exclude Dupllicate
  357. Horizontal
  358. Range as a Varable
  359. VLOOKUP
  360. Count worksheet with specific value in a cell
  361. Q: How different colum-widths?
  362. Re: Make all numbers positive?
  363. Re: Make all numbers positive?
  364. Q: How to make "whole" numbers?
  365. Re: How to extract two values
  366. Need HELP! for Linking data
  367. Re: HELP with forms and data entry
  368. lookup table to dynamically display photos
  369. Weird autoformat
  370. Rounding numbers then doing a sum of those numbers produces incorrect result.
  371. QueryTable
  372. Format tabs missing
  373. Convert XLS to CSV in Excel
  374. Help Error
  375. Excel templates for inventory management
  376. Problem beim Speichern mit VBA
  377. Re: move cells without cut and paste
  378. Calculating percentage of time
  379. Tab location
  380. Copy Workbook
  381. Color Tabs
  382. Hyperlink to worksheet possible?
  383. Format Char
  384. saving file problems
  385. I lost a plugin
  386. brianb probably 2 basic for here
  387. Re: move cells without cut and paste
  388. check a zipcode
  389. Pivot Table question:
  390. Text Form Field
  391. Time Format and Unload Problem
  392. Pick cell yellow where I want
  393. Stop Excel from making numbers an equation?
  394. probably 2 basic for here
  395. Re: Summing only certain values...
  396. What are the external files links to Excel spreadsheet?
  397. consolidating
  398. Re: Select Printing
  399. Startup and exit error
  400. Splitting one table into multiple tables/tabs
  401. Row and column numbering
  402. Re: Exporting to XML
  403. Is there a way to stop the virus scan when Excel opens
  404. FAQ to find difference of two dates expressed in days
  405. rounding
  406. Changing date format in header and footer
  407. How to spell check a protected sheet?
  408. VBA Multi Number-Letter Sort
  409. Printing Problem
  410. LOOK UP ITEM IN A LIST
  411. Re: Sheet Name on Tab to show as A1
  412. Bitwise And
  413. Re: Sheet Name on Tab to show as A1
  414. Re: Variable row reference?
  415. Re: Variable row reference?
  416. Operations within Pivot Table
  417. Formatting advice?
  418. Expansion of a format on new cells
  419. Excel bug when reordering query columns?
  420. Refresh PivotTable Data Field List
  421. Excel not warning if another user has the workbook open
  422. Solver Add-In
  423. Re: Right indent
  424. File damage on network share
  425. Re: Greater Then Date in VBA
  426. Re: Result based on text poattern
  427. freezing panes
  428. Re: Entering Dates
  429. Re: Speaking of lookup tables
  430. Re: Entering Dates
  431. creating pushable buttons
  432. Re: Excel refusing to calculate
  433. Name of good books for programming in Excel
  434. Name of good books for programming in Excel
  435. Newbie: Can a Pivot Table do this?
  436. Help Creating XLL
  437. Re: graphing
  438. Re: Gradesheet template?
  439. Question about Excel/Word 2000 Privacy
  440. Re: cells
  441. Loan Acceleration Sheet
  442. Application Error
  443. Count if based on 2 criteria
  444. Production Worksheets
  445. Custom number format
  446. Re: Date Format Cells
  447. Re: Graphing
  448. Dialog Box for selecting folder
  449. Editing Data source from imported web query
  450. machine freezes when click on Excel
  451. problem (bug?) using =HYPERLINK in database query column?
  452. Re: Repeating rows disabled
  453. Print Excel To Word
  454. Sorting macro
  455. How do I open Excel with a spreadsheet from MS Access
  456. Re: Why cop and brain surgeon removed my brain?
  457. Is it possible to run a macro all the time?
  458. Insert .gif into protected doc
  459. Help with "save as" macro
  460. Combining Multiple Sheets into a single sheet
  461. Pictures unintentionally stretches
  462. dropdown menu of hyperlinks
  463. VBA Question
  464. Help question
  465. Printing problem - multiple pages where once there was but ONE
  466. Format a Logical Value?
  467. Converting a document to greyscale
  468. List of worksheets
  469. Lock-Protect documents
  470. Re: Lookup tabes
  471. Transparent Child window of opened Excel file in Excel 2002
  472. Where am I?
  473. URGENT - Not entire page printed out!
  474. Convert
  475. First Empty
  476. list to tabular format
  477. Re: Eliminating zero before decimal
  478. Where are the links?
  479. Viewing tables in an SQL database
  480. File menu items missing
  481. Forced Save
  482. Can't set HPageBreaks
  483. Dates and Arrays Driving Me Nuts - Help!!!
  484. Find duplicates
  485. Re: Excel Presentation in Powerpoint question
  486. Generated Excel 97 documents limited to one worksheet
  487. LookUp
  488. Re: Graphing
  489. Help with "unexpected file lock"
  490. Finding Previous Date in Date Range With Duplicate Dates
  491. Re: Unique values
  492. Re: Graphing
  493. Empty Cell
  494. compiling multple worksheets
  495. how to merge sheet between files
  496. How do I do this condition
  497. Inventory Worksheet
  498. how to get change history in VBA
  499. Keeping text formatted as text when replacing
  500. Hyperlinks, UNC names and File mounts
  501. Office 2003 and Web Services - questions
  502. Cannot find GWL97.xla
  503. Adding & subtracting cells (not values)
  504. Re: Converting number to date
  505. XSD
  506. Can array formula return text?
  507. Column Names
  508. Re: count function
  509. AREA UNDER A IRREGULAR GRAPH
  510. Simple conditional formula
  511. Problem with opening
  512. Unable to delete sheet
  513. Sorting lock
  514. Excel a provoqué une erreur fatale
  515. Password lost
  516. Postal Address Verification
  517. number format needed in inches
  518. Excel XP saving to Excel 2K format.
  519. Menu Options being held in different workbook?
  520. BUG FOUND: Excel 2003 Beta2 Refresh
  521. ANNOUNCE: rChart v1.3 Released (PowerPoint® + Excel® + Flash)
  522. Increment Cell Numbers
  523. Pictures wider when printing
  524. Bar chart - with cumulative and comparison
  525. Re: Hiding #N/A
  526. Re: Rounding Up Beyond Format Properties
  527. Re: Rounding Up Beyond Format Properties
  528. Sharing a excel document over the internet
  529. Hit Return, Back to B1, etc
  530. Re: Excel Presentation in Powerpoint question
  531. Access violation (0xc0000005), Address:0x3003ffed
  532. how to reset 'last row'
  533. password
  534. Compare data in columns
  535. User Form
  536. WorkDays Differece
  537. Unable to open excel file
  538. Tab Order Problem?
  539. summary report from all sheets as an present date
  540. Forcing IE to open Excel on a web page with the excel toolbar
  541. Conditional Formatting Question
  542. Automatic link
  543. PivotTable:cell formating
  544. PivotTable: qalculated cells
  545. Re: converting oz to kg., and vica versa
  546. Re: Hours and minutes
  547. workdays difference
  548. protect printing
  549. Re: converting oz to kg., and vica versa
  550. Rounding time values to nearest 15 minute and convert to decimal
  551. Tab Colors
  552. Checking for a network path?
  553. XML Syntax
  554. Re: where is FAQ?
  555. Change Cell Colours according to number input
  556. different number format
  557. yet another csll selection query ..
  558. XL97 - Out of Memory when open workbooks
  559. link to last line used
  560. Re: Hours and minutes
  561. Writing data to Specific Cells???
  562. Locking Cells??
  563. combining cell entries
  564. Re: Right indent
  565. Adding a databound list box to excel ?
  566. Re: graph to raster image
  567. Las Vegas Party
  568. Replace "?" with " "
  569. Re: Sequential Numbers
  570. Re: Export to csv in excel
  571. re: VBA Problem - Passing a TextBox Object as a parameter
  572. Re: more on data selection problem
  573. Re: Works files
  574. Re: Printing area
  575. Web linked Excel Macro does not work. HELP
  576. Re: pivot tables and percentages
  577. Formatting X-axis
  578. Count distinct
  579. Re: where is FAQ?
  580. Re: where is FAQ?
  581. Re: Excel XP upgrade problem
  582. Macro
  583. Re: where is FAQ?
  584. Re: German & English excel formula compatibility issues.
  585. Re: where is FAQ?
  586. Using names in a formula
  587. Excel behaving oddly
  588. how do I display pounds in fractions?
  589. Re: Formula help
  590. Re: populating one sheet from another
  591. online yet?
  592. Re: Remove macro warning
  593. FORMATTING - hard questions - ?
  594. online yet?
  595. Excel 97 will not open a shared network file, only flashes on the screen
  596. Text to Number format
  597. Excel XP to Excel 97 to Access 97 paste Errors
  598. excel-outlook express
  599. Excel-Sage link error
  600. count number sunday+saturday in many week
  601. Re: split cell
  602. Re: Sum and SumIf
  603. Remove Scientific Number
  604. Printing comments.
  605. Hyperlink cell placement
  606. Strange thing with this formula written by VBA
  607. Percent to Whole Number
  608. simple data selection problem
  609. Finding differences between two tables
  610. Day Date Problem
  611. Re: Ask me again
  612. Re: From Word give over a date into Excel....
  613. MENSAJE DE PRUEBA NO LEER
  614. Tab Order on Protected Worksheet
  615. Re: German & English excel formula compatibility issues.
  616. moving to cell Y if cell X has value Z.
  617. simple Hyperlink help
  618. Re: tabular format?
  619. Excel table macro
  620. Check Boxes in Cells
  621. Re: Sorting numbers within multipule rows and columns
  622. Statement
  623. Smart Tags
  624. Re: How to remove "Company Name" from file properties?
  625. Re: Excel Default date
  626. Compile Error Messages
  627. Re: FInd the unknow
  628. MapPoint Question
  629. Re: Help using INDIRECT or something like it
  630. Re: Help using INDIRECT or something like it