View Full Version : Microsoft Excel Misc
- Making Print Gridlines appear as a default in Excel 2002
- Re: absolute cell references but more than "$D$3"
- Problem when switching datasource
- Age Calculation
- EXCEL-Counting unique values.
- Re: advancing row reference when pasting down
- Re: advancing row reference when pasting down
- Error message
- how to find several amounts in a list that add up to a certain total?
- File Name Footer
- Cell Font Color
- Re: Locking access to VB
- Conditional Max value
- Re: Where to get info on Excels ActiveX components
- I can't enter a date in a query
- strip characters out of a field
- Pie chart based on color
- Need to create blank computation column
- Database Queries/Date Formats
- Re: solution
- Listing VBA Module-Subroutine titles
- Re: Excel workbooks
- Re: Open a File, Close it and upon Reopen: Error
- differential equation
- Excel Internal Format
- period of time between 2 dates calculated automatically
- Excel
- Autodate!
- Position data in a cell
- OLK17, temporary internet files
- Re: Sorting by Dates
- Pivota table and excel session
- MSQuery
- watermark page numbers
- Excel saving multiple copies of file
- Excel97 - Odd behavior when printing/print preview...
- unhide only some columns
- Column headings
- how search EntireColumn to find value?
- number of characters
- **Copy paste question
- how get row & col # in VBA?
- Pivot row background color
- No word wrap?
- Setting non-contiguous print areas
- Pivot Tables
- Saving file tabs as seperate individual files
- Importing from Excel
- Re: Error Message
- Excel 97 tabs - changing fonts/colors
- If stmt - go to
- Re: Importing from Excel
- Find ALL field manipulation
- extra rows
- referencing cell range in different excel files
- UPDATE FROM WORKS TO EXCEL?
- Row Height
- Pivot Table formula evaluation Excel 2002 v 2000
- Re: Excel\access
- labels
- Converting a Quattro Pro 8 File to Excel 2002
- Help formatting a workbook into a webpage
- Payroll Question
- Sumif with two criteria
- Is there a way to display Simplified Fractions?
- Re: file name:# [Vsync]
- Re: trim space func for middle?
- displaying formulas
- Re: sorting dates
- Re: sorting dates
- Mode function for text
- trim space func for middle?
- possible to return to values from function?
- Newbie with VBA
- Re: trim space func for middle?
- 2002 Data Validation blank
- Sumproduct date dependant
- Date and time formatting etc
- Re: sorting dates
- Re: remove hyperlinks from an xls
- restoring a file
- Re: expiring a spreadsheet
- Conditionated visualization of an image
- Re: Excel's Randon Number Generation
- Excel minimizes
- Re: Counting instances of char within text
- Formula for skipping weekends when calculating a due date
- Shift Column cells to Row cells
- Re: Open a File, Close it and upon Reopen: Error
- Re: Pivot Tables
- Creating Link
- Re: finding duplicates in 2000
- combo box
- Re: microsoft access
- Re: sorting dates
- How can I convert an Excel file to an address book?
- Re: Excel\access
- Re: Formatting Cells: Feet, Inches & Fractions of an Inch
- Re: trim space func for middle?
- Re: trim space func for middle?
- Data Validation
- Worksheet Number Limitation
- Lost the excel menu list at top of worksheet
- Re: How to use cell value as Worksheet name in a formula
- Opening multiple xls files
- inserting texts in cell based on conditions
- Re: Row Count
- Range names in Macros
- restrict value entered into cell
- Re: What to Purchase
- Cell borders printing a different colour to on screen
- Arrow appears next to some cells
- Convert Excel to Word
- Re: <filename> could not be found
- Autofill using sheet names
- Re: Distance Tables in Excel
- Password protection with multiple users
- Formatting weirdness...
- Re: Row Count
- Help With Simple Combobox Programming
- Drop Down List Box and VB Coding
- Pasting data into Excel from Access
- Excell and Windows Explorer
- Counting months
- Excel conditional formatting
- Page format problems
- Re: Error opening spreadsheet
- Default file location
- AutoFilters - copy and paste from one spreadsheet to another
- How Should I Handle Large Amounts of Varying Text in Excel???
- can't unhide rows?
- Need help with some excel graphs
- Keeping a range constant when inserting rows
- Re: convert Number to Time
- Data Validation/ Drop Down Menus
- Row selection behaviour problem
- "automatic links to information in another..."
- Re: convert Number to Time
- Custom Number Format
- convert Number to Time
- Re: Database Query - Values not a number
- Trouble Starting Excel (new issue)
- print with back color
- Opening excel files
- Re: mailto hyperlinks
- Re: Spaces added when saved as comma delimited (hard carriage return?)
- How do I make "File", "Open", run automatically at Startup?
- Re: CSV with semicolon as delimiter
- excel 2002 opens 2 copies of file
- Excel delay before launching
- footer date
- Trouble editing comments
- sorting dates
- Maximum text, digit in cell
- Opening xls files in word
- column widths
- Tab name is grey! I want it black!
- Selecting cells
- Page Orientation - portrait to landscape problems
- Re: Custom formats - reserved letters?
- formulas not dragging
- Q: Is it possible to run Excel Documents as independent windows?
- Re: Importing Word label data
- excel vertical text help
- Zero Suppress in excel
- Re: Printing
- Re: getting data via com port
- Re: Counting in Excel
- Any way to "unsort"?
- Re: VBA help (very simple)
- Re: Distance Tables in Excel
- Paste Value.
- separating a list
- Re: VBA help (very simple)
- Batch convert XP files to 2000?
- Re: VBA help (very simple)
- Import EXCEL file into EXCEL document from web
- Reassign F Keys
- auto total word occurences in sheet
- filepath formula
- Statistics
- Pivot Table with external data source in Access
- replace function truncates text
- Re: Cell with Formula - hover type message
- Automatic cursor position?
- populating one work sheet with data from another
- Re: Cell with Formula - hover type message
- Finding a date period
- AutoFilter
- #N/A error in Vlookup
- Macro Code ... Next Sheet
- Date Formula
- Excel closure
- Column Limit in MS-Query
- Import data from Notepad to Excel
- Mobile Device with full Excel version
- Conditional formatting question
- Create a Drop Down Link to another sheet?
- Re: Hiding rows from the printer
- charts with date...
- autosum with Macros
- Select some rows, hide the rest?
- Excel
- Re: Error opening spreadsheet
- MOVING DOCUMENT IN EXCEL
- Subsets
- Pivot table hide zeros?
- opening programs
- Re: convert Number to Time
- Excel 2000 under XP
- Re: Rows repeating in footer
- Publish Workbook
- Renamed invalid sheet name
- Comments indicator position
- Using the TAB Key from Entry Field to Entry Field
- How do I pull a name out of a list - randomly?
- Timeout - Logout
- Basic Sumproduct question
- Keystroke Timeout - Logout
- Re: Database Query - Values not a number
- changing thickness of Excel row and column headers
- function tooltips
- COMPILE ERROR - WORD & EXCEL
- SUMIF Function not functioning properly
- excel autoloads
- SUMIF Function not working Horizontally
- Maintain links between Excel and word processor.
- Permanently Disable a Link
- Excel has generated error and will be closed by windows...
- Financial Mamager
- excel - rounding down times
- Excel.exe has generated error/Days calculation from date
- Formatting Cells in Excel 97
- Help with #DIV/O! ...need cell value to come up with answer
- Using combo boxes
- Re: Please help me with =minute function...
- Re: Entry numbers bugged in XL/2000/XP Professional - URGENT!!!
- Reducing/Limiting the size of an Excel 2002 Workbook
- VLOOKUP in VB code
- Custom Menu
- Re: convert to foxpro 2.6
- Re: Changing the default cell fill color
- Re: Changing the default cell fill color
- Re: Recording Lap times and sport competition results
- Re: convert to foxpro 2.6
- Re: Recording Lap times and sport competition results
- excel.exe application hang in Server 2003 event log
- Autosum when some cells are blank
- Security problem with controls in worksheet
- See Excel report with Internet Explorer
- Printing odd/even pages
- User Name
- Error when opening spreadsheet
- Re: automatically creating graphs monthly
- Re: Configure how excel opens external data files
- Web Browser Errors
- error initializing the VBA libraries (157).
- Worksheet does not display fullsize when published to html
- Multiple Instances of Excel 2000
- Excel Menus Greyed out
- Naming a Range in Excel
- scrolling
- Excel does not calc
- Handling pictures with VBA in a worksheet
- File locked for opening
- Command Button Text Resizes
- Adding a calculated ROW to a pivot table
- Wrong linked table is printed
- Date Formatting in Excel
- watermark
- Pasting External Data Problem
- Microsoft Query
- Estimating Savings When The Interest Rate Changes Based Upon Savings Amount
- Re: automatically creating graphs monthly
- MACROS & LINKS IN EXCEL XP
- Double If statement
- EXCEL - Headers/Footers
- EXCEL - Headers/Footers
- Re: vlookup problem
- Re: Data Validation / Font size
- Column Limit
- Re: Double If statement
- Re: Removing external links from a spreadsheet
- Re: File is opening automatically when starting Excel...WHY?
- Code Help
- Save As file name menu
- Duplicate Data
- Removing Unused Items from Pivot Table
- can't open *.dbf in Excel
- How to prevent opening email program
- Re: Workday Formula
- assistant has telescope even after executed search
- Page break settings not honored
- Loan Amortization
- Conditional Formatting
- Re: help with COUNTIF
- Print Workbook to a PDF
- Re: IF STatement
- Sharing a XL file
- UNHIDE all worksheets
- Format Dates to show quarter they occur in
- help!!!
- Re: help!!!
- Multiple Excel 97 Windows
- can't open References
- format currency in a Pivot Table
- Re: Hide Negatives
- missing tabs
- Re: Hide Negatives
- Top x values in a column - need VBA Help
- Show Zeros
- Is there a way to put "scanable" UPC Codes into an Excel Spreadsheet
- Using an equation to count non-duplicated items in column
- Re: IF STatement
- Re: need option explicit for each function?
- Re: vlookup problem
- Macros
- Re: Configure how excel opens external data files
- Re: best way to search .rtf file?
- Re: open a worksheet in VBA
- Re: excel problem "file missing or one of it libraries not found"
- recover an excel file not saved
- Re: Data Validation / Font size
- Error message when import to Excel
- Re: Removing Links
- Re: help with COUNTIF
- Macro sharing
- macro
- Page breaks
- Re: Formula Help
- Query
- Re: Missing data in .csv file
- "Send To Mail Recipient" doesn't show up anymore
- no capital /k/
- selecting non blank columns
- Copy & Paste
- irregular payment formula
- Subtotal Problem
- Formulas
- Excel Column showing numeric
- Please suugest a good Excel Book
- cell to change colour at given date - how to
- Testing an if statement and placing result in different cell
- Amount value into words?
- VLOOKUP WEAKNESS - help needed
- syntax error with INDIRECT fuction in line chart
- to import excel file to proe
- Sheet protection/cell editing
- Excel 97 Tools/Options
- Pivot table - problem with page field for more tables
- Window size
- I cannot enter data in my Excel 2000 spreadsheet
- Hiding PivotItems
- microsoft query add-in
- Excel doesn't recognize Trim() function
- Custom Functions and Excel Add-in.
- Re: Displaying Grid Lines in Excel 97
- Fx: INDIRECT to external workbook
- Re: Displaying Grid Lines in Excel 97
- Excel
- shortcut keys
- "Document not saved".
- Need help with an excel file
- How to deselect one cell when selecting multiple nonadjacent cells?
- Re: Formulas over multiple lines in the Formula Bar
- copy worksheet
- Command Menu
- Digital Signature
- application.ontime
- copying Word-Table to Excel
- Re: graph
- Re: Triple IF ??
- Toobar
- Excel Macro
- 123 conversion
- Conditional Formatting
- "Find" in a text box?
- CREATE A LAYOUT
- Creating multiple links to cells from within a single cell
- Re: How do I display row and column headings
- Re: how get name of current worksheet in macro?
- Reorient Pivot Table Data
- Re: How do I display row and column headings
- Re: Link
- counting number of special character #
- Re: Damn error in formlua!
- Visible Cell Fill Color
- Can't unprotect shared worksheet?
- Removing Watermarks
- Removing Watermarks in Excel
- Re: Damn error in formlua!
- updating master workbook
- Excel Menu Items Disappear
- Vert. Scroll Bar - MOVE
- Transferring Excel 97 spreadsheets to MS Works
- Re: Missing data in .csv file
- Wrong Default for 'Number of Copies' to print
- Differences in manual addition and Excel Addition
- copy worksheet
- Compiling data
- Secondary sheet linked to Primary sheet,-No change?
- record import limitation
- Remove hyperlinks in an entire column in excel
- Re: Excel
- Formating syntax
- Re: Damn error in formlua!
- Re: Excel
- Re: Merging troublesome spreadsheets
- Slow Start-up; "Installing Excel Feature"
- Re: List box and VBA coding for the date data entered
- IF Statement with Wildcard?
- IF Statement with Wildcard?
- Re: how get name of current worksheet in macro?
- Excel Opens then closes PERSONAL.xls
- Need a simple formula
- Re: Merging Data from Access to Excel
- copying into multiple cells
- Re: Can't merge all records in to Word
- cannot access a file
- Limit entry data
- WEEKNUM FUNCTION
- Excel reference
- Re: Running Excel as a batch job AND in the background
- Custom headers and footers
- Keyboard Tab beween worksheets?
- Opening Word Document
- multi level range name
- Re: Query for the below
- compile error
- Re: Date cells in EXCEL 2000
- Adding text to a cell already containg text
- Re: Macro to copy last entries
- Re: How do I display row and column headings
- delete names or rename
- how to customize zoom box view % for all new workbooks
- how to close a userform with a commandbutton
- Re: excel record number of times a cell is accessed
- how to display values in 3 cells into one cell
- Re: how start Word then do msgbox from Word?
- Nonlinear regression analysis
- Rounding down to fixed range formula?
- XP Excel
- Formula name
- Pivot Table Questions
- importing *.csv data into two columns
- Filter
- List Data+
- Tab order
- Help with assigning a macro to a commandbutton
- algorithm for combinations & permutations
- Cell Comment--Not!
- measuring unit in EXCEL
- protecting certain cells
- Spreadsheet to a Address directory
- Microsoft Excel user comment relocation
- How do I add the last 10 cells
- Delete a link to another non-existent workbook
- Re: type word document in Excel&use Excel Data
- Excel links cells
- Shortcut!
- Re: Formatting
- Re: No separate icons on taskbar
- Re: cell value
- Excel Message when opening
- Re: Algorithm for Permutations
- workbook in xp?
- calculation and save
- Extend the Column Numbers
- Excel Links
- message - file format is not valid
- Re: text overflows boundary of a cell
- Re: text overflows boundary of a cell
- copy & paste formula
- close, restore and minimize icons disapear
- Re: copy & paste formula
- Re: Permanently copying data from one worksheet to another
- unique data
- Re: Date & Month formulas
- Re: "Save As" function greyed out permanently after opening a readonlydocument
- Complicated LOOKUP Question
- Cannot open excel file
- Days and dates in Excel
- Yen currency symbol
- Auto Fill Options
- Re: Countif in VBA
- Re: Countif in VBA
- Re: Code
- max text\number
- Picture
- Wrong format of Excel 97 file on Excel 2000
- Conditional formating
- Excel Solver
- Help sort this out
- find adress
- Re: 'Compile error in hidden module: AutoExec'
- problem in excel 97 (running in windows-xp)
- Calculating averages when some cells are blank?
- Conditional Format
- Re: Protection of worksheets
- q Emailing Excel Sheet With Outlook
- I have a delay in opening Excel wrokbooks
- Re: hiding typed password
- Can make my coloms hidden
- Increasing the size of a drop down list
- Installing Excel Table within a web page
- Re: Newbie Macro Help
- Re: two data summary fields in pivot table and then dividing them to show % on chart
- Re: Saving files in Excel 97
- Re: Newbie Macro Help
- How To Scramble The Variables in a module?
- Re: Advanced filters and sorting
- Excel Macro
- Lookup Range
- column headers
- Re: Automatic printing of Excel file on File Opening
- FileSearch dislikes Zip-files
- Unclear Message
- Changing formula in multiple cells or range simultaneously
- Extract date from text range
- Macro absolute to relative tool bar problem
- MAX combination
- Excel 2000 issue.
- How to force entry in cell before saving.
- Linking numerical values to a text drop down box
- Calculating averages
- Re: Cannot set Rowsource for a Listbox
- Where are macros stored?
- mail merge
- Re: Formatting text in Data Validation Input Message
- Re: Particular cell as file save name?
- adding on a fiscal basis.
- Button to duplicate the column
- Background on Sheets
- EXCEL executed an invalid instruction in module VBE6.DLL
- Comma Style Formatting from Format Toolbar
- Re: Newbie Macro Help
- Unable to set FormulaArray property in VBA
- automatically insert current date
- Autofit problem with merged cells
- Deleted excel file
- Modifying and deleting lists
- Fixed Column Width
- Autofill Dates Through Worksheets?
- Works 3.0 to Excel v.X mac
- Error Message
- linking cell formats to other worksheets
- Querying
- Insert File Source Path in Workbook
- Default directory after sending email
- Converting text into time
- why only few data but filesize is 13Mbytes ?
- Re: Cut and paste columns from different sheets
- Large files & charting data
- lock up
- help
- merge two fields with a hypen between fields
- I'm lookink for an Excel function
- UNSHARE WORKSHEET
- PRINT USING BUILT-IN PRINTER FONT ???
- Unable to Hide Columns
- Inserted picture from file must be printed over/behind footer
- Drop down calender on a User Form?
- Cannot Copy Some Worksheet Tabs
- .csv format
- Sum a certain cell on every sheet, including newly added sheets?.
- List box
- printing problem
- C.F.
- Merge Docs in Excell
- Pivot Table Question
- Saving a chart as a picture.
- Pivot Table Question
- Protect Sheet - Lost Password
- Macro Message
- New Works w/o Excel
- Default mail client
- Re: Simple question
- The Pepsi Challenge - How Good are You?
- The Picture is too large and will be truncated
- conversion
- text not printing
- Condtional operators & moving the results of formulas
- copy several items & paste several items?
- Excel VB: search for files
- Range with formulas prints blank pages
- Re: range selection
- pivot table trouble (tricky)
- can't scroll left to right
- basic settings
- Database Query
- Multiple worksheets in workbook
- Re: Files / Save and File / Save As Greyed out
- Re: XL formatting limitations
- Mouse wheel with listbox
- Re: Limiting Dates in Pivot Table
- Re: buttons on toolbar not functioning
- Formatting query
- Re: How to link a worksheet name to a worksheet cell
- 2 Excel questions
- Making changes to all worksheets within a workbook at the same time
- inserting an excel table into word document
- Merge changes from routing at once
- Emailing Excel worksheet
- MS Excel Default Column Width
- Re: Print Entire Workbook
- Re: Print Entire Workbook
- Re: Print Entire Workbook
- Re: New fonts error message
- Using Excel on WEB
- Vlookup
- Pivot table export data to table format
- Excel cell formatting
- hours:minutes ?
- IF Blank
- Excel XP 2002
- Creating array (no VBA) that is NxN with '1's top right to bottom left, rest zero
- Re: List box and date function
- Can I install excel on PC using windows XP Home version?
- text dropped when printing
- Copy Last 13 items
- Sums in my list
- HOW do I auto fill the hours and minutes between 8:00 and 3:30?
- Lose columns when copying to Word
- separate names at comma
- Re: Print Entire Workbook
- Unable to open files
- Static Variable
- Show a list of address
- Sheet tabs
- Excel sheet is missing in application
- Saving Files in Excel
- Could someone give me a formula or funtion for the following
- Macro not working between versions
- Calculating amount of cells containing data...
- Re: Microsoft Works and Excell
- eurocurrency
- Collapsable areas
- Saving from Excel to text
- functions
- Re: using trim with ranges
- Publish as Webpage Size Problem
- Pivot Chart & Text(A1,"Mmm YY")
- double sided printing
- incrementation of a value depending on another value
- Re: 'The file may have been changed...' error
- Excel 97 - Template Wizard - Transferring Data
- formating cell for indian number system
- Calender
- Excel
- Re: Unprotect Sheet Password Lost
- Re: Calculate End of Week
- Re: time
- Excel 2000 - Sorting Dates
- Printing Sheets to Multiple Destinations
- Conditional appearance of checkbox in Excel
- entering stuff to multiple sheets
- Mortgage Calculation Spreadsheet
- Workbook/Worksheet
- Re: Moving rows...
- Gema
- Macro, Perhaps?
- Re: Moving rows...
- Text Stops Wrapping
- Opening Notepad
- Open Workbooks
- Re: Macro Warning -- but there is no macro!
- Re: WHAT DOES THIS MEAN
- Re: "hidden macro"?
- Moving rows...
- Macro Warning -- but there is no macro!
- Excel PC vs. Mac issue
- Author of Excel workbook appear in footer
- display ratios as written in web query
- Re: MONTH function
- Re: MONTH function
- Excel importing
- LONG delays when switching printers
- input masks
- Cut, Copy, Paste in EXCEL VERY SLOW
- Re: hide message window
- Notepad and Excel
- How to rotate text added to a Autoshape
- printing problem..not sure if it's an excel problem or a printer issue?
- Runtime Error with Excel VB Sub
- converting excel files to excel 2002
- Re: Excel availability
- Re: "hidden macro"?
- importing from other software reports
- Nested IF
- Re: "hidden macro"?
- "to many different formats"
- Re: hide message window
- Re: Default for VBA's export file
- Excel
- Excel 2000 Error Message
- Row heights when sorting
- Highlighting hidden objects on a sheet?
- Re: Animated GIFs
- Excel to XML conversion in Excel 2003
- Re: Animated GIFs
- Limitation in Excel
- Re: Excel availability
- exporting in csv format
- Excel 97 - adding a column of hours
- VBA Macro
- Formatting information
- Order form Template
- works spreadsheet to excel - opening
- Workbook Not Shared, Still Opens?
- Excel Formatting
- Auto Refresh on Opening
- Re: Can't open file on floppy
- CSV file import into worksheets
- Macro Compatibility
- Change Page Break
- Using older flopies
- Time
- help--excel macro
- Converting number to text
- List Box Set Up
- Re: Time
- Excel 97 Error Message: Normal.dot file format not valid
- lost worksheet
- I need a formula
- Re: Microsoft 97 - Opening Several Spreadsheets
- Saved files in officeXP
- XP macro fails in 2000
- Detect & Repair Question Please
- Re: Excel?
- Conditional Formatting
- excel template
- Page Brak Not Saving
- Re: Excel?
- Re: Excel?
- Automatically pulling sheet names
- Countif
- Embedded Links
- finding a sum from a list
- IF Statements
- A Challenging Formula
- disable automatic update of references
- text formulas?
- Significant Figures
- Import of external data
- Lotus.123 import
- Tab Organization
- Re: Workbook thinks there are links to another workbook
- conditional formatting of row based on cell
- Re: Workbook thinks there are links to another workbook
- Autoshapes
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.