View Full Version : Microsoft Excel Misc
- Time format
- Converting or representing text as a number
- Print Shadding in Excel 2003
- Sum Help
- Printing 2 worksheets to a 2 sided document
- White Cell Font
- Problems with an Embedded Word doc
- Add-In Distribution Problems - excel vba
- Excel Add-In Distribution Problem
- Leading 0
- Totaling how many times a specific word is listed in a spreadsheet
- Problem with splash screen
- Import work sheets
- Dropdown List
- Numbering
- global macro.xls
- mailmerge in excel
- Opening multiple text-files
- pls help!!
- Excel mailing via Lotus Notes
- with workbook_newsheet, how to specify all new sheets ?
- Hidden Cells
- format multiple sheets
- Truncated Merged Cells
- Format/Row/Autofit
- new book saving & gridline colours
- selecting sheets in an array
- Check 2 columns of names for duplicates
- blank cells
- unable to open damaged excel file
- Auto FIlter
- Message: The File may be read-only, or you may.....
- EXCEL VS. MATHEMATICA, STRENGTHS AND WEAKNESS?
- Problems tabbing from one cell to another
- sumproduct
- Clearing data retaining formula
- filling datat to another sheet
- Combo-box with Choose formula
- printing help
- Please help
- lost Excel data!
- Numbering Add-In
- combo box
- How do I calculate cubed roots in Excel.
- Automatically deleting duplicate rows??
- Keep my A column visible
- Deleting rows
- Deleting rows
- Pivot Table Selection aka Goto?
- Decimal separator from Excel 2000
- Re: HELP!! What can't I type "TRUE" in a cell?
- Subtotaling
- Need to seperate alpha numeric data in a cell
- Max number of workbooks open
- Re: Deleting a Folder
- How to restrict the use of a workbook to one computer?
- eliminating noise from data
- format a percentage figure
- format a percentage figure
- COMPILE ERROR message
- importing online data into excel
- Spreadsheet Query
- RUNNING OTHER APPLICATIONS FROM EXCEL & MACROs
- insert new rows automatically
- ACCESS OTHER APPLACATIONS FROM EXCEL & MACROs
- Re: Importing of Linux (gnumeric) files
- Re: Sorting data to last 30 days
- Re: More Color Fills
- HyperLink option is gone
- Automatically Fill In Pirces
- Formatting Linked Cells
- Re: More Color Fills
- saving print settings in Excel 2000
- Merge and Center Problems
- Default Paper Sauce Setting
- Re: Need a calculated date field in a header
- Setting Tab Order
- Strange Tab Key Behavior
- Random List
- Expanding Data As Needed
- format cells - pattern won't change
- excel - nesting INDIRECT inside a VLOOKUP?
- excel - nesting INDIRECT inside a VLOOKUP?
- format cells - pattern won't change
- Pivot Table Drill down - what does it sort on
- Preview information
- Sheetnames in formula
- Splitting records to two rows
- PageSetup macro calls are slow
- Re: PULL DOWN LIST
- Splitting information from one cell into two cells
- saving workbooks
- Textbox Format as you enter data...
- Imported Datasource seems to be caching - need to pull updated dat
- Currency Symbol Problem - Costa Rican Colon
- Need to format font in a custom header
- ListFillRange needs refreshing
- Re: excel and com port connection
- different color file names
- Re: Either / Or
- Macro Question
- Re: Can you create Conditional Validation Lists?
- Pivot table drops columns on refresh
- Re: adding checkboxes
- Re: Deleting a Folder
- Guru help - Macros
- Run conditional macros
- Re: Change default date format when typing in month & day only
- Re: getting macros to work in all workbooks
- Re: Filenames change intermittently
- Output data to file in Fortran 6F10.3 format
- Re: deleting from main form
- How to get the last value on a column?
- email header
- Re: Pivot Table Max Columns - 2000/2002/2003
- Conditional Format based on if a cell has been altered
- Re: Creating different "what/if" scenarios
- sorting numbers
- Is there a way to "flip" when pasting? (copy ABC and paste as CBA)
- I really need help with this one
- Conditional highlighting from current date
- Totals of columns
- Long Delay copying xls files in Windows Explorer
- Query not getting the new data
- Counting with multiple criteria
- day in a week
- Spaces and numbers
- Removing automatic links
- Need help sorting numbers in Excel
- Can I plot curves from (x,y,z) coordinates?
- range select a value in a cell?
- Re: Working with names
- Re: Working with names
- Pointing to correct macro path using excel custom toolbar - HELP!
- Look & return values, in cells with numbers & words
- Excell error
- Cell Referencing
- Shading Certain cells
- Hel p insert days once a month has been selected
- floating comments or text boxes
- SUMPRODUCT ?
- EXCEL 97 URGENT ASSISATNCE NEEDED
- Sumproduct
- Re: Reorganise a list from vertical to horisontal?
- Including a formula in a path
- pivot table %
- Conditional Summing?
- EX03 - locks up when opening a document
- Check box error
- How to find paired values in one column
- Re: Reorganise a list from vertical to horisontal?
- Excel
- Conditional formatting
- Excel macro & MS XP OS trouble
- cell ranges in formulas
- Excel closes unexpectedly
- Backgorund images
- Hyper lInks
- Number Format
- Help!!! (Functions)
- Detecting a change in a cell
- #Value! message in formula
- Wrap text cuts off on print
- formula problem
- Word Wrap Default
- To unprotect password-protected sheet by Macro?
- masked input telephone number?
- date formula question
- Excel Chart - 2 Sets of Data
- Adding "&" as text in Header
- Copy without adjusting
- Cannot open files directly
- Not displaying 0 in formula cell
- Reduce chart white space
- Excel does not open
- adding the years...
- Sorting Certain Parts of Data
- Can't find the link!!
- Multiple Worksheets
- automatic formatting
- SUMIF vs SUM(IF(..)) vs SUMPRODUCT
- Run-time error '1004'
- Custom Help File
- The answer has to be simple.....
- Re: The answer has to be simple.....
- Print wrapping
- Re: The answer has to be simple.....
- Re: The answer has to be simple.....
- Calculation problems
- dialog editor question
- How do I invert matrices?
- Conditional cell color.
- Not Enough System Resources to Display Completely
- Re: No header in the first page
- What function would I use?
- Re: Difference between Time values
- Landscape Printing
- assigning macro to a button
- Data Validation Input Message Size
- Macro
- Saving .xls without macro
- Error loading worksheet
- Can the shape (appearance) of a cell be changed?
- Re: saving workbooks
- Re: Combo box dates 36646???
- Re: Sorting Data in and Excel Spreadsheet
- Re: disappearing hyperlinks
- Re: Inserting formulas in a path name (without having worksheets open)
- Hiding password characters
- VBA Calculation on "only" Filtered Visible Cells
- Removing a lot of stuff
- Adding to Pivot Table source data
- Calculation problem
- Reorganize excel listing
- How To Delete More Than One Graphic From A Worksheet
- How To Remove Multiple Hyperlinks
- abnormal font
- Dependent List in Control Combo-Box
- Re: filter out all the #n/a...
- Macro to insert blank line with formula
- Excel external data import query
- Last day of the Month???
- Including a formula in a path name.
- Excel Training in the UK
- Removing auto_open from workbook after execution
- How to sort rows by using the row color as a criterion ?
- Re: If statements
- Re: If statements
- lists
- Templates
- SUMPRODUCT Problem
- first letter of text box referece
- Dependent Combo Box in Forms
- Auto update of Pivot table
- workbook links, remove a bad one
- Cumulative totals of sub-sets of figures
- "Replace With" option
- convert formulas to values in place
- Very slow Excel
- Days of the Month
- document already open
- Automatic Macro
- Excel Charts - Toggle Series On/Off
- Finding Row
- Excel - FTP - XP Trouble
- Deleting with an IF Statement
- Using formulae to display pictures....
- Re: Changing format for a single cell
- Finding Value of a Cell in a Range
- Pivot Table: Misordered date Grouping
- Rotate Spreadsheet
- Re: Changing format for a single cell
- ISBLANK
- Excel or Access?
- Summing with a range of number
- switch 2 cells around
- Insert Text into a different Cell
- Concurrent access to data
- Matching data and returning header
- Formatting Heading Rows with AutoFormat
- Date Formula Help
- Pivot Table Problem - Excel 2000
- Hi! Urgent pls: Protecting sheets so macros/buttons still work?
- grpwise 5.5 client and excel
- fixed-width files
- What function would I use?
- Need to GOTO a calculated cell reference
- Printing
- Re: Sorting mixed text/numbers
- splitting the yeatrs
- Unable to Update Links.
- Text File Import
- Formula Help?
- Changing formats in cells
- 9.89E+09 Why this instead of a 10 digit number in cell?
- DSUM search issues
- Re: AutoFilter not an Option
- ISBLANK inconsistent with results
- Horrible print quality
- Auto refresh of Pivot Table
- Data validation input message
- Re: AutoFilter not an Option
- excel
- selectively deleting cells
- Matching (CORRECTION)
- Re: still looking for help with an If Then Vloop vba code.
- Re: Selectively deleting rows
- count if
- Adding a space in a pivot talbe
- Athos
- Help files not appearing
- Inserting column width in centimeters doesn't work correctly
- total number of characters in a cell
- Extract data in the right part of a cell
- formula slowing up processing
- How to vary column widths
- Re: Matching
- kind of countif
- Can't find project or library - Excel in Office Pro 2003
- Re: Discovering pivot table source
- Excel to Lotus
- spreadsheet does not open properly
- duplicate names in Pivot Table
- autosave/add-ins
- lookup formula
- sorting on a date format - maybe?
- 4th July Rules!
- Reference another workbook (variable name) inside a formula cell
- Display Form only!
- cut and do a paste special? instead of a copy
- Removing the numbers on a row?
- average on Pivot table
- Prorations
- Auto-refresh Pivot Table upon opening
- with ref to the dialog editor question
- downloaded excel zip files
- Deleting header rows when cut and pasting from another program
- Chart possible of dates vs. pounds?
- Freeze panes problems when Excelbook not maximized
- Diable excel macro for DATES
- Is there a way to create a "floating" sum/totals bar?
- another: CAPS, can you preset a column (States?)
- Adding the # of rows, not the contents...
- Re: changes on one sheet refecting on another
- Moving data
- Months List: changing the case
- Problem with sort macro
- Replace Cell Address in A Long Formula
- default printer setup for individual worksheet only
- Worksheet in Reverse
- Displaying all objects in an excel workbook
- auto-insert rows?
- Sort via hyperlink equivalent
- infinity?
- Dates pasted to new workbook off by 4 years & 1 day
- ROWS Function
- Multivariable regression (t-stat)
- Searching Data in Rows/Columns
- Excel 2003-timesheet calculation problem
- Date function help
- Save values only?
- Prblem with highlight function within exel
- VLOOKUP with a difference
- selecting every tenth row in excel
- absolute hyperlinks in excel 2002+ ??
- Re: Printing Double Sided
- Worksheet Protection
- Struggling with MS Query...
- Typing times
- MACROS
- prompted to save when no changes
- states as capital letters
- pivot table perhaps?
- Stop Buttons/Text Boxes Moving When I Print
- Copy TOC & TO Figures
- cut & paste error
- Rank column with changing # of rows
- A formula pls.
- macro problem
- How to Activate Open Workbook
- Re: Rank column with changing # of rows
- Select and Copy data in column.
- Opening workbooks on the same worksheet each time
- Re: Activate Open Workbook
- Combo Box- Character Look Up
- Re: Windows Activate
- Last digit of long numbers changes to 0
- inputting filename into a cel
- Re: Windows Activate
- Re: Activate Open Workbook
- Dave Peterson
- Excel VBA-Search and display in textbox
- Can an array formula be used in a user defined function?
- Vlookup version 2
- Some macro help with formatting object please
- Moving a symbol within a cell
- cond format
- Checkbox Usuage
- Colour code worksheet tabs
- Who saved the file last
- 120 small images making workbook 37mb!!
- OptionButton Help
- Landscape Printing
- delete sheet not available
- String manipulation
- excel vba - combobox dropdown
- Links Issue ?
- excel vba - cell value sum
- add result column to pivot table
- Chart question
- Unable to Read File
- Edit a group of cells with a macro
- 3 cell formula
- Excel Workbook too large
- counting unique or equal text
- How many charts per file?
- Scenarios in Excel
- website help
- How to open Lotus123 files
- Excel VBA - Counting Unique Cells in a Range
- How do i hlookup with the "row index number" changing
- attn: Gord, one thing I can't figure out!
- Excel files don't launch since installing MS-Money 2003
- excel asp.net problem - openning excel file in webserver
- Economics: Supply and Demand Elasticity Chart
- strange format change
- Assign Unique Number
- Need to split XLS file based on value of field
- hours and minutes calculation
- Import data row->column
- Row & Column Header
- Excel: How do I get a certain column to show on every page?
- Chart Formatting
- Excel Startup Problem
- Comparing Two Documents
- exporting files....
- Copying transactions pairs to the next row
- Footy
- Pivot Table Summary
- Copying sheets
- Was: Was: Re: Mulitipage Tomfoolery
- Spreadsheet query
- Printing Circles that appear as Ovals
- copy without space
- Selecting a Value from a Range of Values
- Conditional commands on filtered lists
- Summarize only numbers printed in Bold?
- Default Font Setting in Excel Comments
- excel vba - clear contents of cell but not formula
- Using PivotTables with > 65,000 rows
- Dropdowns
- How can I use minutes and seconds
- Display scrolling
- Changing the "Difference From" setting in Pivot Field
- Excel template wizard
- Re: using a calculated range
- Highlight a row in a listbox
- Chart - empty cells show as 0?
- Grid lines not printing
- Excel VBA - Accessing row and column indices from named ranges?
- Sum
- complex vlookup search
- "Comments" Default Font
- excel vba - contents erase
- Re: on startup command
- Time Calculations
- Re: quarters
- Importing a Text File
- Re: quarters
- Label Numbering
- Enable Macro
- Re: Automatically sum up
- Quattro Pro Converter for Excel/Office XP
- Pivot Table Data Source
- Using pictures with graphics on a web page
- superscript
- Replicating Chart Apperance with Macro
- excel vba - code for saving file to specific location
- Re: quarters
- Increase Size Of Auto Fliter Drop Down Box
- Excel Save As getting "folder is read only" error.
- Multiple Possibilitiy formula (IF or Table or Array)
- if, index, match
- Re. hyperlinks in a spreadsheet
- Row, Column measurement?
- Create unique list from duplicates
- Simple Macro help
- Customizing Excel's Border Defaults
- Excel Worksheets
- Re: Different Size Worksheets
- Excel 2003
- excel as a database
- separating data in cells
- Function wizard Problem
- Cell drop down selections, cell linking, and interpolating
- Missing toolbar
- cannot find microsoft office on my pc
- Protecting and Row Heights
- Horizontal 'sort'
- MROUND function
- Adding numbers based on certain criteria
- Mouse Wheel Won't Scroll in Visual Basic Editor. Do This
- bookmaps for book publishing
- Conditional Format?
- Array formula techniqes
- VLookup not working
- Number Format Issue
- How to make comments move with cells when cutting pasting, or inserting rows
- Ignoring text in a cell with a formula
- Why did my fonts change color automatically?
- Pivot tables
- Set a default value to Drop Down Box
- Seperate Numbers from Text
- Universal Naming Convention UNC problem
- Comparing Two Lists
- Excel
- 16th digits and following replaced by zeros
- Calculating Time over days
- Olap Cubes
- Stop displaying a line
- Variable data to copy in to filters "comments"
- Transferring Data in Excel...
- Re: how to count total number of words in excel file
- Varying number of rows
- converting excel 2002 files into PDF documents for emailing
- Re: Name or Number of AutoShape
- RE: Automatically sum up
- I cannot open a file I really need, Task Manager says it is "Not Responding" HELP?
- Remove Hyphens from a number
- Help With Match Function
- Counting paired data
- Date filled down?
- Column order in pivot tables
- Lost toolbar
- excel2003 版輸入造字的中文時會顯示亂碼, 但在excel2000 版時或
- column widths
- exit option to end macro
- Numbers to Text
- exit option to end macro
- Formatting Cells for time
- Button
- Summing/counting data when columns match each other
- help in lookup
- jump to cell
- Recover data from a corrupted spreadsheet
- Text Boxes - Scroll Bars
- Excel 2000: File format of Unicode text files
- Formula for Date and Time duration
- Calculations within summary cells, reflecting the visble cells only after filtering
- How to email just a sheet or a selected area of the sheet
- return right most word
- Non-Printing Cells
- Zero to appear as blank
- Circular References
- Excel-Export a file as a Fixed Length Text file
- Pivot and form retrieve data
- WEBSITE IMPORT TO EXCEL 2000 AND OUTLOOK 2000
- Autopopulating Cells
- directory: Test whether a path is a directory or a filename
- Superscript entries
- Listing each field once from a list
- dynamically calculated row number
- Large excel file with little or no data in it
- Re: Column Letter
- Merging many excel files together
- Feet and Inches
- blocks of formulas
- Shared Workbook
- Re: Custom Markers
- How to parse the date of a date serial..ex 28 out of 7/28/2004 23:12:00
- Re: add to last record quickly?
- Comparing sheets
- Re: add to last record quickly?
- iterate calculations / solving
- Re: Need to setup xls to compute and check Vin Digit
- Protecting cells
- Trouble with dates on a chart
- Organizing scenarios
- Re: what if users don't have excel
- Re: what if users don't have excel
- Dates prior to 1900
- Re: what if users don't have excel
- spreadsheets in separate instances of excel?
- Auto Correct
- Alphabetizing Help
- Pivot Table Not Recognizing Numbers
- Can Only Be Done One Way !
- open a file
- Problem with multiple users opening a worksheet
- External Reference
- find first data in a row
- solver help
- Seperating Numbers and Text
- Re: Rounding Time
- Convert Excel records to text documents in arbitary formats
- When I click on the tabs, I get a page icon and all is stuck
- Help With If!!!
- Re: Rounding Time
- Re: open a file
- Re: Rounding Time
- excel vba - something missing in formula?
- Multy Worksheets & Multy Cells - Linked
- excel filesizing
- Re: Need to setup xls to compute and check Vin Digit
- Autofill questions
- convert julian date to calendar date in excel
- MAx formula - Tedious process of writing all arguments individually
- Re: Multy Worksheets & Multy Cells - Linked
- Pivot table total decimal places rounding
- Ignore #N/A in formula
- Can Excel convert from hex to decimal and vice versa?
- restricting cell pointer movement in a "form"
- Excel Sheet & Mail Merge
- Access database created when opening Excel
- All column and row headers hidden
- Box in a text cell between lines of data
- Lost Certicate of Authenticity
- Excel pivot table counting problem
- Logging users accessing a spreadsheet
- Splitting large Excel csv file
- editing while using "find"
- Button To Print Workbook With Certain Settings
- excel vba - automatic invoice numbering
- Nursing shifts
- Converting .snp files
- Proper Function
- Summary page -advancing name of sheet
- Gridlines
- hyperlinks
- Re: what if users don't have excel
- Create Excel Form with Excel data
- RE: Text in macro returning Date
- Excell & MailMerge dates
- DATA/SUBTOTALS
- "document not saved"
- Re: title repeat but not every page
- Re: Inside If Problem
- Web Query problem
- Unable to set a cell's format as currency
- Summing Every Third Number
- Ugly Macro - Duplicates/Non Numbers/Fill Down
- Combinning Multiple Lists
- Re: what if users don't have excel
- Looks like a split, but not?
- Filling blanks up with values from other cels?
- alignment
- query on UDFs and 'target'
- Re: Need to setup xls to compute and check Vin Digit
- Odd error opening Excel files when double clicking
- Create a dropdown
- character attributes lost (eg font, italics, bold) when cutting/pasting from excel to quark
- Macro - autocorrect backup (Office XP Pro)
- Reference Material
- Too few parameters error when Get External Access Data
- XML and Excel
- advance filter query
- Worksheet name - Color change?
- Saving as Web page.
- ERROR when creating pivot tables
- Re: Errors
- Image hyperlink within Excel calls MS Photo Editor
- Dragging formulas in inported data
- textbreaking in cells
- Spreadsheet 'Properties'
- Shortcut
- Re: Discovering pivot table source
- Excel2000: Is it possible to use named ranges as chart's series ranges
- Printing a Page
- Links
- Tick mark
- Expand/Contract grouped columns in protected sheet
- Percentage formula
- combining information in multiple rows
- Assign Macro
- Excel Audit Trail & Compliance
- Excel gets invisible after closing workbook?
- FIND (Two questions)
- Normal and Preview Options
- Maximum # of worksheets in workbook
- European Version of Excel different from North American?
- Shared workbook-track changes off but file size still grows
- Problems with MOREFUNC
- matching, vlookup, index help.
- Cannot lock/protect Merge and Center Cells
- excel vba - 2 problems
- Is it possible to tel when a page was created ?
- excel in browser
- OLE DB OLAP Service
- Any way to only print the row heading?
- Opening template.xlt
- Re: Any way to only print the row heading?
- Path changing in formula when workbook in different folder
- Inserting multiple rows into a table while maintaining data?
- copy formula
- changing/formatting rows
- Selecting a Printer
- Re: Text gone wild
- Re: Text gone wild
- Re: Really Stupid
- Help with keeping inventory.
- problems with MS Word, Excel, PDF file etc
- Subtracting dates
- Help w/code
- Help needed with Function
- Help needed with Circular References
- Tab naming
- Dates and Serials
- Formula Help
- Converting capitalized text to lower case
- Printing Column Headings
- Getting Dates When You Don't Want Them
- sorting out duplicate data of slight variation
- personal.xls problem
- Getting Rid Of Blank Cells
- Message
- excell macro
- Form Fields
- Japanese language Macro help
- identify similar cell values
- Excel versions
- solver help
- Excel file will not open
- Creating a tally formula
- Change Percentage DIV/0! Error
- Deleting Certain columns
- How to succesfully sort column of formulas?
- any excel file opens with a blank Book1 file
- Modifying display colors
- Initilizing the VBA libraries (126)
- Re: excel quiz answers
- FlexFind
- WSH/VBScript Version
- Re: Really Stupid
- Block of formulas
- Re: Pasting Data Into One Single Column
- Labelling a range of cells
- Re: Vertical Record Lookup
- Combining information from multiple rows
- VLookup
- Comma Delimited
- no grid lines when cells are coloured
- No Calculated Field Option in Excel 2002?
- referencing cells in a pivot table - wierdness.
- Include Data 90 days from Current Date Only
- Re: Opening Windows Explorer Search window from Excel
- commas
- Re: Continuous Calculating Cells
- Mysteriously Deleted Files
- Re: Importing CSV files with custom dates
- Finding labor total for multimple employees in 15 min. increments.
- Postings
- delete rows?
- Convert to a Parameter Query
- Modules Management
- Display The Cell Of The Maximum Value.
- Verified bug with hyperlinks within Excel 2002 spreadsheets on XP
- vlookups not work when the file is closed
- Removing text from cells
- What formula would give a value of a last negative value in a range?
- making Images appear when conditions are satisfied
- [Group] Spreadsheets
- Conditional Formatting Problems HELP!
- from hh:mm:ss to hh:mm ?
- Project plan help
- Finding a Row and cut and copy
- Uniform % increase in column.
- Office 2003
- Deducting date & time
- IF statement
- What is the excel Wildcard in formulas?
208
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.