View Full Version : Microsoft Excel Misc
- Printing Problem!!!with Japanese characters!!!
- Any Great Ideas to Make Old Boring Excel Charts to be EXCITING & ENGAGING?
- Macro Command to run other Macro
- Character count in Excel?
- Transfer similar files into folder
- Find data in XL files
- Can this be done?
- Linking MS Project Data into Excel
- Removing Links
- Linking project data into Excel
- Gridlines in cells
- Pasting Word Documents into Excel 2000
- Excel Comments
- Right-Click Problem
- Right Click Insert - Office XP
- subfolders - Short
- Create folders from list in column
- Make "Enter" key do what the "Tab" key does...
- Macro Help
- AFAIK
- Conditional formatting question
- macro reference to checkboxes...HELP!!!
- Excel 2k Printing Issue
- Re: Opening to a sheet inside a workbook
- Sending Mail using Excel VBA
- Sending Mail using Excel VBA
- Re: Opening to a sheet inside a workbook
- Re: Excel 2000 format crashes
- sharing
- Excel 2000 format crashes on large spreadsheets
- how to change the appearance of command button
- Ctrl+End goes MUCH farther than useful
- Txt file import - automatic comma and semi colon separation?
- lock formula only?
- scrolling menu
- autosave
- Excel and Word interaction
- RE: Too many IF functions
- Lookup and return values
- Excel chart with breaks?
- Column Returns in different worksheets
- RE: Too many IF functions
- QueryClose Question
- Worksheet tabs
- Re: Random Number
- How do you change the size the arrow in a control combo box ?
- RE: Random Number
- Please help - spreadsheet won't print
- AVERAGE formula not working
- Linking to Access
- Re: Pivot Table Options
- Re: Pivot Table Data
- One More UserForm Question
- Dividing by 100?
- Re: Pivot Table Data
- Mouse Selects Cells without Mouse button
- RE: Too many IF functions
- macro to group
- Cursor Frozen
- Excel Problems
- Slow Spreadsheet
- Re: last five
- Merging Cells
- last five
- Conditional Formatting Based on Contents of a List
- Opening Excel files in separate windows
- Change height of an in-cell drop-down list
- Re: last five
- Re: Pivot Table Data
- &[filename] &[tab] added to cell
- Call A Macro From A ControlButton
- Leading zero's in text join
- Date to Text conversion
- HELP!!!!!APR calculations in exvel
- Re: e-mail adrress in a cell
- Blank Workbook
- replace text in sentence
- Re: e-mail adrress in a cell
- sort multiple columns
- Adding columns within a set of formulas
- Add Columns
- Template for Home Renovations Budget & Cost Control
- Frank, Where are u?
- LookUp
- Complex problem - taking a weighted average of 8 of a series of 10 values
- Can't format cells.
- Formula for # of days calculated from a date.
- Re: Excel 2000 missing menu file, view, etc.
- Re: Excel 2000 missing menu file, view, etc.
- XL 2000 six digit number and separate it into six separate cells
- using excel data base for address names
- broadcast email.......
- Shortcut to Jump Btw. Worksheets
- Protected cell
- Protected cell
- Lock Cells (Can't be changed)
- Labeling
- Call Up A Macro When Exiting A Cell
- format cell background color
- Unique Record?
- compatability??
- open multiple sheets of same workbook
- Re: Too many IF functions
- Strange SUMPRODUCT result
- Shortcut to worksheet
- Parabolic Sar Calculus
- Calculated item/Grouping problem
- Keyboard shortcut to Gridlines
- Re: Call Up A Macro When Exiting A Cell
- how to convert numbers into figures in excel
- a counting problem, please help!!
- Reviewing Toolbar
- Using Formulas inside of text string
- Mixing function in Subtotal
- TA chart
- Downlad of conditional sum wizard?
- Settings file
- Values in a range
- how to make link?
- Formula with row()
- formulas
- reply info
- frank you are a star thank you
- Limitations of the sum function?
- formula help
- Newbie Help
- Hide Comment
- Pull Only Current Month's Data From Another Worksheet
- costing worksheet for manufacturing
- costing worksheet
- Help with Formula
- HELP!! I need to write a formula and don't know how!
- Can "SUMIF's" criteria handle dates?
- Help With Formula
- New to Relational DB--help
- Pivot Table
- Help me with Conditional Sum (please)
- LookUp? from a list
- Open a Microsoft Works file in Excel 2003
- Looking for a timekeeper
- Email & Update
- Tranposing maillist help please
- Limit Value entered in cell.
- Protecting Sheet / Workbook????
- report - sheet 1 to sheet 2
- Top Ten rules for using Sumproduct ?
- Hotkey
- Adding to the same cell
- link to email from excel spreadsheet
- Closing Excel
- Data subtotal
- my new satellite tosh will not work with excel
- keeping a line of info safe
- Excel 2002 vs 2003
- Re: XL 2000 take the last six characters
- Re: XL 2000 take the last six characters
- Re: XL 2000 take the last six characters
- XL 2000 take the last six characters
- Array
- Read only files
- Data Sort
- Selecting from a list
- Random Numbering
- How to enter a function when the argument is the cell value itself?
- if condition or array
- Disabling ShortCut Bars
- Edits to linked worksheets
- need help again!!!
- Edit text in a cell using a shortcut key
- Save As Web Page
- Conditinal Formatting other cells
- sumif problem
- Graph
- Protecting Sheet / Workbook????
- Converting text file in to excel file
- How to calculate credit card interest?
- excel problem
- Opening a PDF from an Excel User-Form
- IF formula conundrum
- Macro Query
- Invalid Page Fault
- Problem in Excel
- Using VLookUp
- Disable Macros
- Excel goes to background when opening files
- dropdownlist in cell
- Page setup format - print area
- Hide formulas
- Using the Autorecover file
- Re: Column headers change from letter to numbers?
- Re: Column headers change from letter to numbers?
- Novell Groupwise 5.5
- Restoring Excel2K macro's from saved Win2K user profile
- Pivot table Field items
- Preventive Message
- Selecting a range.
- Find cells that summed up, equal a given value
- Moving contents of a cell without changing references to that cell
- Items with value zero on graphs
- NEWBIE: Looking for Function to Subract a letter?
- save as web page doesn't work
- Re: tabs
- Re: tabs
- Is this a bug in Excel? Strange copy/paste behavior.
- Desktop shortcuts will not open Excel workbooks
- probs w/ formulas containing "blank"
- How can I copy a graph from one page to another
- Excel File Does Not Open
- Attempting to create/align tab headers based on chart. (No macros in file attachment.) - test.xls (0/1)
- Re: Size of background on worksheet
- Problem with linking to a network file with Excel 2002 SP3
- Importing Text Files with too many columns
- RE: Simple Form in Excel
- Cell tab order
- last five
- Search for a text string across multiple workbooks
- Beginng formulas w/ operators
- summing rows with different criterias
- Default mail client
- Problem with Excel, appears to be anchored
- Excel to Works
- Importation Wizard
- RE: change to raster image mode
- Dilemma In Stock Sheet
- print problem
- Changing range of cells to absolute references?
- Display all text in a cell
- celprotection
- URGENT - Saving Excel Sheet as ASCII Text
- Can't edit Combo Box
- Grayed out close box
- Business days count
- filling a large range
- Excel 2002 Pivot Table problem
- Print worked last week
- conditional msgbox
- Re: real time elapsed
- Excel 2003 showing diferrent info from 2000
- Re: real time elapsed
- Compare two columns
- Re: Windows in Taskbar problem
- formatting cell
- conditional formatting
- Formula in a field is represented by a zero.
- print row numbers on right
- Help with changing of rank in a list
- How To Get Excel To Record Keystrokes And Not Just The Results
- sum across worksheets
- Worksheet Naming
- Remove Non-Numeric Characters from Cell
- MS spreadsheet = Excel??
- Windows Operating System for Excel 2003
- Importing too much data for Excel
- Increasing Most Recently Used Files
- Macros
- Run a macro following Autofilter selection
- Re: buttons
- Need formula to avg. 3 #'s with out recognizing zero
- Trace Dependents?
- Re: Printing colored text on black bkgrd
- Same Command..Different Result
- can I create macros
- Copy without linking
- Unprotect aSheet
- Calculating Percentages in Excel
- CVS files
- Arrow buttons scroll page, don't change cells
- Counting number of aoccurance in a table
- Color doesn't print when saved as html
- special paste
- How to I charge rate to different balances?
- Program Error When Clicking Print Preview
- Remove "Ghost" Programming From Previous Format
- How to create scroll bars in text box
- Array Lookup
- Re: Count in Autofilter
- Find cells that equal a given value
- zero values
- Simple question for those who know the answer. *Smiles*
- cursor seems fixed on one cell
- Text Wrap within cells
- calculating worktime minus lunch
- Formulae attaching external workbook with named reference
- Date format problem
- Olap in Excel
- Desktop shortcuts
- Running Total
- Pivot table
- How do you change the font size of the data --> visualisation list ????!!!
- Exclude Duplicate records from Import
- Cell alignment
- Negative Values in Excel
- How do you spread a value evenly between two defined dates?
- opening workbooks automatically
- Change Name of Workbook - Automatically
- Long Macro - Screen Flickers
- Rounding numbers question
- Help to improve a report imported as text
- Split up quantity grouped items
- recovering data
- values always multiplied by 100
- Running Access queries to populate pivot table?
- Line 'creep'
- help formatting columns
- Re: Temporay Cell Color
- Re: Temporay Cell Color
- Autoscaling Mulitple Axes
- Referencing images within worksheets
- conditional hiding of rows
- Advanced filter - Illegal Field Name
- Pivot Table Page Field Problem
- RE: Temporay Cell Color
- Changing cell format
- "Unable to Record" message
- navigating between worksheets
- How do I get the gridlines back to the normal default format?
- Keeping a shape visible
- worksheets
- XP: conditionally lock cells based on cell values without VBA?
- find duplicates from a range of data
- XL Stuck showing Formula and not calculating
- Progress bar or Please wait
- Works 3.0 backup to Excel 2003
- Leading zeroes, text/numbers, import/export
- Excel line graph with *thick* lines
- date format problem when using a formula
- easy question - drop down list to navigate
- Re: Aging of Receivables Assistance
- Page numbering across a workbook
- refresh pivot table will cut all other columns
- Re: Proper- Formula for whole document?
- cell tracking with date
- Merging spreadsheets without common data
- Re: Removing a Footer
- Re: A Formula for Adding
- Pivot Table Refresh wipes out all data
- Re: A Formula for Adding
- After saving, entire wksheet formatting error
- Proper- Formula for whole document?
- Re: A Formula for Adding
- Referring to cell on another worksheet question
- Stop Rounding Last Digit of 16 Digit Numbers
- Excel VBA-Insert application.username into named cells on 2 wkshts if cell is empty.
- Combining lists to find duplicates
- File size - got huge when added password
- Excel workbook size
- Conversion of Formula Cells from QPro to Excel2000
- Excel Form Control Position & Print display
- Wrapping Rows of data into new columns
- Pivot Tables
- Problem trying to insert rows in worksheet; error message: Too many different cell formats
- Task Pane Issue Excel 2k3
- named array range- having a brain meltdown
- NUMBER OF CELLS IN A WORKSHEET
- .xls files being auto-opened as Word documents.
- Excel Border Art
- Automating Excel Imports
- Hotkey for Zooming on a ThinkPad
- substract
- For Chip, etc "I cannot forget you!"
- Inventory work sheet needed
- add page break code in csv file to force break when loading.
- function in VBA - automatical usage question
- Data from CSV file modified on import
- Comment Box Properties
- Filter Table / List Box
- Adding a "1" to Phone Number field
- substrak with function
- Repackage my Excel workbook into software
- Code to Move information from one sheet to another
- Quick Question
- Script Language
- is there a way to convert a number to written words?
- Excel 2002 compatibility with Excel 2000
- equation with multiple variables and multiple inputs for each variable
- Sheet switching with keys
- Manual Calculation For Range Only
- VLOOKUP and Conditional Formatting
- Re: Solution? Auto Complete & Data Region
- Cannot Edit Excel File..... Please Help ASAP! TYIA
- column headers
- Re: inserting numbers
- Renaming Multiple Worksheet
- Calculate compound interest
- Re: inserting numbers
- countif or sum array formula
- Grouping ranges of cells
- Why can't I select the cell?
- Problem with external links Ex97-Ex2002
- Row Delete taking time
- help me!
- Importing Access cross tab query to excel sheet
- copy and paste
- Alternative to COUNT function
- Assignment operator in Excel
- Autorecover in Excel 2000
- Cell Comparison
- Pivottable
- Format cell to be negative
- Re: Len
- separating cell contents
- Error message when opening Excel 2000
- Count different values
- working inside a cell
- Combining Cell Contents
- Excel Pivot table calculation
- Replacing duplicate information from one worksheet to another
- add into a column of cells
- Cell tab order
- Trying to follow instructions
- HELP - Forumlas don't pick up new values
- Calculating cells takes ages
- Validation List to exclude Blanks
- Frequent occurance in two columns
- Marco/VBA Code to Serach a Column
- n00b
- Cannot Open Excel Files
- Find row of data
- months/days between two dates shown as a fraction
- Time Series Data in bins (Sumproduct?)
- Quick Number Format Question
- Printing A Page In Excel
- Problem with Auto_Close()
- Formula Displaying in cell
- Re: Calculating a Due Date
- changing ALL CAPS
- Re: Calculating a Due Date
- Re: Calculating a Due Date
- Wrapping text on merged cells
- Merging to Word
- Spellchecking
- Extreme beginner Question
- Opens all spreadsheets
- Revert to a previous save???
- Euro symbol displayed as a line - Registry changes
- querry
- Format part of a string...
- Command descriptions in Excel (Office) 2003
- Excel Multiplication
- Re: compare sheets and getting results
- Sort by rows?
- Protected Worksheet Not retaining Formatting on Text Drag default behavior.
- Re: Discontinue part of line in chart
- rows to columns
- fill in blank/empty cell with 0
- Sort mixed data without delimiters
- currency format syntax problem with formula?
- Formula that calculates % variance... but sometimes the divisor is 0
- Disappearing chart
- Breaking the links
- Sortting files by details
- Exiting a loop...
- Excel 97
- Excel.exe errors
- pivot table - totals as columns
- Problem with Application.DisplayAlerts
- Clever By Value Question
- how to unprotect a worksheet if have no access to password
- Re: MailMerge with Excel putting in 0's
- Make Selected text characters...
- Consolidate Multiple Workbook
- Compile error in hidden module.. DistMon
- Automatic Tab in Excel after cell entry
- Cell Highlight color
- Re: Print problem
- Re:Print problem
- changing text case in excel
- Surveys
- Saving Excel???
- Refresh Pivot Tables Automatically
- Maximum length of Name reference values
- Linking pivot tables?
- Re: Recovering a spreadsheet
- pivotitems.visible problem when its not there
- & in file path in Header/Footer
- Scan into Excel
- leading 0 on zip code dropped in excel
- Re: MailMerge with Excel putting in 0's
- Adding Numbers on 1 Column based on the Value of another Column
- Linking cells
- Converting and adding lbm & ozm
- Quattro Pro 8 to Excel 2003 - conversion
- Credit Card Statement (AutoUpdate)
- Exporting Data to Access
- Re: Len
- Saving a file
- owner of excel workbook?
- Re: cut & paste spreadsheet to function in a word ducument
- Import XML data in Excel XP Professional
- Office SP3 killed my VBA program!
- Accounting Format
- Inserting Footnotes
- apllying color to cell which contain different starting number
- Save using a Macro
- Right/Left margins for heater & footer
- Show a cell as drop-down even if cell not selected
- =text(now(),"Mmm")-1 ?
- Macro
- Re: =TEXT(NOW(),"Mmmm")-1 ?
- Re: =TEXT(NOW(),"Mmmm")-1 ?
- Formula please if possible
- Excel opens duplicate worksheet
- Size of drop down boxes
- Importing dates from text file
- Date Help
- Concatenate ?
- Extracting a number from a mixed cell
- lookup and paste row into separate sheet
- green bullets in cells - excel xp
- cannot find file or one of it's components
- The inverse error function (erfinv)
- Clicking through to unopened work books
- Unusual formatting question
- Transfering Word Doc tables into a Excel Database
- Works 2002
- Re: Multiple COlumns into One COlumn
- How to change link file update to manual
- Excel Not Accepting Dates in 1800s
- Re: formula
- Excel numbering question
- consolidating multiple lines with similar matching column
- Is it possible to count how many times a spreadsheet is opened
- Re: Excel numbering question
- Stopping Excel converting 1/02 to a date
- password
- Re: How to change Automatic Color? (default color black)
- How can I force Excel to open "On Top"?
- Re: Multiple COlumns into One COlumn
- Fixing Find (Ctrl F) parameters
- Printing Spreadsheet to Plotter
- change column properties from text to number
- More Columns
- boolean formula for grades...help!
- option buttons
- New DB Query Problem
- "Insert List" function on Excel XP
- Ntuser.dat error
- Printing page numbers in sequence order...
- floppy disk
- Re: columns have numbers rather than letters
- Re: columns have numbers rather than letters
- Re: columns have numbers rather than letters
- Re: Refining an Excel main page
- Pivot table formatting
- One column into three
- Jump Reviewing
- refreshing VB function after changing value
- how to check on date value
- Displaying formulas in a worksheet
- protecting a group of cells not a whole worksheet
- Unable to enter any data
- Merging data from Excel to Word doc
- pivots - not sorting at all in version 2002 XP
- Quattro Pro Conversions
- Help with counting user entered text values
- Formula for making a number 3 digits less...
- VBA return all objects
- Merge Documents fails to recognize column width changes?
- Increase the amount of columns
- Remove one space
- Viewing Links to source file
- Re:Formatting Cells
- Adding 3 months to a date
- fixed decimal entry
- Tool Bar Run Amok
- Custom Header Beginning with a Number
- Stop ALL Sharing
- Avoid "Overwrite" Message
- Why does formula automatically change to its result
- vlookup
- Auto Format
- Maximum Excel file size
- file format is not valid
- Month and Year calc
- Open message to MVPs and other Excel Experts
- slow moving calculations between pages
- Insert a page break for each new record
- method to sequence
- excel 'name box'
- saving workbook asking to rename file every time I save
- going to a cell
- Match & Index??
- Re: how to back into a number from a percentage???
- Delete macros
- Calculating the workdays of the week
- Reviewing Toolbar Comes Up when I open certain files
- Printing UpperBin en LowerBin
- Re: Discontinue part of line in chart
- How can I open a file with Excel, once I have used Word on it?
- Lookup Formula
- Saving as fixed length file
- Standby in Excel
- How to undo then redo the current formats in a macro
- Virtual drive
- Tab and Shortcut keys don't work
- Counting names
- options unavailable
- Excel crashes with linked files
- adding a column below another larger column
- importing and manipulating data
- Small numbers in the top corner "Xs"
- Re: How to change Automatic Color? (default color black)
- Preventing user name from appearing in new cell Comments.
- Re: Print Preview
- excel opens but the workbook doesnt
- Undesired pop-up
- Conditional Format....IF
- Group on date field in pivot table
- Multiple lines of criteria without repeating header
- How to disable auto-convert ?
- LINKS TO TEXT BOXES
- Formula autofill with new records
- How to Solve System of Equations
- Removing page breaks
- Pull Unique Values From a List/Table
- Matching partly
- Formatting a variable
- separate windoe for each excel file opened
- how to open second excel file in second window
- Second window for second excel file
- Renaming Tabs Error
- copy paste
- Excel doc Acces Denied...
- Moving Workbook linked to ODBC query
- Conditional formatting
- Creating form Letters from an excel spreadsheet
- Formatting Page
- Clipboard acces via VBA
- Umlaute with Excel
- Moving the link to Acess to another location
- Excel Worksheet Protection Problem
- Email sheets seperately
- Filter drop down list not complete
- Maths Puzzler
- Excel 2000, lost macro toolbar
- Text/Edit Box on Forms Menu
- Cell Drag & Drop without Incrementing
- Why does CTRL END go to blank cell beyond workspace
- Pivot Table Charts
- Hide Macros with password.
- Filtering & 'Show all' when w/book protected
- Access 2003 download to Excel 2003
- Stacking excel tables
- Linking with Access
- How to "clean" a BIG historical data range
- Google screen flicker.
- Re: using a access table
- Help with a summary
- opening excel files
- recover excel files
- Add In menu
- link comments?
- Re: How to preview a file before opening
- Copy and Pasting Cells with VBA..help
- Re: How to preview a file before opening
- Re: How to preview a file before opening
- Need MS query to check Current Directory
- Selective Deletion
- Paste Dialog Box
- Re: How to preview a file before opening
- Working with dates in an unusual way?
- average of percentages between 1% and 100% in a column
- Recovery of excel files
- Excel/Word merge
- Adding a hyphen
- RE: Adding a hyphen
- Using AutoSum Button results in miscalculations
- RE: Adding a hyphen
- Excel 97 does not close after spreadsheet is closed
- Different footer on same worksheet
- How can I display zeroes that do not look like the letter "O"?
- Re: Working with dates in an unusual way?
- Testing a range of cells in an IF FUNCTION
- Shortcut to macro failed
- Adobe print icon missing from Excel
- Calculating Depreciation
- Trouble playing back macros after copying a spreadsheet
- Links within combo box
- Pivottable looses Grouping on refresh
- number of worksheets
- ROUND Formula
- Columns Sorting
- Showing Formulas
- time keeping for multiple entries
- Re: Assigning file property a cell value.
- How do I prevent macro from looping
- RE: Assigning file property a cell value.
- formula to compare columns?
- Pivot Tables: Avoiding Cross-tabs (Nesting) in Row Variables
- Can You do a Double CountIF?
- Getting rid of Alt + Enter
- Conditional Formattting
- Copying a macro button between sheets
- is there an "IF-OR" function??
- how do i exclude division by zero....
- Excel question: can this be done
- 6:49:00 AM converted to 00:06:49 AM
- Col head to repeat @ break
- Missing Menu Bar - Excel 2000
- How do delete Hidden Macros and excel links
- dividing a text based on a delimiter(dynamic)
- Can Excel do this with functions?
- Major Money
- Using Report Manager
- Default Template (Excel 2000 for Windows)
- Books on writing EXCEL MACROS (for beginners)
- converting lower case text to upper case?
- Named Ranges - Macro Problems
- sorting by color text
- How to highlight cell with value?
- Retain Customized Toobars
- Trying to calculate a time sheet formula
- vba
- import binary files
- Price Pointing/Complex Rounding
- Assigning Unique Numbers
- Error Message "Unable to read file"
- BeforeClose Event ref UserForm
- Macro Path
- Help Needed!
- opening multiple files
- Looking up data from Access
- Open an xcel file from explorer
- more about time stamping
- Help! Import text file cannot be found
- re: new rows are not refreshed in Pivot table
- countif
- GetIUMS MSDART.DLL
- format cells: decimal or integer needed
- Invoice template
- Convert calendar data
- An Easy One!
- page numbers
- Excel data selection
- Skip cells using Tab or Enter
- Add formula
- datas ms access to excel
- TEXT problem...
- template ti writing checks
- Formula help, Eric?
- How do I find days between two dates?
- Printing Snaking Column reports
- unable to print column headings
- I don't think ANYONE can add pounds and ounces!
- Dynamic Hyperlink
- Converting and adding lbm & ozm
- This ought to be a good BRAIN BENDER
- "IF" Function question
- Excel - Import & combine
- cannot get to borders of worksheet to drag it into place.
208
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.