View Full Version : Microsoft Excel Misc
- Can you copy email addresses in to new column out of Hyperlink column
- Importing from MS Access problems
- Edit box - Excel 2002
- old style xcel help with REAL search
- How to use variables in ranges?
- Need more columns
- How to incorporate MultiSelect in userform
- inserting sum but not as formula
- Desktop Icon Accessing Network File
- How to get result?
- Help with OR formula
- my formats get pushed out when I insert columns
- Fixing the position of Comments
- excel header problem
- Sudden problem with Excel workbooks containing VBA
- AVERAGE AND or IF?
- Objects
- Insert the same information in many cells
- keep formula after typing in a value in a excel cell
- Calculating Dates and Hours
- Pivot Table(web) export to Excel -- Failed!
- Sorting
- Maximum Worksheet Size
- Can you use "Like"
- Problem with comma seperated list
- Stats/PivotTables
- How can protect my work book.
- search and replace with a paga break
- Edit cell format
- Different Cell Sizes in the Same Column?
- COUNTIF Problem I think
- link update reminder
- No more new fonts may be applied in this workbook
- Format fractions
- formulas
- Pivotable - Zero values
- Toggle Breakpoint (VBE)
- loop until questions
- Excel Template Wizard
- Set all checkboxes on a form to "true"
- How do I display the "&" in the footer?
- convert number format to time format
- combine the 2 formulas
- Validation
- Currency format won't centre
- Excel startup switches
- Help with Old Q&A Application
- Workbook Numbering
- Print Preview Not the same as 100%
- Cannot Enter Desired Value
- Hyperlink
- Delete rows
- Split tabs into different files
- Green background
- import external data problem
- Increasing number of records in a work book
- specification sheet
- Re: Changing Default Row Height
- How to calculate percentages automatically
- Number of rows in xls file
- Couldn't save changes
- HTML utility?
- Macro to copy macros
- Duplicate named ranges
- Formatting
- Unwanted Range Names are Imported
- Re: Copying Comments in Office 2k?
- Re: Size Matters!
- Re: calculating hours
- Auto-delete cells to avoid duplication of values
- Re: Divide columns
- uuffff ! what an if !
- Timeout on data entry
- Re: calculating hours
- Headers & Footers
- Amendment need to Macro !
- Add same text at end of each cell?
- Default Location Error
- RE: Advanced paste function
- SHRINK TO FIT doesn't work properly
- Re: Using Office Assistant to display MY message
- Creating a dropdown list
- Button to Activate Macro
- Adding times
- Sellect random 100?
- ERF function
- Re: How Do I Remove Formulas from cells?
- Adding times 2
- Hiding Rows
- Excel question
- underlining
- Re: Macro: Columns as #s within range
- Re: saving an imported file as xl template
- cell range lookup to another workbook
- Automaticall display a word
- Worksheet can not display picture
- Different sections in plot area
- Crystal Ball
- MS Excel 97 Fill Color default. Arrgh!!!!
- Consolidation of percentages in pivot table
- Vertical Scroll Bar
- Importing Frontpage Form
- trouble with financial balancing
- change format of existing numbers
- transpose function creating zeros
- help with formating subtotal ...
- Read-Only File?
- Hyperlinks
- Conditional formatting formulas
- Can A Named Range Be A Variable?
- Inserting a jpg as an object icon
- Hyperlink and file links
- Individual labels XY-plot
- Chart
- Date Question
- Pivot table
- Pivot Table - Zero Sum of Values
- Graphic Visualization of an ORACLE data on EXCEL
- Vlookup Function Needed
- File Size Limit??
- How to lock all the sheets?
- Filters: multi-criteria cells ?
- Possibly stupid questio, sorry
- Stats/PivotTables
- VBA-Copy entire row into another sheet if column K =today()+14
- Page breaks between groups
- How to handle hierarchy processing like this
- How to perform allocations, planning and budgetting in Excel
- Font Size in Combo Boxes
- auto numbering of columns
- Time enabled Macros
- Mortgage calc
- Get login name to spred sheet
- "file in Use"
- Sizing all comments at once
- Insert multiple page word doc into Excel
- Pivot Table - Without Zero values
- Page Break Errors
- Getting past the Worksheet Name character limit?
- Query Access 97 from Excel 97
- Location of .tmp files in Excel
- Setting Cell Color within a Cell
- protect column headings while sorting
- How to reapply an advanced filter automatically
- Emailing a Worksheet
- Formatting a 19 Digit Budget Code
- List of Pivots
- Amortization table
- Column truncation in tab-dellimited text - Excel 2000
- BMSLtd.co.uk
- highlighting in Excel
- Shared Workbook problems
- exclude columns in macro
- Subtotals or PivotTables
- stop row heights from changing during input?
- exclude columns in Macro
- Unable to draw a line in Excel
- Deleting Duplicate Entries
- Column formatting
- Setting the color of a cell from a cell
- only average cells w/numbers?
- Web query timeout setting.
- calculating hours for payroll
- Export to Another Workbook????
- File won't save - "Document Not Saved" message?
- Linking...help
- Excel Unable to Open Browser
- Compile Hidden Module errors
- Audit Trail
- Re: Quickly moving down a set number of rows.
- Protect Cells
- Mirror a number
- Cells stay highlighted, cannot use mouse
- Select Multiple Objects to Delete?
- Excel.exe error message
- Excel.exe error message
- Grouping and Protecting Cells
- RE: Printing two sheets too many.
- pprotect column headings while sorting
- Sorting for blank cells.
- Urgent!
- Excel Column Formatting/Functions
- Excel date
- Autofilter Grayed Out...
- images don't show in web page
- Excel formula fails to execute; remains text
- Re: Mock Database in Excel
- Printing two sheets too many.
- How to reference a active column in excel-tricky
- Re: Thanks for your help, but the formula given only applies to one color
- Re: Quickly moving down a set number of rows.
- Excel Pivot Table - 2 Reports With Same Page Fields
- insert worksheet
- Count references within a cell
- Number self formatting
- Macro's
- sum downtime by week
- Workbook Open
- FSO Properties
- Finite Difference Spreadsheet - Interesting SumIf Array
- Saving Conflict On Shared Workbook
- Removing External Links
- trouble with an if statement
- Re: Mock Database in Excel
- Question about Pie Charts
- Text Box snap to top of worksheet.
- How to extract all words in a cell except the last one?
- Sorting by birthdate
- Excel command line (startup) switches
- Re: Copy .csv worksheets into single workbook?
- Error 1706 Solver add-in problems
- Re: Copy .csv worksheets into single workbook?
- VLOOKUP #N/A Error
- Did not save my work
- how do i search for cells containing a question mark (?)
- Sorting dates
- Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet
- COMPARE AND COUNT VALUES
- Application.DisplayAlerts = False - why doesn't it work?
- Re: Previously entered, copy data
- Pivot percentages urgent help please
- How Do I Save an Excel Sheet on Internet Explorer?
- No more new font maybe applied in this workbook
- Disappear of Customize options.
- Summing values in same cell separated by #
- Sum formula
- HTML/XML format for Excel 2000. Multiple sheets in single HTML file
- How to select the last filled row
- Include Totals in Pivot Chart
- All spreadsheets keep hiding first few columns
- Pivot Table - Problem
- finding differing numbers.
- Cannot save comments
- Merging from Excel to Word
- Problem with PivotTable of FoxPro Database
- English instead of Local names???
- More questions about Pie Charts
- Read Error on Excel Files
- Automate excel sheets
- rounding numbers
- Protecting Workbooks and sheets
- The sum is always 0!
- formula
- toggling a chart on and off
- Conditional formatting
- Worksheet Name
- NEWBIE!!! word/text - speadsheet can i?
- instruction at "0x77f64d8a" referenced memory at "0x0000004d
- Importing data from Access
- Office 97 Excel
- Extract Values from Formulas
- Picture referencing
- assigning and viewing property fields
- Saving Excel Macros on a File and Print server
- Mysterious column heading behavior
- Heart Beat w/ Thud for 1:00 minute
- Freezing TabSheet Position?
- Executing sub from form code
- Multiple worksheets in one Excel 2000 HTML file
- Multiple users sharing one file
- Help with a spreadsheet - comparing data
- floating copy icon
- Pivot Table Query
- Lose data when copy and paste from workbook to workbook
- Re: Specification sheet
- Number formats in Excel
- Re: i will check
- back to front keys on keyboard
- Combo box problem
- color largest values
- How to create a new default template? HELP!
- VBA?Macro Newbie Question//Last field in a column with a value.
- Viewing Newsgroups
- Consoldating Data
- Re: Web Query
- ' in numbers and Pivot tables
- Eliminating GETPIVOTDATA Excel formula
- Possible to track who views my spreadsheet on a network?
- replace Hyperlink with URL
- Hiding a Worksheet
- Re: Hexidecimal
- lookup on Outlook contacts
- number display
- Pivot table item visibility
- Saving Files Opened as Read-Only
- Mode Function Using Text
- Problem with borders!
- Re: Help!!! Calculating Differences in Date/Time Columns
- Excel Formulae
- Re: Help!!! Calculating Differences in Date/Time Columns
- Double lines of text in one cell
- vb date and ssn textbox formats
- Works spreadsheet
- Excel Sort Behaviour
- RANDOM NUMBERS
- Perform function...if?
- expand 256 column limit?
- Stop Excel from closing ALL windows when clicking the X
- questions about formating to labels
- Saving individual pages within a worksheet
- virus scanner is preventing files from opening
- Updating Data from two different worksheets
- Max cell height for text
- cannot add buttons to the toolbar
- opening multiple workbooks, opens in seperate program...
- Opening files from explorer
- Comment Box
- EXCEL
- excel FX function
- Weeknum
- rounding time
- BUG !!! Excel 2002 save as csv coma not works in windows xp
- how to share macro for different workbook...
- New Sheet Macro Name Creator
- Format a cell
- canadian postal code
- Excel report help
- Table of contents
- Re: Hexidecimal
- Auto expand row size
- Range problem in all macro's
- Re: Possible to track who views my spreadsheet on a network?
- Saving Custom number formats
- referencing cells in another spreadsheet - do not update
- EXCEL charting in 3-D? How do I...
- Re: Design a simple data layout for printing purposes
- Excel Unable to Open Browser
- Displaying Filename and File Path, best way to deploy to organisation Excel2K ?
- Column Headings changed
- what is the definition of an Advanced Excel user?
- is there a quick way of getting rid of custom views?
- Having numbers automatically appear bold
- Is there an old Lotus version 5, info only do not need disk
- Cell Font Default Change
- Assign Recurring Macro to Toolbar
- Testing value of another wkbk without opening
- Codeing + TIME Suming troubles
- Graphic Visualization of data on Excel
- Date Time Variant NOT read when loading CSV
- Print only the last page
- Thank You!!!
- Concatenate
- How come my macro works if I pause and play again?
- Circular Reference Problem
- Countif Or Sumproduct????
- Personal Macro Workbook
- Pivot tables
- Delete partial string
- Adding columns past the 256 limit
- Merged Cells and Copying Problems
- Pivot table has an item called Formula1
- cell formats
- Excel getting closed giving an error message that some illegal operations occure
- selection.numberformat
- Setting A blank as a result of an IF statement
- Adding hours up
- Excel won't open shortcuts
- Removing e-mail hyperlink
- Getting column width sizes
- Median of differences of columns, with embedded "if"-Frank?
- Trying to Calculate a Projected Date
- Formula or not
- date & time formula
- Inventory control
- Re: Median of differences of columns, with embedded "if"
- How can I copy a horizontal range in reverse order?
- Interval detection formula.
- pulling data from one workbook to other one and back
- Anniversary Dates
- Roman Numerals
- Replacing a Worksheet
- Define Names
- Resetting cell value; after time/calculation has been made; Resolving circular ref.
- Re: Trying to Calculate a Projected Date
- Age difference
- printing format
- Locking Cells in Excel
- Didn't think this was going to be such a challange
- Different formats within the same cell
- text color change if value is true, another color if value is false
- How do I stop a spreadsheet from Auto-publishing as a web page?
- Spellcheck single cell
- Excel Trendline Formula in Scientific Format
- Prevent excel to auto format and auto apply formula to a cell when opening a file
- Re: author's name in a comment box for an Xcel cell
- How2prevent excel from auto formatng n auto aplying formula 2 a cell wen opening a fi
- Operating fill handle and moving entire cells with keyboard
- Really no protection???
- How2prevent excel from auto formating n auto aplying formula 2a cell when opening CSV
- Watermark Images & Text
- Subscript macro
- how to match 5 series and filter out which one is common to all 5 ?
- How to size a column in inches, see it the way it would print
- Undo Button in EXCEL 2003
- Data Validation
- Inserting time with ctrl+shift+: always shows 00 for seconds
- Linked workbooks will not update without having all workbooks open
- Urgent
- M/S Excel: How to activate formula displaying function
- Survey form Excel vs. Access
- custom chart type with image control
- Help With If Function
- Printing Comments
- Printing Comments
- time adding in excell
- Advanced paste function
- Conditional Formatting
- reference memory error when printing excel file
- Custom formatting numbers & dates with a template (for receipts/invoices)
- Define Names
- Excel Heading
- why does a blank cell =0
- Excel asks for logon when opening XLS file on FTP server
- Milliseconds in Excel
- Shared Workbooks???
- external link values
- summing cells of Time
- Setting printer in Excel
- an imported text field from Excel displays as an exponential number in Access
- Excel2000-File size is increasing without changes!!
- Comparing integer lists
- re: problem with combo box
- how to place a "check mark" in a column
- Formulas showing up
- Re: Autosave
- Re: Autosave
- Floor Plan Sketch in Excel
- Need help w very difficult formula!
- BLOCK others from PRINTING a Wrksht or WrkBk
- Check Box
- Data and Color calculations
- Template Wizard with Data Tracking
- formulas/functions
- Microsoft Query prompt
- COUNTIF problem
- Sections in excel
- update /delete external refs
- Line of best fit on a Histogram
- Help with Course Work
- Re: move contents of a row to a new sheet
- Code for formatting header
- decimal format preferences??
- Lock down certain cells and prompt if used
- Insert comments default font setting
- Excel
- searching directories for a workbook
- VLOOLUP for different rows
- "Virus scanner has detected problem with the file"
- Excel VBA combo box question
- Where to place Dim Satements
- Any way to make all references in a cell absolute?
- How to make this work????
- Re: Sorting Data
- Importing TXT file over existing spreadsheet - need to preserve existing data
- Getting rid of introductory screens
- Re: LINK TOTALS FROM ONE SPREAD SHEET TO ANOTHER
- save worksheet to another closed workbook
- Print Loop
- Making data highlight in bold - based on a condition
- unpleasant sounds when using Cut & Paste
- Any shortcut to prevent macro running when opening file?
- Opening a Word Document via a macro
- Function written in VBA not recognized
- downloading excel and word
- Pivot table - subtotal at top of column
- Click cell to print?
- Pivot Table compatibility
- programing cells
- lookup options
- Enter negative time
- Return a cell refernce based on a value
- scrolling in excel
- no absolute hyperlinks in excel 2002???
- random sort
- VBE question
- Merged Cells - Another Way?
- pro11.msi is not abailable for excel addins
- How can I EDIT a Range?
- don't permit numbers in text
- Unexpected error
- Embedded charts in Word
- Delete blank rows - HOW?
- Formula in macro
- Size of the GO TO Box - Tracing Formulas
- Basic Excel Formula Question
- Looking up a partial filename
- Hyperlinks in excel (GRRRR)
- Printing cells
- Shared offline files
- Blank cell not really blank
- Sum using Date Ranges..
- Excel XP automatic equals sign when formula bar clicked
- Can anybody reproduce this bug?
- Sum Numbers in a Cell that has text
- Macor glitch?
- excel, VBA, and asp
- VBA with asp and excel
- Autotext drop-down menu in Excel header and footers
- Inserting Columns
- Text in a cell
- Validation drop-down menus disappear in Excel 2002 w/o frozen panes
- Excel Help
- linking cells when it is autofiltered
- Excel Forumla Help - Find Most Recent Occurence of a Number
- Re: Cell Reference Question
- Charting value ranges
- Re: Cell Reference Question
- cell wrapping
- Excel Relative Reference
- date formula
- Doing calculations with date formatting
- VB Tutorials - Best place to start
- Looking up images
- merging files
- Any way to change all references to one column (in a cell) to another column?
- Intersection Arrays
- Pivot table
- Replace data with other data in Excel
- File locked by both operating system and Excel.
- Excel 2002 creates tmp file on network share
- linking two cells from two different worksheets
- Frank K and Bob P
- Formatting Icons which don't work
- Excel Opens Without Displaying Workbook
- ISNUMBER problem
- ISNUMBER problem (corrected message)
- concatenation and number format
- ISNUMBER problem
- Help with building a financial model
- Password Protection
- Text to Column
- Excel Shortcuts do not work in Explorer, but open in Excel (periodically)
- adding a horizontal line in excel chart
- Re: Sorting data/linking cells
- Problem with copy and paste
- Dragging and dropping cells with the keyboard
- Filters
- Protecting individual cells in a sheet
- 2 questions regarding graphs
- Sorting data/linking cells
- Keyboard Shortcut for "Go to next worksheet"?
- Shortcuts in Explorer not working for Excel, but opens within Excel
- Web Query to Passworded Site
- insert spaces between numbers in column
- Auto Expire an Excel File
- excel error message
- Updating File links in XL
- Found Page Border Template. But How Does it Work?
- worksheet prints different on different computer
- Spellcheck protected worksheet problem
- msgbox on workbook open
- Ann: GoogXL 1.0 - Free Excel Add-In for Google API Search
- Data validation
- Date formula
- Fill series inconsistent
- password protection paramenters
- Accounting Format: shows 0.00 instead of "-"
- Transferring Data from Excel to Quattro
- "URGENT" ... Cannot Open Excel File ..
- There's no "read only" popup for files already open
- Colour cell, no print?
- Excel 2002- Color cell borders print in black
- Locating an index of a range within a range
- Using a Decimal changes cell to a label
- Re: Sorting data/linking cells
- TBRun97?
- Formula - Use last value above 0
- Need to substitute text for faster data entry
- Stopping other wkbks sharing code
- Nested Ifs in Array formulas ?
- text and letters - Concatenate
- Why wont this work!
- Calculating a runtime in Hours/Minutes.
- Random Numbers
- Vlookup then change contents
- Need to automatically input date one time
- colors for shading
- format a cell for a timesheet
- file size sometimes doubles when changing one or two cells
- SAVING EXCELL
- Re: Turn off round up function
- Re: Turn off round up function
- Opening new Excel window
- Creating more than one pivot table in one page?
- pivot table percentage in a row?
- Ex2000 large file size?
- Sheet Select Macro
- How to Combine Data in Different Columns
- How to Unhide or Hide Multiple Sheets at One GO?
- Create workbook from a template
- Comparing two columns of data and flag any duplicates in the third column
- How do I create labels from a spreadsheet
- Create labels
- Excel Array Formula: Multiple Criteria Sum IF Challenge
- Formula help
- 16 th digit of a number in a cell gets chopped to zero
- Range names referring to other range names
- what version of excel can be added to millenium
- bug csv coma
- converting hours to decimals
- Number formatting
- Data Entry
- How to read multiple text files into excel?
- Update and remember previous values ?
- Hiding negative numbers
- Restore a deleted file?
- The Okopochini Bug
- The Okopochini Bug
- MSG: No more new fonts may be added to this workbook
- Help?
- Present Value Mortgage calculations with down payment.
- Re: Change spelling
- Need Help with Formula
- alphabetize an excel spreadsheet?
- typing in a ratio without it 'auto' formatting
- outlook address book in excel
- Printing long formulas
- When is the first worksheet activated?
- Modify a format style
- Making pretty reports - Advice please
- excel crashing problem
- Count unique dates
- email submission tool for converting xls to pdf or xls to plain text ascii
- Macros
- Problems entering numbers into Excel
- misc questions...urgent reply required pls help
- Lotus 123 print, formula, format, ect
- My spreadsheet is broken
- need a formula
- windows media playist import to excel wizard
- Change rows to columns
- Calendar and scores regarding the Basket Championship-League
- How to activate array formulas in a range of cells all at the same time?
- custom number format
- VBA to Fill all empty cells in all columns in a range
- import data format - pivot table mystery
- VBA code for MsgBox AND WorkSheet Active at same time
- End down
- Printing
- VBA code needing alteration
- Office programs go on there own
- Fonts misbehaving
- how to program recurring value
- Whats the difference?
- Insert Check Box
- finding old news messages
- Conversion of QuatroPro
- Ordinal format
- I need a formula
- VBA to EXCEL Formula
- Find last cell when in filter mode
- Kernell32.dll
- Pasting copied pages without the hidden or grouped cells
- Pasting an sql from notepad to a single cell in Excel
- Fractions and superscript help
- Max. number of characters to be shown in one celle?
- Tick Box/Check Box
- prompting to save workbook every time (even when no changes made)
- VBA Conditional Formatting ????
- auto calc
- Updating List of Accounts
- hiding columns when close to 256 limit
- adjusting scroll bar size and keeping page setup when copying pages
- Problem opening file created in Office97 using Office XP
- Identifing the most frequently repeated value
- Excel 2003
- changing cell value depending on list selection
- Reconfigured tab key help
- [HELP] This workbook has lost its VBA Project, ActiveX Controls and any other program
- Want to type HSI but Excel automatically return HIS ??????
- Solver Documentation
- Displaying data sort order as descriptive text in footer
- Limited Menu
- using text from a cell in the header
- Converting Pocket Excel .pxl to Excel 2003?
- XLS Files Will Not Open
- Drop down boxes AND free text?
- Re: VBA-What is it?
- End of Worksheet
- Excel issue
- Boolean expressions
- Excel 2000
- 2-way match formula?
- New Workbook Task Pane
- Excel 2000
- Returning the cell reference below
- Graph Y Axis Week Numbers
- Changing case of text in multiple cells
- VBA ActiveCell Range
- Pulling random columns
- Updating List of Accounts
- Excel 97 Landscape Print problems
- Extracting Values Common To 4 Lists
- Making the date a part of the file name
- Column Lettering/Row Numbering
- Using A Macro/VBA code to re-set formulas
- Links in Excel 2000...need help
- printing error
- Copying Excel Screen Shots Into PowerPoint
- Opening files in Excel
- Get count of unique field values
- Excel 2003 -- copy/paste error
- too many different cell formats in excel
- drop-down list and auto fill
- Week Number and Year Format
- Print area problem
- Named ranges- how do I "combine" several into a larger named range?
- Re: Using A Macro/VBA code to re-set formulas
- Excel - page orientation not changing
- Need Formula Help
- Shared file doesn't share
- Excel 2000 - Read-Only Problem
- Calculations with Oracle imported information
- embed a picture into a cell?
- sorting zip codes
- Lost the HELP page
- I need to add text from 2 columns in 1
- can't insert rows
- MS Excel 97 renaming shared file on save
- Cant find Button
- Changing text
- Help with copy/paste VBA code
- Different first page header
- Pivot table changes from 97 to 2000
- spell check does not visually cycle through cells when run from macro?
- Excel97 time format causes crash
- Excel, ODBC and creating queries
- Excel stock control system - Completely stuck - help needed fast :\
- keyboard shortcut
- Resource problem for Excel document
- How to show & print gridlines in .htm from .xls.
- reseting toolbars incase of fatal error
- Fill down only cells with Formulas VBA
- File location for backup (.xlk??)
- A simple Question
- Not Enough Memory - Excel 97
- A Question About Sorting....
- recover unsaved files
- XIRR Help
- xlb location
- Disable automatic refresh
- Copy and Paste
- Adding Formatting Instruction to a Formula
- Printing Filtered Lists
- Date as YYYY-WW
- LINKING CELLS
- If
- How do you get excel to automatically update Word?
- Extract Date from line of text
- Counting coloured cells
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.