View Full Version : Microsoft Excel Misc
- Function help
- growth vs. forecast.
- Average only cells >0
- Locking Cells?
- Right Click Function
- Copy/paste cells w/formulas
- Re: Excel test
- Sorting In Pivot Table
- .xls changes sizes from one computer to another
- Spell Checking in Protected Sheet
- Limiting Digits in a Cell
- Can you transfer to new computer
- close button doesn't work
- David McRitchie - Where are we on crossposting?
- Excel file minimizes whan a linked file launched
- Search for first cell with data
- Finding the two (2) lowest numbers in a range of numbers
- form letters
- Re: Charts
- Excel question about "Find" or "Search"
- Cannot open multiple excel files by clicking on new files
- ODBC - List of table errors
- rounding.
- Re: close button doesn't work
- Change Column Heading Names
- importing web page
- Cells and Charts not updating!
- Re: Macros
- Re: Using a formula to copy text from worksheet to worksheet
- Re: Calculating in excel
- Help
- Internet Explorer Script Errors in Excel Help
- Re: Replace specific characters within formula
- Read Only in Shared workbook
- Re: Using a formula to copy text from worksheet to worksheet
- Sorting merged cells??
- Unprotect my Spreadsheet
- multiuser access to excel files
- Switching from Lotus to Microsoft
- single function, multiple outputs...
- Shared Excel Tracking Changes
- Re: E-mail Command Button with Timesheet
- Re: "Subscript out of range"
- Startup Options
- Re: Data from worksheet1 to empty cells on worksheet2
- Re: Superscript notations
- Workbook won't come up...
- linking images
- Print Preview in Excel
- Duplicate entries
- Re: big question
- Filter on TODAY - a year
- Lease vs. Buy of Capital Equipment Template
- How to check sequence numbers in a range of cells
- Corrupted Personal.xls file in Word 97 ??
- Corrupted Personal.xls file in Excel 97 ??
- Active cell referencing question
- Pastespecial values between different Excel sessions...HOW?
- Help with repair workshop, IF statement, returning FALSE
- Date Sorting Question
- Re: Pasted values dont behave like values!
- additional rows?
- unprotect file: response to Truman's no help
- Double clicking excel in windows explorer
- Re: Last Saved By - User Login Variable
- help with Excel formula for a bowling score sheet
- Purchasing Office Suite
- Pivot Table - Sum not count
- Summing Questions
- Re: Excel 4.0 macro language
- cells not scolling
- Re: solving advanced mathmatical problems using excel
- Re: Macro data input to variable sheet name
- Double click to open worksheet?
- Re: Double click to open worksheet?
- Re: Please help
- Cannot print Shaded fonts
- Disable / equivalence to Alt?
- Re: Repeated message when opening Excel
- Re: Can't open Excel file from within Excel.
- space delimited files
- Re: Can't open Excel file from within Excel.
- Re: Can't open Excel file from within Excel.
- multiple optimal solution?
- Re: Custom Lists
- Macro Question
- Re: opening multiple excel files at once
- ms query
- Predicting a number in a sequence
- Text function - Custom format
- Change Column Name
- Multi language issue
- EXCEL 2000 problem
- Print setup
- Locking column
- load userform from other VBProject (Excel 2000)
- COM in VB Excel
- HELP Re: Why can't I get the two variable table to fill out properly
- list of files
- Re: Formulae for Document Progress
- Printing in custom paper size
- How to remove the Excel Program from Microsoft Office ?
- Convert to CSV from commandline
- Locking combo boxes
- MS Windows XP/Excel 2002
- Macro to send fax
- Re: Excel hyperlinks
- Opening Multiple files simultaneously
- Need formula for prepayment on loan please
- Re: Renaming files using information in Excel
- Columns labeled as numbers, not letters!
- Problem acquiring external data after updating DSN
- Summing
- Can't Insert Clip Art in Excel
- Read-Only Problem
- why can't break links?
- Dialog Box Opening Problem
- Re: Formula (Programming) help with sheet layout
- How do I concatenate Array with single cell?
- file locked for editing
- how copy worksheets into workbook where worksheet makes reference to there?
- Opening multiple Excel 2000 worksheets
- Brain storming on how to optimize a formula
- Symbols in Excel
- Exporting excel data to text in word
- Re: Lookup a value and return the Cell's Address -Excel 2000
- Opening Excel Problem
- Cannot open Excel attachments
- Copy one sheet for each pivotfields if items have data
- Say "OK" to dialog box
- Opening an existing file
- Subscript in drop down list
- Re: IMPORTING AN EXCEL FILE INTO OUTLOOK
- err: copied formula has name that already exists, but I don't think does
- Not triggering "BeforeUpdate" in text box on UserForm
- Excel's option menu
- need help with spell check
- Checkboxes in Excel
- Converting to Access
- Filling down
- final try pivot help
- data fill problem
- Truncating #'s
- upload text and/or image files to a web server?
- Can't open excel file
- Merging information from Excel to Word doc
- Missing in Print Preview
- Re: Truncate Follow up
- Pasting (or "overlaying") a sheet of formulae on a sheet of data
- too many different format cells
- Saving Formatting in Pivot Tables
- vlookup na# error
- How to Remove a Logo on the Form
- Excel averaging wihtout #DIV/0
- Simple "IF" problem that I don't understand.
- Listbox unchecking on Save-as
- Calculate with "Precision as Formatted"
- Excell Version 7.0 (1985-1995)
- Special Formatting
- Referencing a macro in an Excel formula
- protection of the worksheet in Excel 97
- Re: Renaming files using information in Excel
- Re: Loose format when copying text from Word to Excel
- Fixed printing page breaks
- scanning pictures into an excel spreadsheet
- Pivot Table in Excel
- Excel pivot tbl - missing olap drivers
- Re: Truncate Follow up
- I have a time sheet but...
- application error message
- Sorting and empty cells
- Cannot Remove Macro Icon From Tool Bar
- Re: Excel 2000 locks up - even after reinstall
- printing
- Re: Excel Hangs when I close a file
- Pivot Table toolbar
- Excel Workbook
- Code: Paste Graph with no Edit-->links
- Re: Opposite of MODE Function
- dynamic cells
- protect file from getting deleted
- Re: cell propertry
- Linking Excel Workbooks
- rounding to 5 cents
- Number incorrectly read in Excel
- Drop-Down menu grayed out except for "File" and "Help"
- Re: user form update problem
- Cut'n'Pasting data
- Deleted Macro
- Re: can an excel file imported to word retain bold and italicized entries?
- Printing
- analyze access and excel
- Re: #value error with "plus" but not "sum"
- Excel Workbooks
- Re: Map Images based on Excel Column Values
- Average ?
- Toolbar options continue to appear
- Lost Menu Bar
- Deleting infromation from part of a cell
- limit columns / rows
- Display formulas instead of values
- copy data into comments?
- Templates Misbehaving problem
- Display a text but count as a num value?
- Getting rid of excel message after quiting excel
- Problem with adding criteria to Microsoft Query
- Trying to Embed Word in Excel
- can not open office files by double clicking
- "Reviewing" toolbar appears automatically?
- Re: Xlstart
- maximum characters per cell
- Open Workbooks using a for loop
- Re: opening multiple excel files at once
- Can the data range in a chart contain a formula?
- Cell protection / Compatibility XL97/XLXP
- External Link
- Avoiding the #N/A when performing VLOOKUP
- Re: Locked for Editing(read-only)
- Re: column headings wrong?
- Errors when opening .csv files
- automatically emailing form created in Excel
- Re: xlstart!
- Calculating Days in Excel 97
- Re: embolding text within a formula
- Excel XP Pivot Table question
- Changing the labels on a form via VBA
- strange number format
- Unable to open Excel file based on OLAP cube
- Runing a macro on Excel Startup
- Use of Month() within SumIF()
- Re: count-if problem
- Re: count-if problem
- Re: how do you reset what is bottommost cell?
- Re: opening multiple excel files at once
- Excel Advancedfilter problem - AND or OR ???
- Re: Still having syntax problems; graphing a named range that includes indirects to a non-contiguous range of data
- Creating a formula in a multi-sheet file
- Having trouble formatting times
- Watermarks in Excel
- Gridlines not printing
- last name May sorted as Month in pivot table
- Web Download Excel Spreadsheet
- 'HOME' key
- Reply with Changes
- Merge data from Excel 2002 into Word 2002
- color doesn't display
- Setting a graphic as a watermark to appear behind text.
- Group/Ungroup function
- Clear content cells with external link
- Initializated cells
- backing up Excel files
- First Occurence
- First Occurence
- Strange Excel Problem
- global freeze?
- Copy/Move question
- Most recently Used (MRUD) List
- Excell and Acrobat
- export/import excel2000/money2001
- csv - missing comma in last column
- save as web page header footer
- Re: cant close excel
- How to get Cell contents in scrollbar mouseover, not cell#
- excel xla
- First Occurrence
- Averaging time values
- Pivot table calculated field
- Re: import a pdf file?
- Excel 2000 - Time Calculations.
- Sum Calculation
- Excel "Insert Comment" Formatting
- Simple Excel Chart Question
- Re: Simple Excel Chart Question
- BAR chart.
- Re: error: can't open two documents with same name
- Re: XLS file fails to open
- Re: preserving trailing spaces
- Error about formatting
- cross referencing text from one workbook to another
- Automatically run Macro at specific time
- xls2txt xls2pdf
- fonts, change size in validation
- countif from two columns
- xls2txt xls2pdf
- Excel won't save
- Re: conditional average
- help: big chart problem
- Re: Opening a qpw file
- Password
- Wrap text in merged cells
- Data Tables
- Re: maximum excel size
- Xcel97
- CSV document opening in excel
- Re: import a pdf file?
- Open worksheet at 70%
- Excel XP - Double underline looks like solid line
- Preserving Fornatting in Pivot tables
- Re: solving advanced mathmatical problems using excel
- Deleting Information from part of a cell
- Maximum number of tabs
- Re: Cells move up and down freely
- Selection List box in a cell?
- Workbook.open function - no .xls?
- copy data to comments
- Pivot Table Sort
- IF statements
- task bar file options do not work
- Re: IF statements
- Re: IF statements
- date calculation
- Sorting in Excel 2002
- Comparing 2 series of data on Excel 2000
- speeding up calculation
- A query please
- How to Get the Character "Amersand" to print?
- summing shaded "filled" cells
- Excell - Changing font colour in a footer
- Excel 2000 under Terminal Services 2003 - page breaks
- Excel won't calculate
- overwritten file
- .txt files open in Excel as read-only
- Re: Virus Scans when opening files
- Search and Replace entire workbook?
- Dates in Excel
- error message
- Paste from text report keeping columns
- Office Products
- Save As Fixed Width Fields
- vba for hiding certain rows
- html page in excel-Open new window
- Delete links problem
- what happened to my "enter" key?
- Custom Number Fomatting Memory Issues
- Splitting workbooks, memory problem
- Task Pane
- Re: Saving
- Cell formatting
- Print Preferences
- Lower case i
- Re: Print Preferences
- Custom Paper setp
- Open a file exclusively?
- Ctrl+C and Ctrl+V not working?
- code needed, please
- pipe delimited format
- What Formula?
- Can't "Save As" a new filename
- Re: LOOKUP type function needed
- Errors saving to network drive
- leading zeros lost when opening a .csv file
- Need Unprotect/Protect for Excel Macro
- microsofts' crm?
- Q on how to find best combination of values
- Re: "SAVE AS" doesn't work.
- Printing Links
- links not updating at startup
- Re: "SAVE AS" doesn't work.
- Excel 97 default date format
- Macro Help
- Combo Box Inactive
- Formula staying as a formula in a cell?
- Pivot tables qty
- Excel 97 Margins do not fit page size
- Help needed to understand Vlookup Formula
- SR-1 Patch won't install into Excel 97
- Automated E-Mail Message from Inside Excel
- Re: how do you unprotect a protected spreadsheet you inherited
- Changing column letters to numbers
- Re: Macro
- Re: Custom Toolbar Icons
- Re: Macro
- Re: Copy/Paste in Excel prints highlighted cells and does not paste
- CTRL+END not working?
- Parts summary
- Selected cells are grey rather than blue
- Distinguishing between upper & lower case characters for vlookup .....
- word doc into excel
- Re: Copy/Paste in Excel prints highlighted cells and does not paste
- Re: Can't Save
- Re: LOOKUP type function needed
- Re: Custom Toolbar Icons
- macro transport
- Re: Excel Links
- Re: Conditional row suppression
- Re: odd occurence upon run of insert row macro
- Excel 2002 blacking out inserted Autoshapes
- recover
- MS Project Calendar in Excel?
- Re: MS Excel 2000: date format
- Can't use reference to another sheet in Data|Validation|Allow List?
- easy questions
- Error while opening spreadsheets
- Reducing "Save As" Options
- CULUMN REFERENCE TO CELL IN FORMULA
- resizing worksheet when printing
- Formulas in a added worksheet VBA
- Hyperlinks
- help: liny lines
- Automatically change field color if data entered
- MS Office problems with updating and saving files across the network.
- Link formats
- lead zeroes in zip codes
- German Excell
- Trouble opening .xls files
- Open textfile delimited with VBA
- MS Excel 2000: date format
- Re: Justify text
- Question 2:Color cell using conditional formatting
- Autofill query
- Excel Data Manager Tool?
- Need answer for "can not read file"
- "unable to read file"
- Excel 2000 Word Wrap
- conditional formatting
- Open Excel MS Works 2001
- Excel Fixes Row Height?
- Re: Excel Hangs when I close a file
- Re: Doing my head in!!!!!
- unique records
- Re: Index & Match with columns
- Index & Match with columns
- Re: Excel Highlighting
- Re: Excel Highlighting
- MS-Query Alternative?
- Re: Index & Match with columns
- Re: Filter mode-count
- Email help excel
- Re: restore prior saved doucment
- Open excel sheet twice at same time?
- Survey template in Excel 2000/2002
- Problem displaying Cell Shading color on Sony VAIO
- Re: Index & Match with columns
- Header
- Filtering
- PivotCache
- fill down
- Date Range as Criteria in an Array
- Dragging speed too fast!
- Cell Editing Macro
- Help Please - Vlookup problem
- Date formatting in Excel XP
- Embedding worksheet in Powerpoint
- Log Plots
- Autofilter in Excel 2002
- Row information from a specific cell...
- Copy/Paste Excel Plots
- pasting excel graphs into ppt-retaining look
- can comments move themselves when you hide columns?
- IF statements
- Re: Index & Match with columns
- Cannot search numeric in Excel files
- Default printing selection
- Print EXCEL code
- Comparing two versions of a worksheet
- Capitalization
- Re: Still get a "This file contains macros." after they're all been removed
- Barcode
- Re: Still get a "This file contains macros." after they're all been removed
- page break adjustments
- Re: LOOKUP type function needed
- read only
- Re: How to format a date in a formula
- Can't copy worksheets within the same workbook
- Re: Quad combinations
- Re: How to format a date in a formula
- Just a quick parse?
- Excel viewer
- Too many lines at the bottom
- Spreadsheet Cell References Wrong Info
- Excel Project Management Template
- Re: Filter mode-count
- can I make a bell curve from this data?
- Why a rectangle?
- Help with conditional formatting
- Re: Voice alerts in Excel 2000 Macro
- can't see/print select text in cell
- Name Ranges/ How do I print these?????????????????
- fields with many characters
- Save As truncates filenames to 8.3 format
- Automation of spreadsheet E-mailing
- Dynamic Range in a List Box with a blank choice?
- Re: Doing my head in!!!!!
- Data from web query to a single cell
- Upper case
- vinculating multiple spreadsheets
- Taskbar name
- Can't open Excel file from within Excel.
- Re: Runtime-error message
- Re: copy verticle cells paste horizontal
- Re: Deleting Rows in Protected Worksheet
- Re: copy verticle cells paste horizontal
- trouble printing entire workbook with different page layouts
- Locking data
- Comparing spreadsheets
- saving multiple sheets as a web page
- Re: Excel 2000 SP-1 problem
- Import XML Data
- if user changes cell - timestamp cell in next column
- Tricky Freeze Panes question
- Working with names
- Excel wont save properly
- Rounding dollar amount to the nearest quarter
- Not able to close Excel
- Creating read only cells in Excel 2000
- Pivot using three sheets
- Re: wrap and merge
- open protect
- Import text file in UTF-8 format to Excel 2000
- Automatic Disable of Autoformat in Excel without selecting range of cells
- Formula based on criteria?
- Macro errors when Excel workbook opened from a web page
- Re: How to change the format of the default blank Excel workbook (Excel 2000)
- Re: Worksheet tab name in a cell
- Selecting data from table based on variable
- test subject
- Month-date
- file locked
- mailing list
- Adobe Acrobat
- Comparing
- Include 1-x columns in @Sum depending on date
- Locking data
- Automatically combining data from several worksheets
- embedded word documents, printing the full object
- "Too Many Cell Formats!!!"
- Open event
- Data Validation List box scroll to the top of list
- Re: Formula Help
- More Formula Help
- hyperlinks to sites using cookie authentication
- Form options in excel
- Re: More Formula Help
- Re: help
- Re: pivot table
- Ctrl+PgUp and Ctrl+PgDn
- Form Question
- Hyperlink to a Chart
- Opening a document
- keeps freezing
- macro to list logins
- Re: Formatting titles
- Hyperlinks to Another Workbook
- Xfr excel data from Office 97 to Office XP
- #name? error after saving excel spreadsheet as web page
- command button
- Re: Formula functions
- Why Does Excel Do This ??!!??
- Re: pics in Excel
- Re: Exporting Excel file to dbf format
- auto save in tool menu
- Macro: movo to sheet ( content of a cell)? is it possible?
- Re: UNDO MACRO in Excel
- Excel 2000 - Calculate on Status Bar
- Visual Basic FileSearch Problem within an Excel Workbook
- Re: UNDO MACRO in Excel
- This doesn't work for Thin Client user
- Re: Hyperlinks
- can you put a watermark in an Excel doc?
- Exporting Names and Addresses to Outlook
- xcel 2000 and print preview issues
- Excel Mouse selection problems
- Re: Survey template in Excel 2000/2002
- Re: wrap and merge
- Date Function Question
- Re: Protected worksheet
- Re: Exporting Excel file to dbf format
- Re: Using Cell Value as Criterial Value for External Data
- Re: Opening up an excel file in I.E. 6.0
- Re: Semi locking cells
- Re: Splitting and/or Merging Cell Data
- Sort order in Save-As dialog
- pivot tables-changing format
- Hyperlink to a Visio Shape
- need help troubleshooting formulas
- "If-If Else Help"
- Unintentional Range Selection
- can you save excel as html?
- saving file names
- Re: For each item in a list box... total other cells?
- Conditional Format Chart borders?
- what is object "_Global" failed
- How to parse in excel
- Re: Don't show 0 values in a pie chart.
- Hyperlinks
- Thanks Tom & JS
- Excel Problem: Cursur disappears over Sheet
- Please help......
- Custom page size
- VBA/Macro/Date format help
- Re: Splitting and/or Merging Cell Data
- Zoom
- Re: Removing blank rows from a list
- Re: "text column" is not .....
- Italics problem with Excel 2002 for XP
- Re: Excel slows during printing
- Re: check writing
- Search
- Re: check writing
- Re: Formula functions
- Italics problem
- Weird Error Message on Launch
- using data from another cell
- Re: check writing
- How to I test for a blank time entry?
- Displacement of Comments in Excel
- Sheet protection disables comments in data validated cells
- Capturing a screen image
- Data Validation/Drop down list automatic update
- function symbols
- !!!HELP!!!
- web query query!
- e-mail
- Moving worksheets between diferent workbooks
- Edit links
- Re: Don't show 0 values in a pie chart.
- "Cannot empty the clipboard" when dragging cells
- Re: Hiding the first line
- does not recognize numbers
- re: mailing list
- Re: Formula Help
- Excel Icon
- Re: EXCEL Instructions
- Re: EXCEL Instructions
- Re: EXCEL Instructions
- Formulae for Doc Progress
- Re: Order of files with File / Open
- Re: locking cells
- HELP - Can not Share Workbook
- User form pop up if cell is empty on close workbook
- Re: Testing excel skills for job interview
- cell reference
- Password Protect a Workbook
- Help with an Excel formula
- Re: Excel 2000 SP-1 problem
- unable to use file "save as" to server
- EXCEL column headings
- Templates
- Importing schedule into Outlook
- Re: Changing Tab Colors
- Re: Changing Tab Colors
- excel cursor not displaying
- Convert 24.1 to days, minutes, hours???
- number format
- number
- MS Excel Sheets...how to copy and paste one excel sheet into another?
- Eorror openning Excel 97 File
- date calculation
- default page size
- Re: Date changes to a number
- if statement
- Locking cell color pattern when sorting rows?
- Lookup text
- Excel to delimited txt file in UTF-8 char-set
- excel 2000
- Duplex Printing - Multi sheet workbook
- Re: Excel 2000
- How not to display cell contents in toolbar above work area
- Sorting by IP address??
- Excel 97 / Excel 2000 compatibility problem?
- Re: memory?
- apostrophe problem
- Unable to save excel worksheet to cd
- Re: Importing works to Excel
- Strange Sorting in a Shared Wkbk
- Re: Search and list a directory's contents
- Re: Macro
- Comparing two sets of data
- Re: Character data in Pivot tables
- Re: Character data in Pivot tables
- PivotTables limitation ???
- goblin in my excel
- Creating formulas that use the results of an array formula
- ctrl+end problem
- Count function
- Re: chm files cause scripting errors
- Pivot table data source
- Excel 2000
- Excel Menu Bar Disappears after Powerpoint Use
- Re: Lookup
- Re: Lookup
- Conditional counting
- Inserting a Word document as an Excel Sheet
- DDE
- Printing worksheet tabs on labels
- how to create mail merge from excel address spreadsheet
- Re: can't open excel
- Excel VB Code Error
- custom tool bar
- text with numeric value
- How do I put a full path name in the header or trailer
- extracting data from word to an excel spreadsheet
- Re: Excel
- Re: Excel
- show zero as dash
- Conditional cell update and circular references
- Re: Decoding using excell
- Background or watermark
- Excel files close slow if you don't save them
- Re: Shading cells
- What you see in Print Preview is not alway being printed.
- method "open" of object "workbook" failed
- Re: number
- Days, Hours, Minutes
- Re: excel startup error
- Re: autocalculate to manual on win2000 server
- Name Conflict
- file recovery
- Error Attempting to Unhide Sheet
- Macro Security, Password Recovery & VB Code execution
- Re: Testing excel skills for job interview
- Getting data from Access to Excel?
- Caption property of AxisTitle object size limitation
- Re: Wont keep the data the way I want it..
- printer -form feed
- zip codes with mail merge
- References to other Excel Files - UNC
- Can't access Exell and Word any more getting error .....
- Re: Random number from normal distribution
- Setting Header left hand margin
- Re: Total needed - should be easy
- Total needed - should be easy
- Making a JPEG a Watermark and then trying to make it appear behind worksheet...
- Re: Total needed - should be easy
- adding watermark
- Opening excel in a separate windows
- Re: Making a JPEG a Watermark and then trying to make it appear behind worksheet...
- Find and Replace
- repeat rows/columns
- Text Files in Excel : keep strings
- Re: Worksheet is Locked for Editing...
- Autosave AddIn replacement
- unlock cells become lock cells after pasteing
- Re: Total needed - should be easy
- Excel file increasing in size
- Updating Pivot Table source references
- Hidden Macros
- Creating links between spreadsheets
- Piviot Table Data
- Import "tab name" to cells
- Re: SUMPRODUCT
- Re: ChDir doesn't always work
- sumproduct
- copyright & registered trademark symbols
- down loading EXCELL
- Re: calcuation and the INDEX function
- calcuation and the INDEX function
- Using formulas to filter
- "Window" options missing when in Web format
- Copy data from one worksheet to another.. but not contiguous data
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.