Microsoft Excel Misc

Help!!!
Using the last number in a column
problems switching speadsheets in excel 2000 using windows xp
printing multiple sheet tabs to image file
custom footers in Excel 97
how do I undo a save?
Nested functions in conditional formatting formulae
check boxes - copy
Applying same macro to all worksheets in workbook
copy worksheet with formulas but not data
SSN Format
Macros
Please, need help with multiple "if" conditions
replicate column across worksheets
I can't open .qpw files in excel
Counting individual #s
VBA Book
Change cell color if it is the lowest number of a group?
When you click a hyperlink in a cell i get a Warning message
Sum of Lowest Cell Numbers
change excel column headings from numeric to alphabetical
How does one lock in column headings?
Auto Populate Time
Excel template that lists each month's meetings w/ some detail
frequency of events
splitting cell values
Follow-Up (Clarification) to MIN question
How do I add-in Excel Solver without the Installation CD?
Define a range of cells in VBA
Number and Word in the same cell
how do I import data (distance and time) from MapPoint to Excel?
Convertin Text to numbers within a Macro??
#value error
use a variable array in a formula
activate a worksheet formula through a button
Is it possible to link spreadsheet to website for input
How to fill the matched field automatically
How do I insert space between 2 consecutive columns of an XL Shee.
disable customize option when right click on menu bar
Excel crashes from explorer
Retrieving comment using range name
Passing parameters Cel Ref) to Sum function
Using cell value in formula?
Number of Columns
Spreadsheet Style
select first cell in unmerged range
I need help on a Macro
How do I find the total number of the same number/letter in a row
Microsoft query in Excel
How do I show schedule 11pm to 8 am in Excel?
Add a picture
Print few rows with many colums so that rows wrap on printed pages
Find and replace should work in Excel text boxes
Listing a selection of data from one worksheet on another
Columns Entry
How to show Excel Filename in the worksheet
Mail merge a spread sheet omitting some entries
multiple criteria in one field 4a,4b etc of countif?
Confusing output from cells
De-duping Add-In
Delete graphics copied from a Web page
database functions in excel
some kind of meta-way to refer to sheet and file names in Excel?
insert a blank row after data changes in a column
Finding linked cells to other workbooks
Add a column outside pivot table and...
Swap contents of two cells
Plus sign in front of a formula
Have cell require input before saving.
Obtaining Max and Min Values with Sumproduct
How do I enter a missing data point?
Will excel add cells using colour coding eg Add all red cells
Lotus 123 import to Excel loses 2 text characters
Text shifts left in Excel Combo Box when user types in entry
Why is my sort menu option disabled?
code for a pop up box
Which method is faster
How do I import data from lotus123 & maintain formulas/worksheets
How do i recover unsaved changes?
Pasting text
Big problem with Excel 97
I need to sort 9 columns
underline in cell prints on word below
Zero's
Extracting data from 2 pivots
Invioice toolbar
How do I insert a symbol using only the mouse?
No Buttons to Control Subtotal Levels!?!?
Working with a speadsheet of 15,000 rows
Query refresh
NosmoQ, good for health, can stop smoking addiction..
hyperink outlook mail messages to cells in excell
I have numbers instead of letters on my columns, why?
Macro to remove text
Sticky sorting/macro/VLOOKUP problem
AutoFill
Creating
Can't start Excel based on File Type
how do i delete a (read only) file?
How do I track half days in the attendance tracking template?
table into Word Document
Comparing Workbooks
How to automate process of replacing values?
Filter on bold
Filters
why does right click on row bring up save as?
I need a pop up message when a check box is checked
Strange freezing on startup
Format percentage as a decimal
Pivot Table Grouping (Excel 2000)- This has to be simple
vlookup
Share Workbook is grayed out in the Tools menu
How copy cell workbook to workbook?
LOOKUP and higher value
Formatting on unprotected cells
Partial input
IF function - limit to the number of IFs?
Q: check a range values
Header/Footer side margins
Converting text string to a its proper time format
entering data using tab
Selecing cntrl + arrow key to move to next populated cell
Area that duplicate showing what I type in a cell is missing.
text box to contain formulae results that recalculate
How do I change lowercase data to capped data?
where do you download SKU001.cab?
Excel saves the path of the printer with the document.
Excel 2003 took so long to save
large numbers going from XLS to CSV
Date comparison
Variable range reference
Formulas
Editing multiple cells with one action????
Excel Spreadsheet from Access. List of names changes as names are
how do i use excel to refer to outlook?
How do I publish a workbook with a list?
finding & filtering out duplicate cells
autopopulate sl.no.based on a cell value
Roll-up data into master report
Database Query
Modifying data
Disable Customize toolber tabs
Left align '$' and right align numbers?
How do make input date by "month/day" in Excel?
Excel Shopping List
HOW DO I INSERT PAGE NUMBER IN A CELL ?
Finding an external reference on a worksheet
Excel 2003 Printing
Why cant i add a comment?
Graphs in Other Files do not Update
Cross table
***Two Input Data Tables***
The Pivot Table field name is not valid,
Look up tables
The Pivot Table field name is not valid,
Autofill
Automate without add-ins
I am running Excel 2003 from Office 2003 Professional
formula - all odd numbers (or even?)
Select a certain number of cells in a row
Excel starts sorting from row 210 Why?
How to project the due date according to a number of working hours
Manipulating large worksheets and hardware capabilities
Excel - merged cells w/wrapped text auto row height doesn't work.
Help with macro for emailing
Excel template/database/macro help
Very easy I'm sure
Find dates in a range; then sum values in that range by a criteria
help wanted to clean up a data sheet
Modifying a footer date
Problems in excel as a texteditor
Conditional formatting
Copy VLOOKUP Formula
How do I lock an image in Excel so it doesn't move?
How to Copy the value of a cell to any given cell
Getting Rid of [GROUP] ??
Excel DDE with images
How do I get Excel to display a range of cells with a check box?
Is it possible to use multiple IF and OR
360Days Formula
How do I leave formula cell blank if 2nd reference cell is empty?
Word auto text (normal.dot)
Very simple function not working
MS Query Date Format
Help with Bob Phillps' UDF SheetExists
Format Autoshape Contents
How to display numbers as 000, 001, etc.
Function
How to calculate speed given distance and mm:ss time format?
Correct way to =IF(B6<7000,B6*0.45)=IF(B6<97000,B6*0.5) ...etc
Custom Views
I need to add and subtract time cells. ie. 13:45 minus 13:58
Finding value
find all cells that match and use in an index/vlookup
Using a command button to add
Deleting All Rows for Duplicate Entries Except Those With Most Items In Row
are multiple Hyperlink destinations, in one cell possible
How do I make flashcards from Excel spreadsheet?
Why do cells in Excel print shorter than displayed on-screen?
Enable macro
terminate a form
macro sheet select
how to automatically populate cells using lookup tables
No header on 1st page
function for Column Position
how do I unlock my COLUMN drop-down menu key in excel?
excel report manager
Formula and Data Entry in a Single Cell
Code does not work on emailed file
Q: parse string
Problem removing hyperlinks in workbook
Accidentally saved over important data
excel 2000
Finding common Data in multiple worksheets
Employee Work Schedule
Send the Document, may differ some place due to cell contents...
Logic for Placing Multiple field Returns in a Cell
How to auto-enter date when cell is clicked?
DoUntil VB command
Pivot Table Calculated Item
Remove drop-down list in Excel
TextColumn Properties of ComboBox
How do I remove cross hatches in Sigma column
Assign a Value to a Duplicate Entry Within the Same Column
how to add symbol automatically at begining and end
Added value to cell
Excel 2000/Xp vs Excel 2003
Need help with excel referencing to outlook
FIND function?
Activate Workbook
Is it possible to merge columns for HMTL output?
Columm sums
Take Value and Format
Advanced Data Validation
Can I get Button name or Cell Reference
how do i convert 100 in one cell to one hundred in another cell
Allow any Certain chr within a cell
3 Questions actually!
Offset() returns reference, first not value (proof)
customised output
minimum for casual cells but >0
Freezing Panes
"Print this" link in a cell??
displaying selected items from a yearplanner in a timesheet
Addressing cells on inactive sheets
How do I convert a word document into a Excel document
excel infected?
Excel: How do I protect cells containing formulas?
vlookup and email addresses
RE: Problem with MS Query - can't edit query
Linked screens?
How do I change a number in a cell without effecting the formula?
Add a number to multiple cells
how do I alphbetical my addess list
Split mm/dd/yyyy into dd only
Macro that runs in the background
How do I execute a macro based on the value of a cell in Excel?
MVP PLESE; Report Manager
MVP PLEASE; report manager
How do I make all copies of a spreadsheet file inoperable?
How do I relate data of one document to another ?
Refresh tabs
REQ: Columns to rows or Rows to Columns
Help improve mySchedule Please
How do I stop dates from being entered everytime I enter a number
convert 12345(figure) into word
open at define work sheet
How do I create a 26 'tier' IF formula?
Conditional Format and Pivot Table
Custom Footers.
How To: Link worksheet data to pre-existing chart tables
FUNCRES.XLA file lost
75seconds to load excel files
Comparing a value in EXCEL and XML files
SKU111.CAB....around in circles
xls file
greek symbol delta
My First Post!
using the LOOKUP function
linking cells from different files -fill down
Fill Down formula Help Please
clicking TOOLS/OPTIONS gives me error msg "cannot access dir D:/"
My formula doesn't update totals when I change numbers.
WON'T print whole area
Autofromatting!
Pivot table format changes if value of source data is null
How do I insert a PictureBox into Excel?
Excel printing problems - Lexmark C750
thousands comma separator in VBA
Putting computer date in cell
How do I set up a cell with a pull down list?
Totals
Disable Dialogue Box To Save & Replace File
Secondary subtotals
Help w/ GRIDLINES EXCEL 2003
Date format with day of week and date
IRR, XIRR and NPV - a very frustrating problem
data validation vs combobox
help with quote program using muliple prices for one quantity {cross post}
using functions empty cells
hyperlink question
show name when a cell has specific word
How do I set up a payroll master in Excel or Access?
Empty excel files when double click on them
I have lost ability to send faxes from excel 2003 using addressboo
How do I use multipage
Number count - postcodes and need to count the numbers of tim...
How to untick options in toolbars.
multiple select from the drop down list in excel. list in one sheet and drop down in
How do I add a macro to a custom menu?
Interest calculation
mail merger in excel
Data Validation problem.
mail merger in Excel
Disable Customize option next to a tool bar from VB
macros on one page
forms in excel
Top 10 data sort in Pivot Tables
Excel Formula
remove errors
How do I resolve debug error macro Excel 2000? At least, any lead
Show goal in chart
How do I create a population pyramid?
Variables in Excel
need help with formula
conditional format
Turn $6 Into 15,000.oo In 30 Days Or Less Using Paypal 100% Legal!!! "Noreply"
How can generate an executable file from Excel?
How do I convert numbers to the opposite sign?
MS Excel
Calendar Template with week numbers
Custom Lists in Excel
Running a Macro from within another macro
calculating different percentages depending on amount
mail merge-word file automatically closing
how to reduce file size of excel workbooks
how to create leading zeros on variable length numbers
View & Filter Worksheet
No filter results in bottom left hand corner
filter
How to make a sum from i=0,....,K
How to get more than 65000 rows in and excel spreadsheet
Why does Excel open a blank book1.xls also?
conditional formatting with more than three criterias
links in cells break and revert to user profile location
Dates from Julian calendar
Can you speed UP drag speed?
Replace &F in header with text
insert copied cells
Zero's # 2
Updated Field...
Formatting numbers
Default Cell Values & Save Changes Dialog Box
Change number (in text format) to numeric format
Web Query
Need formula for cumulative interest with additional monthly princ
Omitting Some Cells From Conditional Formatting
Superscript of 1 number changes line height--losing top of charac.
Help...Need to modify data within a column in a .csv file
how does one become an excel beta testor
setting transferred text as constant
Branching Drop Down Menu
Freezing pane
Put todays date in a cell by checking a box!!
How can I keep my numbering system consecutive when I sort?
Help
Noncontiguous ranges printed on one page????
Sort in Pivot Table
Excel - MS OFFICE 2000
How do I format a chart in Excel, but not the rest of the info?
INDEX, FIND.... MATCH????
check box size
Excel Data into PAge Header
Excel Drop Down box or check box data to Excel Database
Compact Workbook
Auto color-shading of rows
Can I reverse the order of data in a set of cells?
How to keep leading zero without changing field to text field?
enlarge validation drop down box excel 2000
Text Watermark in Excel
Keyboard Macro Just Copies Content of Previous Cell
Regression Output -- R Square versus Adjusted R Square
Pasting/Using Input Box Value
Purchase order
how do i query data from cobol to excel?
match a name and return a tel number?
format cell to search text in another cell
change ten digits in a cell to include phone # formats
Count if for every other row
row and column headings
Hidden rows
Changing Filename when linked to other worksheets
SORTING BY COLUNM ENTRY
Can I link every "fourth" row to a summary worksheet?
how do see add-in a funcion belongs to
customise array formula output
adding cells which include numbers and text
adding cells which include numbers and text
update details using vba
formulas
lookup unsorted list
How to find all formulas that used a certain named range
Deactivate shortcut keys in excel..
I am wondering if someone could help me solve this equation
Visual Basic macro run time error(13) type mismatch
Funcres.xla
Can I make 2003 use the buttons icons of 2000?
Template form problem
Save Workbook as Current Date/Time
Save as Current Date / Time
animated cliparts in Excel
AHHHH-Get Data from Multiple Excel workbooks
Pivot Table
Worksheet Not Appearing
Maths Fonts
How do I ask Excel to take the....
Custom Number format question
How do I activate the formula auditing toolbar
OK, a really tricky one now for Excel gurus!
Compiled Excel macros
excel experts
Can I recover an Excel file that was overwritten w/ a blank file?
Would like to add 20 working/weekdays to a date
please draw excel sheet for the following help me please
Bond YTM if Coupon Payment is at Maturity?
Need to convert point on screen to various screen resolutions
correcting a negative date formula
Toolbar problem !
Q: save a sheet to a file
Spell Check in Protected Worksheet & Shared Workbook
How do I find value on a graph between data points?
file opened twice on network
Excel and macro
Sharing Custom Menus
Show workbook name??
Array to named range conversion...
How do I adjust the font size in a Combo Box?
Corruption in Excel?
Conditional Format to change entire row based on one cells data
Vlookup and IF
Tabs inside the cell
Protection
how do I do an if then query in excel from 2 sheets?
Can i change multiple hyperlinks at once
how do i get a column to only add up the figures in a certain col
Highlighting changes to a spreadsheet in a differing STYLE
Can I protect an Excel workbook to allow additions only?
Shared Workbook
Veiwing excel sheet in IE problems.
Comment size
Spell Check in Protected Worksheet & Shared Workbook continued
Are there limitations to OLAP in Excel?
Justify text across multiple columns
How do you get the X bar mathematical symbol?
My hide sheet option in excel is not working
Vacation Schedule Grid
Load Excel with focus on A1
Timer, Tally, and Count
Excel 2003 row height format
How is "A1<=A2<=A3" evaluated?
Loss of excel funtionality within IE
SUMIF with two criteria??
Zooming in on a row
Date Diff
synchronizing the years for multiple dates
Removing hyperlinks in bulk
deleting columns
automatically increment field by one
no warning file in use
outlook contacts
Exporting a date field in Excel to an Outlook Calendar?
Calculated field in Pivot Table
Excel Forms
Excel: printing with hiddent columns
Excel: printing with hiddent columns
import/export quattro pro spreadsheets
allow fill color to be changed or toggled using a formula
Querying 2 databases with one query string
moving workbooks
How do I change the color scheme of the autoformat for table 2?
I need to =a set of numbers to a given week day.ie 6031 = Wed ect
Figuring out loop for a production schedule
"to be carried forward" - how to do it?
"to be carried forward" - how to do it?
VLOOKUP with MAX criteria
Concatenate Dates
Insert "-" in text "1234567890" to have a output like this"123-456-7890"
Populating Excel Web Query across workbook
How can I stop my Excel hyperlinks from reassigning their destina.
Sum if criteria is a name
Insert date modified of external file
Adding dates and times
My links no longer work . . .
auto fill row with dates
REQ: A utilities program that would allow me to make columns into row for headings?
protecting form excel
Relative Reference
i need to make a formula that adds up my hours after my 40 hours
count down the days???
print first two rows (heading) and one row per page...
Cannot open Excel
Retrieving data from a corresponding row from a different column
Nomographs
Remove or change password protected excel file
Counting Formula
Maths Fonts
How can I change the font size on an Excel sheet tab?
VBA code
multiple "if" arguments
Match 10 xls files
Is there any who can help in understanding the VLOOKUP function
expand/collapse row button
personal workbook
Hyperlinks and Sorting
SUM & MROUND Formulas
How to replace the last digit in a cell with a letter
How do I set up data validation for Bank sort coes
Can you do this in excel?
Importing Data from Access
how to split one decimal pt integer off & to next columnin excel?
Microsoft Excel Traininh
Relative Formulae between worksheets
I don't want to run visual basic editer code after saving...
Excel Today() function
Excel back up files
Interest Formula
Offset, Dynamic range, Countif
Custom Format to divide by 10
how to connect visual basic with excel file ?
Q: date convert
Activecell problem
Creating a conditional format for a cell based on another cell's v
Columns showing up as thin vertical lines
How to remove a query prompt in Excel 2003
simple validation formula required
Many worksheets; Same formatting - Excel 2003
Customizing Worksheet Menu Bar question. Help!
How do I plot a parabolic curve from 2 data points in excel?
how do i move an image on a sheet
Office 97 hyperlinks do not work in excel 2003
Shapes
If Then's for 12 textboxes to check if they are empty.
Creating an invoice with a lookup list
How do I change the number of columns and rows in a worksheet
changing cell references
Sorting a-z | z-a ... removing pop-up "Sort Warning"
my Excel documents do not maintain landscape setting when shared
Limit of text in cell.
relationship between columns
Calculating number of days between two dates that fall between two other dates
How to make excel disappear!
Picture during Double Click
How do i do 3-D references in Excel
Using a named range in a header with VBA?
Formula Help Needed
Excel VBA Column
Autofit does not stay on.
CSV file containing german characters imported into Excel
Exporting to text, cells with comma's are placed in quotes. ->Bad
Data Validation - 2 items for the same drop box
how to input an ultimatum in an excel database...
absolute function - range
Saving excel document as a .csv and not lose formats?
Formulae extracting data from other spreadsheets
how do i multiply entire columns of numbers by a %
leading zero
Another linking question
can put comment in formula line?
How can I increase the character capcity of an Excel cell?
Cannot open Excel, message given is about VBA libraries?
Merge across - copy and paste
Import External Data - XML
Conditional Format #REF!
temporary use of excel settings on a different computer
Rounding for order size
Tab Name Shown In Another Sheet's Cell
perpetual dates
Excel, in a cell, how do i link to a pic & autohide like a comment
Can an Excel file be converted to a word doc?
Insert spinning button with time format in Excel 2000?
Sort by shade
creating a bar graph
cntrl + down arrow and null values in cells
Row Height
... I would like the Worksheet Tab Title to be in Cell A1 too...
Finding the last row in a spreadsheet
My Ctrl+D doesn't work, how can I reset?
How do I prevent changes being made to an excel document?
Problem - When couples have different last names
Deselecting Worksheets
Re: Recalculations Excel 2002 (xp)
When I click buttons I have added the font or button resize, Why?
linking two workbooks together
How to set variable to cell value in excel macro
Can I set up a calendar lookup for date selection
IF formula
Any way to count cells contining one, or more STRIKETHROUGHS?
double accounting underline
SMALL and LARGE
Rounding results to nearest quarter (in decimals)
Lookup value in cell and sum in two diff worksheets?
How can I line up 2 columns with similar information?
Pivot Table Question - a puzzler
Transfering a row of data to a template word or worksheet
Print Command
Re: Rounding results to nearest quarter (in decimals)
Moving Between Worksheets
How to look for a sequence of numbers in a string?
Sending multiple EMails thru excel?
Excel97 Question??
macro works for some users and doesn't for others
Open several workbooks in their own window
insert hyperlink in excel to outlook contact
Running Excel models across a WAN link
I want to match cartage rates to my dockets
how do I interupt excel 2003 calculations?
show blank instead of #N/A
get rid of recently used templates
how do i find where a drop down list is hidden so it can be edited
In excel how do I delete an option button form already in worksht
Finding constants in formulas
How can I extract automat. the email from a list of hiperlinks?
CPU Usage consistently above 75%
formula for if Cell c1 is yellow shaded cell d1 should be yellow
how to input a pop up to advise me about my deadline?
=?Utf-8?Q?link_ayar=C4=B1?=
Vlookup is not enough !!
Appen " ' " to all cells
Automatic date formatting
VALIDATION DATA IN A CELL
Hanging When saving to server
"Wrap Text" problem in Excel 2003 SP2
Excel 2003 Expert Certification
How do I subtract a date from a date for a sum of total years?
Sumif outputs values
How can I get an imported document to print whole page
change from copy & paste task pane (yuk) to c&p little box
Can all the sheets in one workbook all the same?
Excel loads slow
What causes runtime error 1004?
how many staff have 1 skill, how many staff have 2 skills, etc.
Add cells
Why is the Print Titles section grayed out?
How can I create a class reunion directory from a spreadsheet?
ODBC
Repositioning a cell based on its value
Excel Backup Files, shared Network
Sharework book problems
Need a "save & close" button directly on spreadsheet
Changing what is displayed in the formula bar
How do I reference Cell information in my Headers?
incremental averaging of data
Using CSV and quotes
Auto-adjust cell height to accommodate contained text.
keyboard shortcut for right click
range("a1").select not working
flattening aggregated fields in pivot table
i want to divide a cell into two subcells in excel
Using Filters
Open on specific worksheet
How do I display html code within a cell?
Displaying worksheet name in cell
How to hide freeze pane lines?
Expired date to show up automatically
Specialized Cell Formatting
Formatting Odd Number Strings
subtracting dates
Addition on "text" cells
COUNTIF
Copy from different workbook's worksheet into a single worksheet...
IF Stament formula nesting
How do I make hyperlink target scroll to the top-left of spreadshe
Checkboxes in Excel - Please Help!
can't get "sum" to add up properly
Inserting Rows
PIVOT TABLE FORMULA
Picture Names
Conditional statments.
Protection
Merging Different excel files into one
Johnson
Can excel send reminder emails on dates entered in a wookbook?
Limiting Validation entries to 2 places after a decimal
Type mismatch mysterious error
Change cell in formula based on date
Return activie cell indicator to column A next row down.
Macro to open print window and set to print entire workbook
How can a file with 123 extension be opened
Re: Macro to open print window and set to print entire workbook
euro converter
can i recover a file i accidentally didn't save changes
problems with SP3 Excel 2000, 9.0.6926 SP3
USING DATES IN FORMULAS
Help with error 91 please
AutoSave without editing, or calculating cells without change
recent template does not apper in the excel regedit
Find all roots of a high-order equation
Excel won't open it's a blank page, after password
Count by color using VBA in Microsoft Excel
autocomplete not working
How do I determine the number of cell formats in this workbook
Setting Tab Properties in Excel
How can I share information between sheets in Excel?
How can I share information between multiple sheets in Excel?
how do i set up a three dimensional table
How do i get pocket Excel to accept the normal range of formulae?
Excel inserted 0's in cells linked to blank cells
How to add picture based on a cell value
Calculation divisble by three
Excel 2000
data-> validation-> list
How do I add a comma to every cell in my excel worksheet
Can I use series of variables, in one "IF" ?
Moving thru sheets in Excel
'sticky' cell selection
Have Excel treat documents as Word does
Setting colors of results in a column
Linking many cells
Array Formula
Deleting Shapes
Items, when selected doesn't appear!?
for the experts
Why does my excel spreadsheet show ### in place of a sum?
hidden rows in Excel
Define Names in Excel
EXCEL - Concatinated Y-axis Label
COUNTIFs with multiple criteria
Inser a page number in MS Excel
how do I insert the current time (static) and date in a cell?
Intersection point in graphs
Spreadsheet links
external database to view in EXCEL format
Calculated Dates In a Heading
How do I print out a list of the tabs in an Excel workbook?
Ignore #REF! when adding columns?
again for the experts
Change the line of a chart.
comparing colum data and exporting
Summarising a List of Data
can i change the part of the data in a colum?
How do I record a macro with relative cell addresses?
Can i tell the cell to equal the pattern in another cell?
Changing language of an existing sheet
toolbar line see what you have typed
wildcards in formulas
calendar
Cells will not calculate
limit validation list to prevent dups
How do I list info from one worksheet to another.....
In excel is there a way to pick out certain characters in a cell?