View Full Version : Microsoft Excel Misc
- Changing references in graphs without using the Source Data option
- counting in a range
- change in-cell list with IF instruction
- Income and expenditure Excel spreadsheet
- saving recipient and subject lines when sending an excel sheet
- Excel File Size
- Excel Window
- how to assign a code to a text
- MS Excel Very Slow to Open and Save.
- traverse spreadsheet
- Not printing cells
- How to create a ytd formula on an item in a pivot table?
- updating external references
- Can I free up memory in Excel after creating Pivot caches?
- Obtaining data from text files
- Functions
- Where do I stand legally?
- Formulae inserting themselves in a sequence
- Formula help
- Reading and displaying part of a formula
- Excel_ changing M x M data to single column
- Correct email address for question below!
- Find and Paste (re-stated)
- Incorrect result in formula
- Pivot Table basics
- Hiding formulas and contents of cells
- Add a row using a macro
- Excel Startup error
- Kick off a Macro upon leaving a cell?
- Create a macro
- Spreadsheet Cutoff
- defining a range in VBA
- shifting data without inserting new cell
- List every object which appears once
- #VALUE! instead of Boolean value
- File name with spaces Excel 97 & XP
- Format a number to be a date
- Credit Card type numbers
- Disappearing Excel Data
- Countif
- Multiple Selections from a Drop-Down Menu
- Re: Excel macros
- Date Calculation
- Sharing an Excel Report on Network
- determining won-loss record
- Problem with Excel pie charts- size of pie slices wrong
- Unhiding
- Sales force tracking sheet sorting problem.
- Pivot Table Record Limit?
- Deleting Excel file
- ComboBoxes and Tab Stops
- Working with Columns
- Protecting a validated list cell
- Format Comments in Excel
- Concerning Selection colour options
- Calculation mode...
- Help with Concatenating Cells
- combinations macro
- Weighted Average in Pivot Table
- Static Cell Reference
- saving to network drive
- closing a shared file when someone else has it open.
- VLOOKUP Trouble....
- Compare and output unique
- Cut/Paste from Navision to Excel
- Closing Document
- How to Lock Cell?
- Paste w/o Hidden Cells
- Re: Moving information with the OFFSET function
- dynamic printing and totals
- can't record Excel XP macros
- File remains locked after closing
- Making a drop down menu
- Using Minutes and Hours
- Find + FindNext
- Excel Opens slowly when connected to Network
- strange behavior errorhandling
- help
- Protecting selected Worksheets at Once
- macro pause until mouse click
- How to count formatted cells?
- Random integers
- Re: Selecting range depending where active cell is
- Microsoft Access Anyone ?
- Excel 2002 slow opening from "Look in"
- Do......Loop
- Check box and SelectionChange
- Pivot Table Avg only when >0.000?
- Re: Selecting range depending where active cell is
- Excel Printing in colour not black and white
- Excel Macros
- format after entry
- DANGEROUS Export To Excel problem from IE 6.X
- web page/password protect
- Stock Control
- Changing Date Format
- Default settings for the comments box
- Logic behing Random numbers
- Tagging duplicate entries
- how do you lock individual cells?
- statements not functioning on other LAN computers
- Help combining ISERROR with IF statements
- auto calculate
- SumProduct w/ 'or'
- Re: Need help with a Data Comparison formula
- Macro won't work
- Re: Macro won't work
- email from excel
- preselected opening page in an excel spreadsheet
- Analysis Tool Pak
- Excel- Total no of days and hours calculation
- Excel- Total no of days and hours calculation
- Re: Unicode operations - find / replace
- Help
- Filling in empty cells
- Search Item dialogue box irritant
- Searching All Excel VBA Files for macros
- Chart data
- Using a macro to change a macro
- Tranfering data from the column to text file
- Tranfering data from the column to text file .
- i have a comma problem
- custom view
- text lines in a cell
- Counting filled cells
- Removing Links
- What is the best way to make an archive of data
- Get External Data across columns
- Change Time format into Minutes
- My date entries are replaced by pound signs
- Cell to contain the format of the text entered??
- Pivot Table Grouping Problem
- splitting cells
- Exporting Comments
- CLIPBOARD PROBLEMS
- Help! Word, Excel 'Not Responding'
- Reserved Name
- Excel oddity
- Formula
- Colours and Colors
- Formula
- Single doc interface
- File locked for editing
- need help
- Convert *.123 files
- percentage
- Rounding Fractions
- excel worksheets
- Update Problem with Excel File in Intranet
- FIND and PASTE
- Name Manager 3.0 released (FREE)
- Shortcut key to resize all columns according to data width
- Displaying Data
- Page setup
- Excel views
- Data duplication
- Dispalying File name and path in a footer
- New Challange
- adding a count
- Excel Migration from 97
- Filtered Data
- Re: Formulas
- Re: correcting a link
- How can I make the gridlines on my spread sheet bolder?
- Printform options/parameters?
- Search Box help??
- Auto Correct in Office 2000
- Insert comment in a cell
- Dates
- Excel will not print
- Year-to-date formula?
- time table examples
- Excel 97 gridlines and borders
- Re: sum formula
- two monitors w/ excel xp
- Adding same cell from 30 worksheets in same workbook
- Formula Reference and VBA
- sorting dates
- RE: Excel and Network Problem
- Pivot table default settings ?
- Re: Countif ..... if in a list
- Re: Countif ..... if in a list
- text within cell seen as ####
- filling in series, in groups of 3 ?
- Header and Footer Change Page Orientation
- Converting tables from Word to Excel
- Need Formula for Extraction of Middle Initial or Name
- Countif..NOW()
- cannot open an Excel file
- Red Asterisk at line 500 inside an EXCEL Sheet
- Need formula to default to a certain value if the cell is left blank
- Importing address book (excel file) into Outlook
- How to - query against a data table
- Re: sum formula
- RE: links
- Absolute Reference Question for VBA
- Linked Data
- separating address elements in one cell
- Excel 2002 Bug? Autoshow Limits at 255
- No Highlighted Areas when Printing
- Re: hiding formulas
- Excel Get Data Problem
- Excel Reference Problem - Pulling data from all worksheets
- Automatic formatting when pasting or importing data
- Select multiple opjects (not all) to delete
- Re: Rounding
- Complex pivot table - 13 row fields
- Formula's stop working
- i need help
- Pivot Table Sums
- MS Office 2000 SP3
- Average only if there is data
- Re: landscape printing
- Excel Cell Limit 255 characters
- Delimiters more than 1 character
- microsoft word
- Re: links
- Re: hiding formulas
- Seperating Data
- filter mode status
- Corrupt File?
- how do i rank based on other rankings?
- Read Only
- Re: Average of every other cell if....
- Copy the text data from the column of an excel sheet into a text file .
- disapearing custom tool bar
- Row height
- EXCEL 2000 and WORD 2000 Pasted table
- What Else Can I Do?
- Re: hiding formulas
- Button's Text Value
- loading addin
- two sheets
- Excel advertising its results
- Excel, please stay alive
- Users updating a spreadsheet..
- Autofilter weird behavior
- Importing a form in Excel
- excel forms
- IF(OR with an Array formula
- Changing a Cell Value in Multiple Sheets
- Understanding #VALUE!
- Excel 2003 (VBA) fails to delete selected rows
- Completing the last post...
- Linking worksheets
- Making Excel Calender Smart
- Conditional formatting
- Copy worksheet name to/from cell
- Data Validation widths...
- help!
- variable link
- newsgroup settings
- Excel as Wallpaper
- Looking for People to Beta Test a New Excel Portal
- Create multiple rows of tabs
- How i count cells that includes a specific text?
- Saving files
- Re: connecting worksheets
- Re: Find Last Cell For A Named Range
- Re: How Do I Reference All Worksheets?
- Re: How Do I Reference All Worksheets?
- Re: Find Last Cell For A Named Range
- How to save excel file to fixed-length format
- excel vlookup help
- removing elements of one workbook from another workbook
- How to split a VBA formula? (ERROR 13)
- Re: Getting rid of NA
- EXCEL and a Pasted Word Table
- A new form macro
- format
- Loop - omissions
- Re: Autofilling Series from A-Z...AA-AZ...
- Sort order
- Templates
- Custome Format
- Can't remove a macro!
- Excel Interactive - HTML
- Book - Microsoft Office Excel 2003: Inside Out
- How To Choose Every Third Row Of A Table
- Newsgroup etiquette
- Column Apha Letters
- how to make forms combo box jump to to of list
- Validating telephone numbers
- CSV - what if values have commas and quotes
- Excel 2002 converts date to text on manual edit in cell
- excel column letter and row numbers are italic
- How to make text entered in a cell on a sheet, appear the same on another sheet
- Re: Auto fill numbers
- What's the solution to this problem?
- virus scan
- Saving files with names entered via InputBox
- Macro for closing files only if they are open
- Plotting a 6-D graph using Excel!?
- Excel 2003 pivot table
- data in a cell
- Subtotals
- Hlookup in MS Access?
- recording macros
- Display Only Last 4 Characters If A Cell
- Opening xls downloads
- How Do You Call Several Named Ranges From A Named Range
- Short-cuts
- Inaccurate Calculations in Excel
- SendMail2.1.xl wants to save every sheet I try to send out...
- copying data
- Data Form
- Pivot Table
- resize text
- formula copying without confirming possible?
- Line graph straightens itself
- RE: Printing embedded jpeg images in Office 2003
- Select 1st ListBox, return data from 2nd
- Top 10 from a list ....??
- Excel 2000
- Merging Worksheets
- data entry range
- Setting back the autofilter to 'all'
- File....
- Page Setup Changes?
- Convert Lat-Lon to UTM
- EuroValue toolbar
- Excel Database setup- breaking the rules
- Merge Formats
- Auto date correction
- Re: Formula cell on toolbar
- autosave
- Cell format
- Running Log editing -- can't find the macros
- SUMIF
- Re: Date and Time in Spreadsheet Name
- Referencing a Column within a Named Range
- Values only
- Excel-form -> help!
- Re: Cell Function & Formatting
- number layout
- Problems w/ SUMPRODUCT string
- Re: Cell Function & Formatting
- Formula relative to a List in Excel 2003
- Using the ~ character in Excel
- Excel - SHARE WORKBOOK issue
- Returning max number of rows
- Multiple Workbooks opening in same excel window
- Minute/Second Format
- Re: Modifying a Protected Cell in a Macro?
- Re: display ASCII characters
- Pivot Table and Pivot Table Reports
- Data import of negative numbers shown as text
- Search options
- delete certain text from a cell
- Converting Quattro Pro 10 files to Excel 2002
- Excel - Absolute Reference
- Postal Bar Codes in Mail Merge
- Formating cells
- i can't get date serial # to show as date in formula
- Linked Files
- can I format a pivot table to change minutes to hours?
- Re: Macros
- RE: Cannot empty the Clipboard
- .csv files and Scientific number display
- excel cell help
- excel screen goes nuts via pcanywhere
- Vlookup
- Formatting cloumn ???
- AVERAGE using multiple criteria
- data capture
- IF Formula
- PRINTING MULTIPLE VIEWS
- Formatting in Excel
- Chart Axis - Want to declare maximum for text
- Chart Axis - Want to declare maximum for text
- Column Width in centimetres instead of pixels?
- VBA to FillDown with Offset() from ActiveCell
- Incremental Change on the Scroll Bar
- Re: IF Formula
- Combo Box
- Problem with copying and pasting dates
- I need help with Removing hyperlinks!
- Error in hidden module - AutoExecNow
- loop
- Removing Subtotals in 2002 (XP)
- Excel File Size Limitation
- Pivot Table
- cells do not print
- Lookup - so why has it stopped working.
- Complicated time question
- Re: ascii characters
- Re: XP home
- Accessing the formula (NOT the result)
- Access Data Source and Formula References
- show page breaks does not remain checked
- Re: Looking up a Graphic in Excel
- passing formulas
- Delete Graphic
- referenced cells displayed 0 when it shouldn't display anything
- Weird Pivot Table / Analysis Services Issue
- Format number in radians
- multi choice list /combo
- Excel clients list and e-mail transfer to outlook address book
- Import ROI or actuate file into excel
- Array Formulas
- Excel and the web
- Sequence Number
- Re: matching two lists of unequal size
- Date diffrence from + to -
- Problems with pasting charts
- Validating data
- Help please!! Excel exam tests & self assessments
- Excel.exe error - HELP!!
- How to sort the 6 highest numbers
- Can Solver work on different sheets!?!?!
- Track changes - history report
- Combo box and protected worksheet
- last cell stays the same
- how to remove password for excel file
- VBA "Error 424" Object Needed
- combo box results print from command button
- Excel Highlighting Gone Wild!
- removal of page breaks
- tracking business time elapsed
- Transfer from Actuate to Excel
- Merge Workbooks
- Copying Graphs into another spreadsheet
- Cells appear fine in Print Preview but are cut off during Print
- Pivot Tables on the Web
- Free tests/exam practise?
- Pivot Table - Calculated Field
- Headings
- Excel 2000
- Multiple icons in taskbar
- Text Truncates
- VBA Code required to Force Formatting of a worksheet.
- Excel Close button
- Puzzled
- fill colors
- saved
- Convert Text to Numbers Problem
- Combine Workbook with invoice?
- exclude cells with string for calculation?
- Importing data from Word 97 to Excel 97
- Cell Problem
- Solver
- rows & columns in pivot
- Excel 2002 dropping gridlines and window panes when saved as a work space
- shared file
- Backward read compatibility?
- Problem with Excel chart
- User needs to track entries in cells
- Excel objects via IE
- make 1 cell smaller than the column width
- Mail Merge with Word
- multiple windows
- Number to Text
- Counting
- MACRO-Excel
- max number of items
- HELP - VBA
- Fraction formats
- Repeat Operation in Excel Macro
- formula
- Need a Name value with Max value
- how to return a value with two conditions.
- Help with formula
- multiple logical tests
- Tracing dependents
- Cell Format - Greenbar Fill Pattern
- Re: Calcualted field returning zero value
- Charting employee ratings
- Hide/Unhide based on Combo Box
- Concatenate problem with date
- Excluding values in hidden cells
- Auto fill - how to increment by an interval?
- View cell references
- Algebra formulas in Excel
- DSUM Limitations
- Excel Charts
- How do I replace specific values in a large file? (Besides using CTRL+F)
- Status Bar shows Calculate
- inserting a cell reference into a sentence?
- Excel Worksheet Document Control
- Retreiving data from columns
- Using a formula to copy a value of a cell in another column
- Re: How to have vba automatically tab to next field when on web page
- Selecting a Time in a cell w/out inputting the data
- How to show images + details?
- How to show current user name
- Creating a line in a combined graph
- Creating Labels in Excel
- Opening 2 workbooks simultaneously with Macros
- Want numbers not sums in pivot
- Pay Stubs
- Formula to count length of text in a column
- control combo box - type a letter - goes to that name
- how to sort so 1.10 comes after 1.9
- batting averages
- Formula won't work
- Taskbar for all users
- invoicing from drop down menus
- Macro Delete Sheet w/no "ok" box?
- Sum formula does not work - pls help me
- EXCEL 2000 - Send to mail recipient as attachment
- finding the last filled cell
- Access a named cell in a closed workbook
- Multiple simple regressions procedure?
- favourite excel feature / shortcut
- Validation drop downs dont appear
- Trouble linking data source to pivot table
- Help in resoloving scenario
- close excel after viewing file in Iexplorer
- File sharing
- workbook opening
- Speed typing single character per cell
- How to Show shortcut keys in toolbar buttons ScreenTips?
- template wizard with data tracking
- look at and select
- reformating merged cells in a protected sheet
- Column headers have changed from letters to numbers
- Convert Date
- sorting rows based on value
- Format painter mouse icon missing
- powerpoint
- Color Index on Multiple Rows
- Excel 2000- Can't sever link between 2 books
- Hyperlink
- Convert column of numbers to text.
- Unable to print in lanscape
- Hide text in cell
- Data Access Security - Refresh Alert Settings
- LOTUS 123 "\-" equivalent in EXCEL
- Transparent White Gif Disappears
- insert new rows upon refreshing pivot table report
- SUMPRODUCT question
- Re: can you print or copy "find" results
- Numbers on top of columns
- formatting color of destination cells
- EXCEL2000 - Duplicate Records Elimination - two column combined for uniqueness
- Pivot table
- "Find" on startup
- Invoice Template & Template Wizard
- Personal Macro Workbook
- Disabling a button based on data in a cell?
- Multiple criteria problems using COUNT
- Counting data bytes in cell
- How do I insert a personal signature into an excel document?
- Calculating Hours for Overlapping Time/Date Fields
- Watermarks
- Re: Autocorrect File
- Re: Autocorrect file
- Copy -Paste Into E-Mail
- Recent Microsoft Excel Updates - March 24, 2004
- Project unviewable
- Excel Database Query, minimum # of lines?? PLEASE HELP!
- Re: Entering Symbols
- Re: Entering Symbols
- Re: Entering Symbols
- Use AutoFilter with Formatted Dates
- Re: Multiple Regression
- RE: Changing Row/Cell Height
- Data Region & Auto Complete
- Dates prior to 01-Jan-1900
- Conditional Formatting
- open on startup
- Preserve column width formatting
- Automatic Cell Sizing
- Can I run a MS Project macro from Excel?
- Macro executes faster after save...why?
- Formatted cells do not sort...
- Entering multiple ranges in a countif formula
- RE: Multiple Regression
- viewing the code of a spreadsheet
- Excell Spreadsheet function
- Comments & Rollover
- Macro doesn't work in new workbook
- Autofilter freezes
- multiple if-then results
- Excel to create work schedules?
- Pivot Table
- Exit Excel
- Re: Changing Row/Cell Height
- ChecK Boxes
- format
- Automate Import of Flat File into Excel
- helpfile in Excell
- Re: Want Header to print on first page only
- Re: Want Header to print on first page only
- Removing data from a cell
- Q: Creating a hyperlink to a worksheet?
- 3 multi column columns
- four week average
- Re: Dbl Click only opens the program, not the workbook
- List Maximum Values
- Workbook performing slow
- Re: Autocorrect File
- Pictures print out wrong
- Re: Autocorrect File
- Borders with curved corners
- Can A Macro "Add" Content To A Cell Without Replacing The Original Content?
- Navigating Protected Cells in 2000 and 2002 vs 1997
- automatically changing text case
- Formula Help - Blank cell unless!
- Help Merging Identical rows within a large set of data
- netdde for excel 2000 on w2k
- Pivot table-percent of column
- replace functions
- Activate Visible Sheet only?
- Excel 2003 Can't get rid of Task Pane
- Macro to hide many blank columns at once?
- Days in Month Question
- Please Help!
- Printer doesn't print
- merging worksheets
- COPY-PASTE INTO E-MAIL
- Advertising Budget Worksheet
- Formulas in the same column
- Date entry in networked computers
- did a cell had a limited coding...
- Printing
- Toggling between French and English
- Pivot Table Inner Field
- Showing changes on-screen like in Word
- Excel problem with Match
- Macro Problems
- How can I add a macro that is always available?
- Month Function
- Cannot paste
- Hiding my formulas
- IE using excel (minimising in error)
- trying to simplify an Array formula
- Re: Entering Symbols
- Benefits of upgrading to Excel2003
- File Sizes with Pivot Tables/Charts
- Buttons are gone that point to my macros
- Elbow effect
- cyphering-decypering
- Check cell filled before close
- Pivot Table "Refresh" ... How?
- How can I get the Negative Numbers dispalyed in brackets in Excel 2003
- Re: Percentages
- Re: Percentages
- ? Object, Method, Property to evaluate cell contents
- RE: Percentages
- Convert PDF to Excel
- How can I get a Pivot Table to refresh after a few minutes
- "Old" data in pivot tables
- How to make conditional multiplying formulas?
- Excell to Word format
- OOps enter percentage error message
- Macro
- Cell Colors
- array formula
- Excel worksheet saved as PYDAT:3
- Conditional Formatting by Date
- Need macro to work when new rows are inserted
- Add A Command Button To The Menu Bar
- SUMIF to average on multiple criteria
- Cannot remove Menu items
- maximum number of characters
- Print Formulas
- Cell default
- How much is too much text
- Date format
- Need to replace a portion of a formula in a range of cells
- Excel VBA - Simplify a complex Row
- Auto Filter gets stuck
- Selection Error
- "Cannot find the file" Problems with Excel 97.
- how do you convert a word document to an excel document.
- Can't Find Data > XML menu item?
- Excel 2002
- Re: Entering Symbols
- How do i remove linked workbooks from my current workbook
- Re: Anyone know how to hide paste icon in Excel 2002?
- Re: COUNTING Y AND N FIELDS IN EXCEL
- all about excel
- Excel Displays Formulas Instead of Formula Results
- Re: need different application.wait() command
- .tmp files not being deleted when closing an Excel file
- exporting to word
- Button On Userform To Activate Woorksheet
- Disable text import error message "This file is not in a Recognizable Format"
- Help! How do you merge two Excel spreadsheets?
- spreadsheet question
- Page Bordering In Excel?
- Keep data validation in cell even if I remove contents.
- Calculating Future Value
- Formula - count certain dates in a column
- auto formatting csv when loading/open
- Printing multiple print areas on one page
- Formulas are not updating their values
- Re:Formulas
- Import table from website to excel.
- paste after each row?
- formatting database output to excel by deleting duplicates
- Re: Formulas
- How do I create macros which will stay on the workbook it is created in?
- Can I lock rows together so they sort as one row or "group"?
- Weird Behaviour Of Text Boxes On Spreadsheet
- problem creating string using <> to exclude
- Find/replace
- formatting data for compatibility
- Text Size in Data Validation
- Thank you Gord Dibben and Jan Karel Pieterse
- How to find next record..
- thanks! that rocks
- Column missing in pdf file conversion
- How do you copy from Excel to MSPublisher?
- I know this isn't the place, but I need help with PP and I have nowhere else to turn
- Excel Pointer
- Excel Template Wizard for XP does work for Excel 2003
- Copy Tab Errors
- Control Combobox Linked Cell vs Forms Combobox Linked Cell
- formulas
- Page Numbering for Printing Multiple Worksheets
- Edit directly in cell
- Printing a form
- row highlighting
- Sequential Numbering
- Days in Month Question
- Re: Printing differences
- compressed file
- Re: Compare workbooks and return results
- Re: Compare workbooks and return results
- Print Tag of Autofilter?
- Re: Excluding duplicate values in a Pivot Table
- Can I insert "LINKS" using VLookup?
- VB Question
- Changing Cell colors with conditions
- filters
- Excel 2003 - Prompt for Enable Auto Refresh Every Time
- wrap text problem
- Date Arithmetic Q
- Size of text in formula bar
- Macro Security sets itself back to medium ?
- Sorting Large Numbers of Rows, Hide Blanks
- VLOOKUP "Contains text"
- help me
- I feel sure there's a SUMPRODUCT formula in this somewhere..
- Link to Sage line 50
- Search replace Excel XP
- Format problem?
- Tricky Countif
- Dynamic cell referencing
- Making a calculation/formula expire after set time
- Why 18:10 do not equal 18:10?
- Load Icon
- Complicated counting
- Copying worksheet
- Pivo table Field drop-down arrow
- CSV file importing?
- Import data table to spreadsheet
- Random row additions
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.