View Full Version : Microsoft Excel Misc
- Re: FInd the unknow
- Re: FInd the unknow
- formula problem
- Re: How to draw neat spiral?
- Re: formula question for range of cells
- Excel table macro
- moving to cell Y if cell X has value Z.
- Upcoming Support Webcasts
- Problems generating an html link based on worksheet values
- Problems generating an html link based on worksheet values - SOLN
- missing rows
- Re: where is FAQ?
- Re: where is FAQ?
- Re: where is FAQ?
- Re: where is FAQ?
- odc data source
- Writing data to Specific Cells???
- Re: where is FAQ?
- Change Format from Minutes(Time) to Number
- Excel, HTML-Export and Images
- Question: OPEN return status
- Question: Macro overloading, passing variable number of arguments
- Question: Cell formula or macro to write result of one cell to another cell
- Quit Excel problem
- Changing columns to rows
- Re: Check mark boxes in Excel 2002
- Re: it is not work
- Error when summing columns
- Re: WB slow to open 100+ check boxes
- Re: it is not work
- Re: Adding columns and deleting empty rows?
- Re: Error when summing columns
- Re: Functions question
- Re: it is not work
- Re: Date Range: Ignore Old Days
- Re: Date Range: Ignore Old Days
- Re: puzzled
- Re: Functions question
- Re: Error in formula with Rounding
- Re: Fonts in Excel 2000
- Re: Fonts in Excel 2000
- Re: Macro to update a macro
- Re: puzzled
- Re: wrong year
- Re: Need Excel Tips
- Problem savin in a Network Drive
- Excel File will dissapear from the screen when the restore window is clicked
- Re: Finding text in a cell, then selecting cells below until a blank cell is found.
- Re: puzzled
- Re: Excel rows space
- need opposite of MODE function in Excel
- Split Cells
- Control of comments location when converted to HTML
- Hiding "FALSE" values
- Data Sort & Maintain Link Positions
- select and drag: sequencing numbers doesn't work
- Re: recently used file list
- Re: red formula
- Re: Omit data point in chart
- Re: Visual Basic for Pocket Excel
- Re: Fonts in Excel 2000
- Re: Excel dates
- Re: adding confidence interval on regression line?
- Trouble Sorting in Excel
- Rounding
- RE: Lotus 1-2-3 to Excel
- macro for selecting last 3 sheets in a workbook
- Opening a file off a disk
- Converter for Excel 2002
- Re: Rounding up to next 50
- Re: Tab Order Problem
- Re: Rounding up to next 50
- Names in Workbook
- automatic data transfer
- Re: Proper function
- 8192 rows limit when opening wk1 files ?
- Re: Proper function
- Track Changes in Excel 2000
- Re: Split Cells
- Re: select and drag: sequencing numbers doesn't work
- Re: Acrobat
- Re: Custom Formatting of Data
- Re: Printing in excel
- Re: Breaking WB Links in Excel 97
- Re: Link Workbook by Named Range
- system variable representing object or subroutine name?
- Re: Link Workbook by Named Range
- Re: Proper function
- Re: macro for assigning name range
- Re: macro for assigning name range
- Re: Excel wont' prompt for password
- modifying the Enter key function
- RE: Excel File Opening Problem
- Save as authentication?
- Re: Goto Blank Cell returns an area? (Causes Access problems)
- converting pdf to excel
- =IF(L8+1>TODAY(),"",L8+1) to skip weekends and holiday
- Excel 2000 file lost from screen
- Re: Totals of different catagories
- Large text in Excel
- Random Number Generation Question...
- Re: Comment boxes
- Sort Tabs
- Populating a ComboBox from VBA with 2 columns
- where is the bottom of my worksheet?
- Re: Pivot Table Field
- To Sort WorksheetTabs
- Re: date conversion from m/d/yyyy to yyyymmdd
- Re: date conversion from m/d/yyyy to yyyymmdd
- Concatenating Date Field with Text Field
- Re: date conversion from m/d/yyyy to yyyymmdd
- Re: Open Excel File problem
- Analysis ToolPak - Excel 97 - doesn't work
- Universal templates?
- Re: Problem with Macro's
- Re: Fonts in Excel 2000
- Re: Pivot Tables showing "old" data
- Hour counter
- Re: Excel Will Not Save
- is it possible to auto rename worksheets
- Re: puzzled
- Re: Currency Style Button on Formatting Toolbar
- Function question
- More than 255 Charaters
- Re: Excel 2000 Files Menu
- Special characters in excel
- Re: Comment boxes
- Force complete recalculation?
- Re: Astonshing interpretation of tab delimited input file
- Re: date conversion from m/d/yyyy to yyyymmdd
- Re: Automatically formatting dates.
- Re: Acrobat
- Re: Command Line Restoration
- Counting Rows in Excel
- passwords
- Re: CSV delimiter in non-English OS
- Screen Updating
- Protecting sheets & workbooks
- 32,767 Significant Digits of Precision, with Number Formatting
- format significant figs.
- Excel XP Bottom Double Border Problem
- Sort results incorrect?
- Date Sort
- Making rows fixed so when you scroll down you still see top rows.
- Other symbols for delimiter other than TAB
- How one can becom an MVP.
- Assign Macro to Toolbar Problem
- Analysis Toolpak
- Changing font case in a selected column
- Formatting
- excel sum formula
- Finding duplicate records
- Re: Average of a cell range
- Re: Average of a cell range
- excel pivot tables
- Limited number of characters in a cell
- Excel Printing
- copying sheet within workbook
- Importing CSV files problem
- Spreadsheet Solutions
- Too many cell formats error
- "A document with the name is already open." error message
- Re: Creating a Clear Button within my Excel file
- OLAP cubes from CSV files
- Re: big question
- switching axis
- Re: Colors on worksheet don't display
- Re: Excel 2000 Crashes on exit
- Re: switching axis
- Excel 97 Workbook opens behind initial blank Workbook
- Integration with MapPoint
- Running Calculations per day
- how change grid on (print) for all worksheets in workbook at once?
- Add label to selected XYscatter datapoint
- Corrupt File?
- V Lookup EZ Tutorial anyone?
- Excel to Notepad
- Macro to find parts of words
- replace "#DIV/0!" errors with blanks
- replace "#DIV/0!" errors with blanks
- Re: Cursor Placement
- secondary "x" axis
- length of spaces
- Send this Sheet
- Cannot open excel file
- visual basic macro needed for excel
- MCSE or MCSD?
- Re: Send this Sheet
- Regression with Binary Decision Variables
- secondary "x" axis
- Delete External Links
- Re: formula
- tweak macro code - use "Find"
- Re: Need Excel Tips
- Printing Grid lines
- Calling out an empty cell in an IF statement
- hyperlink to excel worksheets
- Multiple Instances of Excel
- Re: duplicates
- Re: Format Painter keyboard shortcut
- Unable to Read File
- Slow to Open
- Address Labels
- Excel 97
- Re: Excel VBA Adjustment To Insert Rows Code
- Converting Coordinates in Excel
- Use Excel Spreadsheet to Update Access
- Re: Excel VBA Adjustment To Insert Rows Code
- Re: Can't find file
- Re: Zero doesn't equal zero.
- Excel XP Bottom Double Border Problem
- Subtotals keys on second row instead of first
- Dates Change to 1996 When Pasted
- howto define definitions for cells - listbox?
- Excel VBA Adjustment To Insert Rows Code
- Re: pull down list
- Templates that were in Excel 97
- Tabs work incorrectly in excel
- Re: Calculation
- shared workbook
- Re: pull down list
- Re: sorting while maintaing certain styles
- Dead Links
- Re: font size
- What is Unicode Format while saving xls File
- Number formating
- hour of maximum
- Scrolls too fast.
- m/d/yyyy h:mm date conversion to yyyymmdd ???
- Re: Average of a cell range
- inserting a tab mark
- Removing a link that can't be found with FIND.
- Re: Please help
- customize a calculated field in a Pivot table
- Re: Creating a Clear Button within my Excel file
- Problem Date Formatting
- Formulas not being copied down - until cell is clicked into
- Office 97 and 2000 files get saved as temp.
- Re: import Lotus via batch file
- Re: Send this Sheet
- Re: dead links
- Re: filename link
- Demo of Newsgroup Solution Capabilities
- Pull down list - drop down arrow
- Re: Fractions as Decimal via DDE
- excel/word
- Re: Comma delimited files
- Re: Repeat cells/rows at bottom
- data display being cut off
- Re: Invoice not printing in color
- Re: colored cells not visible on monitor
- Re: Excel Border Printing Problem
- Re: Complex header
- Need to add up some cells in an certain way
- run-time error 53 when starting Excel
- Looking for a loan calc spreadsheet, one that if you make an extra payment, it will calculate into the duration
- bad behaviour of command bar buttons
- Saving a picture from excel directly to a file
- Floor function
- Assign Macros to Toolbar Problem
- creating sorted copy of table on second sheet
- Customizing Menu (Right Click Menu)
- Help needed with lookup and filtering
- Re: Excel to Access
- Excel macro's
- Sort on Cell Colour
- Excel copy and paste
- Excel-Grouping with protection of worksheet?
- Option Button protection on spreadsheet
- Hiding VB code & Securing Code
- Stuck in Select Mode
- Problem with Excel files being locked by Administrator
- script export to csv file
- Formula Help
- Re: Some code required
- Removing the Macro message when opening a worksheet
- Re: Lost Excel Sheet by not saving...can it be retrieved?
- Sorting Addresses
- Re: Lost Excel Sheet by not saving...can it be retrieved?
- Simple conditional formula
- Any more than a 100% is just excess
- Titles
- Trouble with time formats
- Re: Inserting filepath and filename
- Parameter queries in Excel
- Printing large worksheet onto HP Designjet 800 plotter
- Formatting cells difficulty
- Copy whole number value ONLY
- Re: Can You Sort By Suffixes?
- Inserting filepath and filename
- Starting Macro Recorder
- Text import drops commas and periods
- Re: mkdir question in VBA
- Excel and Sun Accounts
- Time Conversion
- Re: Delete name on worksheet to copy
- Choosing from a list
- Excel Passwords
- Query refresh message on Excel
- Re: .csv files
- Re: Converting Word document to Excel
- Re: Lost Excel Sheet by not saving...can it be retrieved?
- Disabled Macro File
- Text Method "Overwrite" problem
- Lock Row as Header
- too many copies of the same files in word and excel
- rows
- Can't Delete Rows
- Auto updating a chat
- Re: Automate Opening Excel
- Lock Row as Header
- Converting Word document to Excel
- Scroll in Excel
- Excel 2000-breaking the link to another worksheet
- how to generate an Excel file in VB?
- Lock Row as Header
- Excel does not start
- Mortgage calculator
- Count Formula
- Re: referenced cells
- Tracking Changes
- derivatives of data
- EXCEL and OLAP (Analysis Services)
- Whats wrong with this formula?????
- help with conditional formula for a group of values
- multiple splits
- Re: excel article
- Duplicate
- Re: Reducing the Size of a Spreadsheet
- Re: Reducing the Size of a Spreadsheet
- Let me try to explain this better
- Re: Reducing the Size of a Spreadsheet
- Cell Values
- Re: referenced cells
- Stuck on Select
- Unable to print landscape
- Creating an "Empty" Cell
- Re: Auto save
- Multiple instances
- Formula Bar?
- Thick column lines
- unwanted shutdown
- copy and past Rows with exception of Hidden Rows
- Re: copy and past Rows with exception of Hidden Rows
- Re: copy and past Rows with exception of Hidden Rows
- Re: Can't Open Large Excel File
- Exporting a text file to a excel work sheet
- macro status indicator
- How to add fonts?
- non-rectangular name - definition?
- freeze user
- Multiple Excel Files do not open in Alphabetical Order
- If E9 Is red then place tommorrows date in A11
- Combination graph
- macro propagate
- Re: formating cells to recognize commonlyused words
- Re: Manipulating Excel spreadsheets for use on the Web
- Re: Search Methods
- Re: Pivot
- Re: didnt save a file............
- Comments in protected sheets
- Re: Linking to Custom File Properties?
- Re: "unable to read" excel file
- Re: Excel 2000-breaking the link to another worksheet
- Re: Get data from particurar cells in many worksheets and put it to
- Re: multiple Hyperlinks
- Solver Add-in
- Importing large text file into Excel - limited
- re-organizing data in spreadsheet
- Does Excel 97...
- password
- Re: "Unable to read file" Please, I need help!!
- Formula help....
- Re: Get data from particurar cells in many worksheets and put it to acolumn in a new
- Compare 2 Excel docs
- Re: Menus in excel - share special menu with others
- Data-Exchange between Excel and Word-Documents
- Re: open new Lotus file
- User Forms
- Index / Match ?
- Comment Boxes
- *.xls file is saved from 5 up to 60 minutes !!!!??????
- How to replace symbol ?
- Re: Index / Match ?
- Re: Tab Order Problem
- Re: "unable to read" excel file
- Re: open new Lotus file
- Help with HELP
- finding active cell
- Comments
- Comments Again
- Re: Can You Sort By Suffixes?
- Re: Excel 2002 gridlines are uneven when printing to HP4
- Displaying Degrees Minutes Seconds
- conversion of *.wdb file to excel (or access)
- How to convert from small to all caps
- Building a Master To Do List
- Re: Formula Help
- Updating Excel spreadsheet with code.
- Re: Formula Help
- Re: color printing
- Re: color printing
- Cell Margins
- Re: color printing
- Formula Help
- Formula Help
- what is plus sign in'=+(a1/b1)'?
- solver add-in
- Data collection
- Can you add or merge two text into one
- Wrap Text will no longer autofit
- Re: delete columns / upon hitting enter, return cursor to next row column A
- Re: Modeless in 97
- Excel 02 gridlines uneven FIXED
- automatic solver function
- IF statements
- Formula Wildcard and/or Remaining Value
- Password Protection
- Excel-custom.DIC
- How do I insert a check mark into a cell?
- Excel Keyboard shortcuts
- Removing hyperlink from multiple cells in Excel
- Find Worksheet by name in any open workbook
- Tab key moves me way too far over!!
- Scan documents directly to excel
- Menus Do not work
- Using mathmatical functions on ranges that have #NA
- Showing names assigned to phone numbers
- Tracking Number of Times You Print a Spreadsheet
- Autofilter question
- Re: Autosave
- change histroy printing
- Viewing Spreadsheet Data
- excel macros
- Trouble Using Named Ranges in a Chart
- Re: color printing update
- Re: Hiding rows containing drop-down list boxes and check boxes
- Todays date in a cell
- Re: Spreadsheet opens twice.
- Re: Is it reliable?
- Re: Problem with mailmerge in word
- How to click on a cell and have that link to a sheet
- comapring two worksheets
- hiding formulas
- creating a database file from excel
- Excel start up
- Word wrap
- Re: Autosave
- Re: Imported tect doesn't recognize e-mail addresses
- feet and inches
- PIVOT TABLE QUESTION
- Exporting Excel data into Word doc w/o cell boxes
- Re: Excel help
- Printing comments
- protecting cells
- Re: Saving Excel 2000 worksheet to a Formatted text file
- Re: working with hours, minutes and seconds.
- Re: working with hours, minutes and seconds.
- slow copying & pasting with keyboard shortcuts
- paste two columns into one
- Re: Reformatting Existing Data
- Can MS EXCEL remove duplicates and separate by color coded items ?
- Re: Word wrap
- Re: fwd_auto_file problem
- Re: printing by decending and accessinding order
- Re: # sign apprears in Excel Printing
- Date
- Re: Viewing Excel Data
- how to automate exporting excel worksheet to csv file
- Re: custom "help" screens
- Help! Where do I begin?
- Re: ALT+CTRL+ARROW not working
- Re: Copying Access Data into Excel
- DATEDIF
- Edit Excel file
- Re: Can EXCEL remove duplicates and separate by color coded text / items ?
- Comment in Cell
- Recovering from an accident save?
- Formula in a cell
- automatic fill in
- where can i store macros?
- help with VBA code re comparing cells and generating message with detailed info
- Re: Compiling multiple worksheets
- Code to combine workbooks
- Automating a weekly meal planner template.
- Headers
- Error Message
- Fill Color Not Visible
- Re: Compiling multiple worksheets
- Re: VBE code window
- Re: Sorting Odds & Evens
- Conditional Format
- Re: Sorting Odds & Evens
- Re: Formula
- Formula
- Re: Formula
- Printing comments #2
- Re: Compiling multiple worksheets
- Templates
- data validation
- Saving Macro's
- Export dialogsheets as forms
- Re: Excel 2003: XML Validation upon editing ?
- Excel Open and Close
- Re: how to generate an Excel file in VB?
- Incrementing Worksheet numbers???
- Re: Sorting Odds & Evens
- Re: Sorting Odds & Evens
- losiing pennies
- Hiding contents of a column
- Need help on chart
- Re: Sorting Odds & Evens
- Code to combine workbooks-more
- Invoicing
- Want help in excel sheet
- How to import more than one text file into Excel ?
- Re: Repeated Data in Choose Function
- Repeated Data in Choose Function
- Re: Autofilter Lost Upon Macro Run
- Re: Sorting Odds & Evens
- Long processing times
- Re: Copying columns into rows
- Doesn't display zeros
- Re: Sorting Odds & Evens
- Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
- problem with MOD in lookup
- Graphs
- Excel "file is already open"
- User Defined Function in VBA do not work in Excel
- Help with a day of week formula
- Macro location
- Hyperlink modifying
- Re: Link cell include format
- Dates and Arrays Driving Me Nuts - Help!!!
- Dragging formulas
- Need VBA code help on columns to text without loosing the format.
- FORMULA
- Using API to copy files
- List Boxes
- MS Excel Print setup
- Re: Cut and Paste
- Hyperlink is not updated after inserting rows.
- Transposing grouped data in rows
- sorry, repeat question
- Sorting Problem
- List Box - column widths
- Re: printing VB buttons
- printing VB buttons
- Re: merging xls files
- merging xls tables
- Rolling Average in Excel
- Re: Mail Merge Problem
- Re: Pictures
- Menus - Removing arrows to allow all functions
- Re: Macro to run when closing off workbook ...
- Lost Data because cells become editable without request
- Excel 97 and Multiprocessor Environments
- special characters problem
- Pivot table order and limit
- VB - interior.color function in Excel
- Application Error
- Error when saving
- Extract from URL
- emf files
- Invalid Characters in Excel XP Worksheet Names?
- Not enough virtual memory
- Help! Excel to HTML needs Refresh?
- Excel Not Responding
- Adding custom Line in XL CHart
- Copying zeros into fields from "copy file" macro
- Re: itīs impossible to find projet or a library
- Re: tab
- Linked Objects Error
- Save to floppy as backup
- Excell
- Re: "The file may have been changed by another user
- explorer pops up automatically after openning excel or word doc...
- Re: row numbers shown when scrolling?
- Forms and Controls
- Need macro to automatically update Excel Pivot Table
- Finding first empty cell in a column
- Re: Problems with Import from Foxpro
- split sentence into columns automatically
- Suppress toolbar at opening
- File Size
- Excel constantly highlighting
- Viewing Tables in an SQL Database
- More than 3 on Conditional Formatting
- vlookup and array formula (again)
- Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
- How average blank cells w/o error?
- Saving a Custom Color Palette
- Temp file plague
- reading error on floppy disk
- Excel Pivot Tables
- Re: Home Key and Macro Question
- Re: convert or import HTML file to Excel
- Filtering Based in a cell value
- countif
- Re: Pasting autoshapes
- Writing Macros without using VBA
- Pivot Tables in Office 2002 vs Office 97
- Spreadsheet help,
- Excel automatically divides values entered by 100
- Pivot Table - Junk in fields
- Opening Excel
- John Peltier website prob
- Formating shapes
- Copy spreadsheet into word document
- Running Excel as a stand-alone application
- Cursor jumping cells and wont accept data
- Changing hyperlinks for a range of cells
- Date Formula
- Pasting without TABs
- Error Message "Too many different cell formats"
- reversing first and last name
- IF Statements
- Re: IF Statements
- Keeping Row 1 At Top When Scrolling?
- Invoice Numbering
- Unique Records
- Re: maximise spreadsheet
- Re: Current time on computer
- Re: Current time on computer
- Error message
- Graph question - Combination stacked bars?
- Text wrap w/ column width/row height
- Data Validation
- Problem in "if" formulla
- PC to Mac and back
- VLookup results in #n/a - write a formula that sums
- relative reference contents of a range
- Error "Out of Memory"
- How to change default date format of dd-mmm?
- Forgot Password
- Saving a single worksheet
- Large amount of cell text
- stop auto hyperlink
- worksheet formats
- Lock-Protect documents
- Re: Looking for a string into a lager string
- Importing Text into Excel
- Re: Looking for a string into a lager string
- Help with Columns
- Re: Contraining terms
- Counting dates in a table
- Re: Invoice help!
- Excel file saved as Word format
- Changing the Zoom to open a document in 100%
- Pring file path in excel
- Formatting problem
- Best Way to Create Log File?
- excel charting question
- Problem with Microsoft Query
- Saving an excel file as an ascii file
- Help for how to associate names to phone numbers
- formula lesser of
- Cannot Open Multiple Instances of Excel
- Conditional Formatting or Macro?
- Viewing Excel Workbook
- microsoft excel invoice sheet
- Help file - ???
- Changing a template
- cell color
- Export to Word
- Logic Question
- compare values on columns
- Re: Multiple workbook files opening
- Re: Multiple workbook files opening
- Re: Zooming a Validation List Dropdown
- Re: Adding a column - not numbers
- More info on my Microsoft Query problem.
- date validation
- Fractions Number format
- sort wrong? a-1,a-10,a-11,a-2
- table within a cell? or multiple hyperlinks in one cell
- Print Command Button Quandary
- Reserved excel file
- Re: Adding a column - not numbers
- Cannot open file
- Fonts in check boxes
- Windows XP and Excel
- Changing READ ONLY files
- Mutiple Cells highlighted
- calculating commissions on ranges
- Re: Counting dates in a table
- Excel cannot find file
- Re: Protect a column?
- Re: Using macros in Excel XP that were created in earlier vers
- formula in a worksheet
- how to add additional condition?
- Re: Numbered Items in a Cell
- Re: Finding the last part of a cell
- Custom add-ins
- Re: Finding the last part of a cell
- Re: random # generator issues...
- Changing hyperlinks in Excel Worksheet
- random # generator issues...
- Exporting worksheet into Word document
- Re: Windows in Taskbar won't stay turned ON
- Eliminate macro warning pop-up
- Query with Paremeter
- Re: Help referencing last cell in column
- Columns
- sum
- Re: Changing hyperlinks in Excel Worksheet
- Re: How to COnvert text string to number
- Numeric -> Text conversion
- Losing Customized Toolbars
- Tab key movement
- Worksheets in a workbook
- Copy last 13 items
- excel font charset
- Delete Macro
- Relating One cell Value to another to the left of it.
- Re: Cannot open file
- Excel problem, File disappeared.
- Combining Multiple Sheets into a Single Sheet
- Keeping properties on unlocked cells constant in a protected sheet
- Formating Issue - Data Downloads to Excel 97
- Hard Format a cell
- getting autofill to recognise pattern in formulas
- Re: zip file names to worksheet
- Fonts
- recognising patterns in formulas - autofill
- End loop macro with count
- setlinkondata and application.caller help
- Day of Week
- Marking cells with keyboard commands - work occasionally only
- Split legend in a pie chart
- Padding a Number
- Modify Calculation
- Protection Formatting
- Autofit row height on a merged cell
- Deleting rows
- excel posters
- Cannot double click an excel file and open it.
- Printing a group of worksheets
- emailing spreadsheet loses date format
- Re: Multi-line text in Excel cell
- Create a template?
- Re: Scrolling Box
- Hidden columns that can't be unhidden
- Blank line in cell
- Insert .gif into protected doc
- Re: Hiding Formulas
- Re: User Rights within a workbook
- Re: Payroll Calculator
- Re: "Another version of the file is already open"
- New Worksheet Designs Needed...
242
vBulletin v3.0.5, Copyright ©2000-2009, Jelsoft Enterprises Ltd.