Microsoft Excel Misc [Archive] - Page 239

To Chip Pearson - Excel 2004 calendar
understanding serial number for time and dates
To Chip Pearson - Excel 2004 calendar
Table name length in microsoft query
Macro for Graph
Count only 315 and higher? Count shaded cells?
saving a text between quotes as csv
Number of rows which are part of a group/outline
from WORD into Excel
Selecting the 'Active Sheet'
range checking
save-as web page, or publish.
formula that r will make a warning sound when the cell has a particular value
Experts kindly help
Page set up
XL97 - AUTO FILTER
XL97 - AUTO FILTER
Hide Rows
Getting text to appear in another sheet
How to direct user to enter certain cells from drop down list?
How to get the name of worksheet in cell?
External Links and Excel 2003
Sum of a column based on color coded cells
Converting Works 6 xls to Excel 2002 files
Sorting by formula results intead of formula text?
Linking multiple excel sheets
Help please
Dual Processor Support ??
Copying 1500 email addresses from excel into outlook express
Excel gridline overlap problem when printing.
How Do I Count This LIst?
Reading .wks file
Naming sections of a worksheet for reporting
Excel Links in Word Documents
Imported data into Excel
Fuzzy matching names in two columns
Customizing Keyboard Shortcuts
line break within single cell
Calculate/Circular Reference Problem
Practice Files
how do i modify the excel template?
Text not consistantly appearing in adjacent cells
Separating Names & Last Names
working with named ranges
Separating Names & Last Names
Copying Dates from one spreadsheet to another
Copy / paste range as a picture and save the cell borders!
EXCEL.exe has generated errors
Userform Calculations
decimal value leading zero's
Recalc freeze (2K SR-1)
Summing cells with null values
AutoSave with Excel 2000 - prompting
Change cells with same data
tab thru unlocked controls
saving formulas
Excel file open error
help with problem....
Separating Names & Last Names
Color modification and workbook duplication.
Information Transfer from Excel to Word
Excel 2003 Toolbar customzations disappear
Iterative Calculation
Variable Length String
Excel 2003 dissapearing buttons
Excel 2002
Linking Workbooks and minimising file sizes
Repost: How to calc string's printable width?
Enter Text and Formula in same cell
Automatically excluding "#VALUE!" from "SUM" function
help! named ranges/data validation changing by itself?
Check Box's
'Save As' warning 'Protected and therefore read only'
If statement
Custom number format displaying thousands
Validation with varying lists
Validation drop-down gone - due to filtering?
preview pane not working
Forms like the Invoice Template
random selection of cells in excel
Receipt Format
Sending Excel file as attachment to Lotus Notes mail
Exporting Excel output to pdf/rtf/doc format
file is locked for editing by ' '.
Custom Number Format
Corupted file? "Unable to read file"
auto opening spreadsheet
MID & VLOOKUP Function
Solver Add-in problem
how to count cells...
Importing from web page
Excel Formulas
Wildcard variables with countif statement
Cannot merge cells, old spreadsheets, new Excel
Cell refs and VBA
Add numbers in a cell
Special Characters
Count if cell contains a comma
fill series and protection
Is this possible?
Excel Network "Chatroom"
Replacing an OLE picture's picture property
office assistant characters
EXCEL 2002 upgrade installation
In Excel 2003, how do you export to a .csv file?
How to Extract Data from a CSV file???
service pak 2 for office xp
Parsing Info in Cells
How can I convert text to all lowercase?
AutoComplete
Changing cell size idependent of the other surrounding cells
Interactive online VBA training recommendations?
Message box in a formula
Excel Comments Problem
How to copy file directory into Excel?
Excel Merge
Function for Monthly Profit
Importing excel files
Dating every third column?
Transfering database from works to excel
Sorting
Multiple criteria count
view the formula
Solver
Searching for different strings?
Fairly Easy Formula Question....
read only status
Icons
Another query
Only One New Worksheet
Attention localized users: Dynamic named range not showing in list
Exiting a called procedure
How to create a help file
Spreed sheet???
SPreed sheet formula???
Text block query
Any way to AutoComplete numbers?
Zip Code question for clarity
Solver in Excel 2002
Pictures in background
Pictures in background
HELP!? Validation List with Variable Lengths & Invisible Empty Cells
Reading ranges and copying data from Excel when it is not open
gradebook
Table query
GetOpenFilename, default to preview
Retrieving File Info
Excel Viewer
Re-sizing Excel Help Screen
Marco problem
Help - number formats changing
Displaying Counts when Filtering
Pivot tables and named range
look for a range of values in a formula
Re: Error Message: Windows Delayed Write Failed
Limiting what you can enter in a cell
How do I add .htm to every link in a worksheet? Multiple hyperlinks+targets
VBA322.dll out of date in XP
Another replace question
Flip Columns Upside-Down?
Notepad to Excel
complex column sorting
AutoCorrect
Using Symbols (&/-) in In Two Dependent Drop Down Boxes. Can't get the VLOOKUP to work!!!
CTRL+TAB!!!!!!
Referencing relative cell
graph question - easy
menu items not available within excel
Error saving a Shared Workbook
Trying to convert uppercase to lowercase text
Different views of spreadsheets
How to report bug to Microsoft?
2 FONT Color menu boxes that can display 2 different colors independently
Editing Unlocked Cells in Protected Sheet
Printing an entire folder...........
remove rows that have any cells values strikethrough to a blank Sheet2
Web Query Error
Multiple values in a sigle cell, and validation
adding search buttons to excel list
sort without the sort button
Open a DB connection in VBA
Missing Something REALLY obvious
Solver - unsolved mystery!
VB & Pivot Table Refreshes
Copy/paste links
Dates pre 1900
Performing two Advanced Filters in the same sheet
Getting straight lines in a best fit trendline of semi log data?
Link Outlook Contact to Excel Worksheet
Date display
extract info FROM word INTO excel
Date Format Problems
Runtime Error 438
Sort problems
calculating averages with filters on
Reducing the number of lines of code required
Webmail
cells displays formula, not result
Combine Cells in a column onto one cell
excel invalid page fault in Excel.exe
Routing an Excel file
Conditional formating condition..?
Adding data to dropdown list?
Template Wizard with Data Tracking
Allow only one user to access workbook at a time
error in excel help. how to select a cell after clicking the Select All button?
Basic query
Worksheet Tab Name
Error Importing Text File
Excel Error (access violation)
Sizing Worksheets
How to merge 10 files in one step?
excel & web...
Saving data from webpage to excel
open Pocket Excel file with PC
Excel 97
Preventing user altering cell except to delete the value.
Worksheet tab names
Need a help with e-store script
auto filter drop down
Is there a "replace" or "substitute" command in Excel's VB?
Sub versus private/Public,etc.
Exiting a procedure part way through, then returning
Concatinate Excel Files
Command to select variable input range
Macro question
Help me with a formula please...
Concatenating columns of different length
more IF function
Printing Landscape
Countif dynamic range and data validation
Using the IF Function effectively
special account numbers different formulas macro???
Excel 2003 autofill "object" eyesore
How can I save a single Sheet with range not the workbook?
Comparing contents of 2 sheets
Macro to add path to footer
problems with FREQUENCY formula
Excel column labels
Interactive Web Page not interactive??
using sum button
Help with a macro
Why can't I paste an Array command from one file into another file
Printing Excel Formulas
Re: No dropdown arrow
Find Merge Cells
Referencing the name of a worksheet in a cell
suppressing repeated data
Personal Macro Workbook
Text not consistantly appearing in adjacent cells
Saving or Opening in Active Directory
Excel error message not understood
No dropdown arrow
Re: Excel files
Converting Macros in Excel
Problem opening excel 97
Reviewing Tool Bar
Formula to determine Cell Color Format (Shading)
Hard coding column formats
can't access excel file
VBA
Header and footer - placing the date and time stamp
Counting rage of dates in column
MODE of character values
Excel as a Printer
renaming columns
Replace Certain Spaces
Opening Excel
compressing excel file
Opening excel files
MS Works Spreadsheet conversion to Excel
Didn't attach file
relationship with multiple tables
PAGINATION
Printing--How not to Print Bkground
replacing values in cells from a pre-designed table
Bank Statements
Excel stopped working!
transposing numbers.
Format "only" dates withing text in a cell.
dates from database file won't reformat
Printing worksheet problem
toolbar macros
Copy Paste
Dragging a Page field
Sharing
Automating copy and paste of subtotals to new sheet
Excel 2000 error
Genrating a report and getting quote marks in some fields.
Toolbar trouble
TYPE
Crash when using 'Sheets("Sheet").Activate'
Sharing Excel Files
conditional formatting
Adding a 'live' calendar
Cells Highlighted - why ??
Save backup file with date and time in filename
Automating a mailmerge from Excel
Excel Data Consolidation ; Multiple workbooks
Problem with formatting
Need code to detect grouped sheets
Manupilate Query Results
Help using a formula when pointing to a cell
Help using a formula when pointing to a cell
Gridline trouble
convert HH:MM:SS to an integer
Header, footer, page set-up
Excel - Deleting blank rows.
Saving a large workbook
compatible?
Categorizing Custom Functions
Missing Numbering Add-in for Excel 2000
Better way to do searching?
Using a button without pressing Enter after entering data
How to change the Subtotal of my Pivot table to use subtraction instead of Summing
Formula interpretation please
Wildcards in IF statement
Sorting becomming redundant! Please help.
endless number range
using excel data for mail merge with Word
Re: Links to other spreadsheets
Bizarre error message regarding formats.
Scenarios
storing read only data
Placing Result In Different Cell
Automatic Calculation
How do i Spell check in protected sheet
Row Re-numbering
Using Pivot table in Range name
dropdown box printing
getting Excel to print gridlines
shading rows with specific values???
missing part of lines
Using VBA to link Excel and Powerpoint files
Re: Excel files
How do you delete a file in Excel's VB?
Disabling Macros
Unique macros trigger
copy and paste text to entire workbook
#REF#
Re: Spreadsheet as OLE object in AutoCAD LT
Excel 2003 autofill "object" eyesore
excel changes a string in a csv file to a date format! how to get around this?
Contains function
Limited Charaters in Excel 2000
Reviewing Toolbar
Combobox or Listbox
Function for payments
Excel spreadsheets saids that I have it open
Paste Formats Shortcut
Custom view error - "Some view settings could not be applied"
Replacing Rows with columns.
Howto not print a background color
colour formula
Column Headers
Date format change from yyyymmdd to mm/dd/yyyy
Spreadsheet not saved
Cells Jump
Referencing a cell on another worksheet within the same workbook
Save As Disappeared
Excel 2000, 11 X17 Page Size in Page Setup
A problem with Excel
Importing directories
Protect a Worksheet in Excel 97
Message says "Trying to open file that's already open"
Is there a textbox that will work for Excel Mac?
Concatenate
Help! Automate linking data
recently viewed documents
row number in Excel
Data Validation drop-down list does not appear
Script to backup and rename excel workbook
Script to backup and rename excel files...
combine hide row macro with conditional formatting
MS Query over a network
startup template for workbooks
Date Formats
small debug help required
Consolidating??
Conflicting Versions of Excel
Application.thisworkbook.saveas .. Is there a way to bypass "Overwrite" popup?
Help. Linking issue
Protection
Limits to selections in Autofilter drop-down? (Excel 2000)
Finding links in Excel 97
Convert to Access db
HELP: Running two Macros, one before the other
Auto Num
Goal Seek
Filtering problem
Excel 2003 Compile Error Message
Vlookup problems
more colummns needed
VB Variable Help!
Recording Sports Tournaments
Short cut for deleting rows
Help
moving between worksheets
Styles don't work from toolbar buttons
default template
Addiction with conditions
Macro / password protected worksheet
Auto Save?
How to create drop down list that determines another drop down list?
HELP!- Mouse Right Click doesn't work in Excel workbook
Re: Excel file won't open unless Excel is already open
Changing Case
How to transform formulas to the text?
Change Text Case
Highlighted cells
Pivot Table - refreshed from ODBC connection
Converting min&hundredths of sec to mm:ss
validation data for drop down list
Automatic column deletion
Invalid format message at startup
hyperlinks
flipping columns & absolute references
Keeping duplicate records
losing settings excel 2003
set print area
toolbar button
Creating a link to a subroutine...
Importing text file
Another stupid question..
Service pack determination
Unable to read file
condition formula?
Printing document references
file not found
Hidden Column - Excel 2000
lookup and arrange data
Hidden Column - Excel 2000
can't print
storing text format in autocorrect
Multiple lookups (one more time)
Custom View
Grand Totals without subtotals
Consolidated data ranges not working in my Pivot table
Basic Excel Help....!
Excel file downloaded via web - No editable formulas
Pivot Table showing data with blank values
Refresh and update of Pivot tables on protected sheets on opening wkbk.
Data Validation
macro
unable to open excel file which contains macro
scroll bars in excell
Remove all spaces in Macro
concatenate in chart titles
Re: Formula in MS Query
HELP!! adding Area codes with phone numbers and state HELP
Show zero
Increase Checkbox Size
Re: Formula in MS Query
HYPERLINK bug when nested in an IF statement?
test
RowSource in ListBox
Vlookup
How do you get a TRUE refresh of a Pivot table
VBA function missing its parameters
mail merge in word from excel
Spreadsheet as OLE object in AutoCAD LT
Formula in MS Query
Conditional Formatting
Numbering a spreadsheet
help with cell navigation
Merge & Purge two doc's in Excel 2000
leading zeroes in CSV files
If this or that Formula
filter format
Removing Linked Worksheets
First post, probably something easy to solve.. i hope :)
Error: File format is not valid
Page Numbering
No new fonts allowed!
Excel spreadsheets
Error Message When Opening Excel
macro changing with sheet name
IF statement / SUM IF
Save As Macro
Log Graphs
Toolbars appear when open file`
Excel spreadsheets don't open right when downloaded in Internet Explorer
Transferring a Sum total w/o the background formula
Quick Date / Text query
Next Profit Date Prediction
Relative Reference to Multiple Worksheets
Change the number of charaters in a cell by adding a zero
Change the number of charaters in a cell by adding a zero to the beginning
HELP: Running two Macros, one before the other
Help with date automatic date problem (probably very simple)...
checkbox and drop-down list
errors
Append Data To Access Table
Combining Worksheets that have similar (not exact) matches
RE: Merging Excel Files into one file
Problem while converting excel to csv for Special Characters
multiple sort
Copying and pasting list information that is not fixed (using dynamic ranges)
Difficult in creating a macro
COUNTIF using multiple conditions
Duplicate entries & Conditional Formatting
Excel Number Entry Problem
Launching file from Windows Exploer problem
Prompt for Close
excel 2000 out of memory
Time format
EXCEL Keyboard bindings
including non-significant digits (XP)
Date Format
How can I set up a gantt chart in excel?
Separatting Data in Columns
I want to display a graph vertically
How to reduce the number of 'clicks' when saving
delete rows when any cells in column A is filled in RED color
Auto fill Shortcut
workbook template
help with lookup (years and Months)
Using IF formula with dates
Decimal masks
Changing Multiple Formula
Excel and Email Combo Question
Find & Replace Hyperlinks
Creating report for Excel data?
Sheet selection/naming difficulty
named range scope...
number formats and masks
Allow Sort in Protected Worksheet
Recommend an Excel-friendly PDA?
Creating your own Autoformat arrangement(?) - FAO gocush/Harald Staff
excel 2000 message - 'cannot use object linking and
PDF file
Data Validation
Unable to Read File
Linear Scale on Graph
Filter
format not valid
Compress Large Worksheets
Show file properties when opening a workbook
How to copy custom number formats
Auto correct
Task Pane
Adding and subtracting hours in Excel 2000 worksheet
Removal/Edit of post
Help with print area
Ordering data for Mail Merge, printing to labels
How to password protect WORKS spreadsheet
Append Data In Worksheet To Access Table
How (Where) to set the font of sheet tag
autosave macro
Excel 2003 scrolling
Cell deletion
Arrow keys
Extracting macros from a worksheet
Extracting macros from a worksheet
2004 Excel Calendar
can someone please help
Updating links Excel 97 to XP ??
How to print uneven pages Excel 97
Picture linking in Excel
How do I switch Excel 97 from Win 95 to Win XP
Adding Text Values
Extracting macros from a worksheet
Shortcut Key
Numer Lock
Excel memory Error
Freezing Cells
Protecting Multiple Worksheets
Microsoft Excel for Windows 95 Version 7.0
EXCEL.exe
Compile error: Distmon
deleting every second row
EXCEL.exe
Forms Option Buttons
date and time formatting
Paste from Access
Excel 97 no longer supported
Automatic date editing
Excel error
Importing Btrieve files to Excel
Drop-down Lists and Worksheet Protection
Hyperlink propagation
Conditional formatting using OR() & AND()
Word wrap and merged cells
Change default number format
Printing Long Columns
default # print copies changed
Open Office
Cell Reference in text
Lookup
Insert Picture IF criterea is correct???
Conditional Formatting question.
Displaying Date in Textbox?
Saving to Network Share
A3 / Custom paper size
Unwanted excel conversion text to dates
Data Import/Export
iterative caluclation
printing multi-worksheet workbooks
Auto refresh on opening
Excel files won;t open
histogram R1C1 error
How did I break the cell display limit?
How did I break the cell display limit?
Vlookup Macro
Cell Character Limitation???
Excel displays formulae, not results
Hourly time calculation
New time system in decimal format
removing empty rows
Using Current Time
Formula
this
Changing Short Menus (Right-Clicking)
Help with drop down boxes/menus
column heading
Date format
custom built Excel macros
EXCEL HEADINGS
Use same format as another cell
Saving Excel file in arabic language
Convert Date in month?
Countdown Clock
Excel
round
Named range lookup
Lookup based on currently selected cell
Coloring Sheet tabs
importr csv into excel template
Can't get Excel from Office '97 to work in Winows ME
File Origin 932:Japanese
Charting dates
Copying Conditional Formatting ONLY
Upload Pictures in Excel to a database
store data
counting months
XP Problem - toolbar changing path of assigned macros
Function Help
Multiple comparison of list items.
Auto insert time in pocket MS Excel
Help I'm Stuck...Delete cells that don't meet ascending value criteria?
Help!!!!
converting from 2002 to 2000
Microsoft's square root table macro
Generating continuous lists using lookups
Looking up the rounded value in a cell, not linking to the value.
Databases
open and save as... buttons
Column limitation - why?
Help please - Character display
Office 2003 Beta version
Limits on number of columns
random names generator
Filename -> Image
I'm stuck...
Array formulas
Simple percentage formulas
Re: Start a macro inside an IF-function
Start a macro inside an IF-function
Array Function LINEST
Blank excel spreadsheet
Copying cell formulas to another workbook?
Extracting football league position to another work sheet
Copying rows from Subsidary Files To Mastersheet with Formulas
Lookup with multiple criteria on diff worksheets
question on pivot table
merged cells data
Complex Lookup in Excel for values not in same row/column
running total of the difference of 2 columns?
Decision Trees in excel
Lotus to Excel Problem
countIF?
when opening Excel Files
microsoft XL
Time Calculation
Drop down menus problem Win95
Restore button does not work
Calling a subroutine from a module
Excel crashes when columns are deleted or added to workbook
extracting data
Merging Excel Files into one.
Program excel function
Autofilter and protected sheets
Next Referenced Cell
Problems With Data between datasheets/workbooks
Numbers appearing in decimal form
Auto change of Row number within Formulas
Column formatting not accepted
learning excel
time in the Y-axel...
outlook express password
How do I display all formulas?
XL and the Web
macro - tracking cursor position in macro
race odds
Data Command Disappeared
Reformat data from 3 columns to 9 columns worksheet
Converting my hours into dollars I'm a total novice!!!
Lock format changes
How to get different windows for Excel spreadsheets
BLANKS AND SPACES
export from outlook to excell
SORTING BY "text"
Print showing formulas
question for Excel file
Control Object
Conditonal format based on another cell value
Complex formula
Roundings
Roundings
Roundings
Roundings
Copy & Paste Problem
Copy & Paste from internet???
new to excel
2nd line of wrapped text
Excel calendar templates
Copying multiple cells formula and paste as Values in same locations
Best book to learn excel?
Function/Formatting
Password error
To Define Name Instead of Range
Web Query and Line Break <BR> tags
Print result is different than preview
last entry formula
"1" + "2" = 0 (?)not what Help says
Multiple Excel spreadsheets will not respond when opened from server
Auto formula when putting in date
comparing two spreadsheets?
Excell 2000 - Cannot open Invoice spreadsheet
Matching Issue
Printing from Excel
Colour in Cells containing dates
long formulas are truncated in Resolve Conflicts dialog box
Document Not Saving
Excel switches back to fisrt sheet in a file
no formula calculation
Control Objects
Cell content as a filename in a link ?
Nesting Sheets
Can vlookup handle more than one match, if so how?
Date Conversion
A Problem in CSV file
Scroll Bars - Form Tools On Worksheet For A Table And Chart
Summing two columns
A quick question
Have a formula print to different worksheet
deleting checkboxes
New Toolbars disappear
Counting problem
Replace cell of column with cells of other worksheet