Microsoft Excel Misc

the first in a sequence
Locking certain sheets
hide rows with macro
Changing Data In a Drop Down Box
Re: Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and
Excel as a reporting tool
Macros not recording
Extract Command in Excel 1
Delete a Table not in Current Database
How do I copy subtotals from excel without it also copying the det
Password for excel sheet
Granger
Percentage rounding error in charts
Why Excel crashes everytime a cell is entered?
Protect macros?
printing set-up
Any tips to reduce excel workbook size?
How do I display the 'Date Modified' in an Excel worksheet header
Why do Excel and Access freeze on the splash page?
Median in pivot tables
Key Assignment Log
Need formula to cal percentage of 2 numbers
paste formulas between workbooks without workbook link
How do I merge two cells without deleting data from the cell?
Printing from Excel
other newsgroups
enter data in cell which will start macro to move data to sheet2
export excel file as csv with text delimiter of "
Excel formula fill. Help needed...
how do you make text flash on and off like a warning sign?
importing a scanned image
How to auto place start/stop characters in Excel w/barcode fonts?
Paste Special
how do i enter numbers starting with zero in excel
pictures and text in excel
Protect/Unprotect Worksheet
Matching number formats
Automatic Data Validation drop down creation
How do I convert dates to text keeping the format?
tip of the day should be relevant, not vacuous: stripes & plaids?
Last Name, First Name extract
Can I transfer excel from one computer to another?
Re: Link
help creating average formula
combining IF and AND
Waiting for "Calculating Cells" when there is little to calculate
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet
Hiding and unhiding sheets
Excel Viewer Won't Read xls file!
Changing table border color
Vlookup student grades
sports score sheet
In Excel, how do I sort a column by the LAST digit of the data?
ODBC Driver/Import Data
How to display two spreadsheets next to each other
RE: how to separate words between blanks
highlight every other row
is it always necessary to open workbooks referenced in a formula
how to separate words between blanks
how do i enter a date quickly without using slashes or dashes?
How to I set up a sheet to print colums/rows on every page in exce
AutoRecover
can I export just the autofiltered data into own sheet?
How do I format a row depending on the value of a cell in the row
Email address changes
Macros and File Lost
why does my excel workbook keep doubling in size?
Need help with creating a combo box with a drop down arrow
Printing headers on all pages except the first
Multiple MS Access table sources for pivot table
Excel data "how so sort for use"
importing another file format into Excel
The merge center icon remains gray and does not work.
Save as .htm with filename from cell
How do I set up a macro to turn on Windows in Taskbar in Excel 200
Searching Macro
Calculating with named ranges
Window Position & Size
how do i find data in multiple sheets in excel
Macro that inserts lines reply
Macro doesn't work but recording it does.
In Microsoft Excel when print last letter of each line cut off?
Display formula in cell
EXCEL 2003 VIEWER SPREADSHEET DIFFICULTY
Search function
Saving a filter?
LOCK TIME
search
macro to start on workbook opening
Need to get slope of peaks on excel graph
Non-numerical data in a pie chart
error "module not found"
Formatting Subtotals
Userform question
SaveAS macro Query
Formatting Excel Worksheet
Re: Lock Column
Combining different sheets with automatic add in?
Re: Lock Column
RE: Lock Column
How can I make a login styled spreadsheet?
How to you lockout the comments in Excell from other users?
GRAPH data labels
Date Format Behavior
Excel Research Task Pane
Sort Macro: Utilizing ComboBox Selection for Key1 through 3 Ranges
HELP!!! combine 4 different sheets ???
Group Boxes - selecting more than one item
can i select from list by typing first letter of word?
Page Numbering problems
Match numbers in range
Template for tab not whole document
can I display the file name of the imported text file in another c
Comparing Arrays
Can not open spreadsheet from outside excell
Save a new file with the name that is in cell "C7"
Finding First and Last Worksheet Names
Translation: .123 file extension to Excel 2003?
Can I split a cell diagonally, with text in each triangle ?
Monitor memory usage
How can I hide formulas in a spreadsheet to send to a customer?
iqy and password protected web pages
how do I set up a database for client information
i've got a simple excel problem that needs solving...
Dollar SIgns in Formulas
consolidate data into one workbook
How do I wrap the table so it prints on one page?
numbers being entered show in formula bar but not in cell?
Training in Excel
French character lost during convertion
lots of data
change two lines of text data to one
Installing: Microsoft Excel Feature
Import/Export XML in protected worksheet
What does ! mean in the formula?
Combining workbooks with some variable field names
keep the formatting of the cell found using Hlookup
multi formulas in excel
How can I use a named range for "pick from drop-down list"?
Inserting rows in source workbook
How to copy a workbook so the buttons run the macros?
how do i increase the number of digits displayed
how do I download an excel template%3f
Saving Hyperlinks
Icons at the top are suddenly large. How do I return them to norm
Separating Names in a Column to Two Columns
Number of Multi-users
how to enter the date automatically?
How can i program excel to tab to selected areas on the sheet.
How do I sort a column consisting of fractions, decimals, and who.
Emailing a worksheet
RE: Auto Update Linking and Saving
RE: Auto Update Linking and Saving
Cannot Group Seven Worksheets, only Six
How do I print an EXCEL file on ledger size paper?
Disappearing Arrows in Excel
snapshot viewer print protection error
date format in Excel
How can I compare worksheets in the same workbook?
How do i retrieve a deleted excel file?????
How to Format Excel Sheet ToShowRowNumbers but not the column alph
How do I set up a drop down choice in a cell
Fill colour red
unique sequential number excel 2000
Macro that copy page to page just some filled cells
Lookups
Making MIcrosoft Word type from Right to Left
Open and Save XML
Invert Text
where can i find a merchant calculator?
How do I delete duplicate rows in an excel spreadsheet?
Cell.Find
Search and Replace
how to email one sheet only of a workbook
Re: Fill Color Red
get lowest positive number
In excel can you select certain cells which contain the same text
print report with data from specific worksheet
remove the watermark in Excel (2000) "Page1"
columns change width
How to identify a cell without a formula
Condtional format of row depending on string value of $A2 +
When I type in 100 a 1 appears, 10000 and 100 appear
Merging Excel Spreadsheets Together
How do I display hyperlink in Excel cell?
cannot load excel file - "too many different cell formats" error s
Excel 2003 and IntelliPoint v5.2
Background color on Excel Spreadsheet
Re: Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and
adjust column width
Re: Jesus said, "I am the way, the truth and the life: no one can come to the Father(God)(in Heaven), but by me." (John 14:6) This means that if you die without trusting in Jesus Christ as your Lord and Saviour you will die in your sins and
staff schedule in excel
mostly automatic input
How do I remove outlook headers from my excel worksheet?
protect a single row of formulas
confused by COLUMN worksheet function
new excel files not saving across wireless network
Form-filling application with Excel (background image)?
Printing objects on a worksheet
Can one insert a variable/cell ref. in the heading
Any Ideas
how do i delete multiple records from my database
Using named ranges in AdvacendFilter statement
IS THIS CONDITIONAL FORMAT
How do i calculate the time between 10:00 pm and 6:00 am in excel?
Conditional Formating
do you know how to....
Number Formatting
Julian Calendar
Best FOnts?
how do i "de-dupe?" rows by a column value?
How I can to extract a formula from other Cell Function?
Create a button to Clear Cells
COUNTIF Question
Using Russian Language in Excel
Stuck in Italics
Create a button to continue old macro execution
see the cells the formula relates to by double clicking the cell
input text at front of field that contains data
Automatic changing refrences to sheet corresponding to first day.
Add buttons for Center Across and Paste Formula
Suggestion to add ability to merge non-adjacent cells in Excel.
formulae
Make macro run when I hit the enter key
Hiding Rows if the linked rows are blank
Lost my install cd and therefore can't upload the statistics add-i
pivot table - Can I pre-define rows and columns?
Excell If then
Excel atuo filling cells- question
Column shifting when open excel
converting hyperlink paths
How can I link excel spreadsheets that work on other computers
Use the X button on a userform
excel table in a page of a word document, horizontally
copy exact values from RangeA to Range B which has extra rows
sumproduct if
Find cell contents in range
Default font for comments
excel calendar year resetting 2005 2006
leading zeros in excel
excel calendar years
how do I convert an excel spreadsheet to cif format?
return the column reference number of a function result
Matching cheque payments to invoices
excel calendar years
select workbook macro
Convert specific text to a corresponding number
Get the number of last row entry
Value from a closed workbook
What formula converts date to month only
Statistic Gathering
Formatting Columns in Excel
database criteria
pricebook help
Sharing worksheets between English and German versions
Change the base
How do you to keep formatting in emailed spreadsheet?
Possible to paginate a multiple page worksheet using Roman numeral
Removing Hyperlink
Vlookup sum
How can I translate a comment to text in a cell?
Importing Data from an Access Database Including a Hyperlink Colum
Issuing macro in workbook from separate workbook
How do I create consecutive dates between a beginning and ending .
How to set up a macro?
Delete all data (formulas) below a desired row.
Force content in closed workbook
Document email attachment problem - please help!
CountIf Function Help
COUNTIF
How do I setup to tab between form fields in Office Excel 2002?
"Allow users to edit range." Office 03 vs. 97...
Show comma in data validation list?
Multiple CSV Files Open Problem
Excel won't copy outside sheet
Protect data in cells after entered
Grouping in Excel on a Pivot table, need to be able to retrive ex.
Interactive Worksheet
How do I modify the spreadsheet to fit less rows per page?
excel 97
add email address to a list of names
How do i count the number of conditional formatted cells?
Setting Column Width on Imported Data
Is there a quick way to delete all duplicate rows in a column?
First non blank number in a row
Pivot Table for survey results with set of possible answers in PT's Rows Field?
How do I create a spread sheet w/a numerator/denomenator?
how can I embed fonts in Excel?
VBA Script for copy and paste to save
How can i find percentage and other xcel formulas?
SharePoint instead of Share Workbook?
Revert back to previous file version
help with formula
"file" cannot be accessed
Template question
Using "track changes" to revert to a previous save
Cell formatting when importing data
Sumproduct Wildcard
Puzzling Format Questions
track inventory
Combining Pivot Tables - Summarising data from 100,000 rows
how to autonumber excel worksheets as 'Page X of Y'
How can I format a cell to show different font color after editin.
how can I format to show different colour after edit
why must I open an Excel document twice to get it to open after .
sorting alphanumeric
How to format date as text without changing appearance?
Workbook name as variable to another workbook
Problem with running Macros
Hiding formulas in Excel 2000
Search and replace with Carriage return
Module
I need to protect all but one cell in an Excel XP spreadsheet.
Linechange in the same cell
RE: Link Link Link
Error Message - No more new fonts may be applied to this workbook
Numerals changing
how can I add 'date modfied' into a cell in excel 2002
How do i change info in all my cust cards in excel in one go
Shouldn't change hot keys in MS Excel in Vietnamese version
How can I change the default way pivot tables summarize by
Imbed Linked Word doc in Excel so whole doc shows?
Pivot Table for survey data w/ questions as Rows & poss answrs as
text box look up
workbook select
calculate the age of someone from their date of birth
Subtract a group of cells from a total based on ending date
Is there a template for username and password storage for Excel?
Keeping one part of a formula same, but change other cell ref?
reference sheet tab name in a cell
Special keystrokes in a Macro
Formatting of Pivot table
Separate Worksheet Linking
Formulas don't calculate until SAVE (excel 2000)
IF Statement nightmare
Error on start up...
clipboard in Excel collects but will only paste most recent item
how do i merge cells but not rows
Auto recovery
How do I restrict only 1 of 2 check boxes be checked?
sum cells based upon color of cell
"Merge Workbooks" not highlighted.
Can I change the tab order in a protected worksheet?
Combining numerical and drop-down text in a single cell
Pop Up Box
How to total items if they fall between a date range
Scheduling classrooms
RE: Changing Dates
chart problem
RE: Changing Dates
Sum from an indexed array/table
Function help???
Calculate numbers between 2 dates
UserInterfaceOnly
Calculating a rate for elapsed time?
assign value for period of time
Changing Dates
two lines of text in single row
how do I add time IE: 916:10+7994:37... if I have a long list?
preserving cell format between linked documents
Linking to access
Copy Paste of Formula Produces Incorrect Result
help with equation
In Excel, how do you create a multi page Invoice Template?
Reference a cell on another worksheet in the same spreadsheet file
countif
Extended Selection
cell outside range
Help with organizing data
How do I change a cell from absolute reference to relative referen
Drop Down Window in Excel
How do I link data from two different excell files?
Formula entry in Excel
how do I convert a UK date to a US date in excel?
for all of you excel experts
Remainder
Unselect Option Box
where can i find uk tax and national insurance calculations
Turning .xls form into web page
How to get to last column in a worksheet in XP
Automatic divided by 100000
Formula with multiple IF'S
Move a diagram from Excel to Visio?
AutoShape
How to move location of chart within a worksheet?
Can the contents of a cell be made to blink or flash?
IFSUM with 2 condictions
Show whole Table of Contents for Excel Help
Excel Formulas
formula w exception
I want a series of letters to equal a dollar amount?
Excel formulas / formatting
Inheriting spreadsheet from another user for budget analysis
Excel 2003 Slowness problem in Windows XP
Cell reference question
table
Permutation and combination
HELP PLEASE
Send to mail recipient (as attachement) is greyed out
Excel Crash - XP & 2003?
Trace Dependants
How do I delite empty workbooks in Excel
Checking Winning Numbers in the Lottery.
Can i turn off the debug side of Excel?
How to Round Whole Numbers?
Sumproduct and list of dates
how many characters i can put into one cell in Excel
What do i enter in the server textbox to access olap?
How do I disable the ActiveX Control prompt?
open a new word document
Excel Worksheet Limit
Lookup Tables with linked sheets
Option Buttons - groups
Creating a cell so data goes into a table
a protected cell w/formula only updates only on file save?
How do I publish Excel as a webpage so macros work?
Macro-Save as
changing currency from Dollar to Pounds Sterling
Using SUMIF on common words
Excel
Auto-Filter in Excel
Can multiple cell results be displayed in a single cell?
How can this code be changed
Recreate the upper part of a symetric data matrix 75x75
Input cell information
Keyboard command to replace double clicking the fill handle
Excel VB-Copy formula down until adjacent cell (left) is blank?
RE: Changing font from lowercase to uppercase easily
Print titles must be contiguous and complete rows or columns
RE: leave cell blank
How do I show all the contents of a cell?
How Do I Print 1 Envelope from copied excel Cells without using Wo
Excel license renewal?
leave cell blank
Changing font from lowercase to uppercase easily
splitting the values from one column into two
Word document embedded in Excel 2003 won't wrap
Date last edited
####### within a wrap text cell.
Yr to Yr comparisons
how do i use the excel symbol toolbar?
Spreadsheet Creation
Tab key skips to distant cell instead of next cell to the right
autoshapes
Using IF Statement
stop my speadsheet from creating an automatic backup copy
Draw tool bar
can I express X*4 in a formula?
Macros in Excel
Adding Futura Bk font
Error can't empty clipboard appears when trying to copy.
How to bold daily max values
Error can't empty clipboard appears when trying to copy.
microsoft works suite 2005
convert excell docs
How can I password protect a folder?
HOw do I enable autosave in excel 2000
Installing Components HANG Error
how do I number a form for repeated use?
Organizational Chart
How to Perform Lookup on Alphanumeric Data?
Password Prompt
I have a live data feed that updates a cell all day. Can I graph?
Excel startup switches
Macro to open specific File
Excel Inputbox
Default Template in Excel 2003
How do I merge many identically formatted worksheets into one?
* * * Important Please Read * * * May 18, 2005 4:07:32 pm (Best Viewed at 1024x768) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
adding duplicate text to multiple cells
Macro - Feeding path and file name to PDF maker
Excel 95 vs. Excel 200x
How do I link several cells in a row together & sorting
Is there any way to use gridlines in the Excel Calendar Templates?
Users suddenly able to modify the same documents at the same time.
filters
need to populate several cells based on drop down menu selection
Solver
Vlookup Help Needed
Look up or add-ins
two lines of text in a single row?
worksheet
dynamic summing of an autofilter 'ed table
How do I find out if I have Office 2000
How can I make online paystubs?
Excel disappeared
Assign a dollar amount to a corresponding number in a range of num
Where do I find the Payment Request Wizard in Outlook?
Hyperlink display text maximum in Excel 2003
Goal Seek
Change Colour OF Text???
How do I insert a comment when the Insert:Comment menu is greyed?
formula
I would like to extend hyperlinks across cells
ISTEXT
How to shade every third row?
value error
slight variation when working with separate worksheets
Vlookup Multiple Returns_Answers
How to solve problem (equal to 0) with unknown value
Solver problem
Excel 2000 - file won't open
Excel
can't right-click
formula not working
short cut key
how do I merge 2 cells in excel without loosing data
how do i change order of columns in a list published to sharepoint
changes and passwords
Help me solve this calculation
Automatic calculation
Problems with external references when creating a drop down list
increase cell 255 limit in excel2000 help or way round it?
select part of a cell value string
File too large for Excel?
Count If formula
How do I limit the visible rows in Excel?
linking selected data between Excell sheets
SendMail Question
How do I delete the page watermark in the page break preview?
Question about XML functionality (add-ons?) in Excel 2000 & 2002
> ???
Locking Code In Individual Macros
search to identify duplicate enties in long columns of numbers
Preventing Duplicate Cells
Can you transform an excel document into a word document?
import a 123 file
Create view using data autofilter
Excel training
How do I save an OLAP connection to distribute with an Excel sheet
fill handle
hOW DO I CREATE A TWIN BAR CHART?
Does anyone have a chart for tracking Attorney's CLE?
Character limit per cell
Help! Formula Needed
water marks
When I type 100 EXCEL changes it to 10. Why?
spell out state name from an abbreviation
Better suited for excel or access
SumProduct - Value ISN'T equal to
how do I share an excel file using the internet?
How do I stop VB buttons from moving in Excel after printing
I'm always coming up against this!
can excel do Monte Carlo simulation?
Formula: Date plus 3 months
Link Data
What is an automatic way to delete all rows of a certain kind
text (3750 char.)truncates with text wrap and row heigh adjusted?
RE: Change spelling check language in Excel 97
Formula Question
Easy template for media contacts?
Increasing M in M/D/Y
Search a cell based on format
Link a picture to data
Exotic Bets Spreadsheet - Need Help!
Can I Delete Symbol in Cell That Has A Formula?
Multiple IF formula
how do I convert an Excel workbook to .txt or .csv
Scrolling with Mouse
Some text shows in the formula bar but not in the cell.
Need help with automatic date entry
#VALUE! error adding cells
lock out
automatically opening workbook
Column Auto Width and Hidden Rows
Formatting Auto Shapes - Rectangle
how do I set up a sales pipeline spreadsheet?
How do I change the color of my row and column headers?
How can I blank a cell until a ref cell has the correct data?
Making multiple cells absolute at once
Excel to PDF conversion in VB
Text cells in excel
Landcodes in column A transferred to Continent codes in column B
edit number in cell without it changing to text
How do I continue a formula in an inserted row?
Unable to record macro
Keep find box open while in spreadsheet
What is the general Count If formula?
I need Vlookup to return a blank
microsoft date and time picker control
excel 2003 questions
Is there any way to get rid of a link in a spreadsheet?
If statement with date
Rouding up times. e.g. 7:33 --> 7:35
Web Queries
paste over hidden cells
Restricting a workbook to a single computer
Macros for find and replace and then joining columns
SIZE OF SHEET
Returning Sheetname
Excel 2003
HOW DO I KEEP DRAWING OBJECTS ANCHORED?
can bin range for histograms be on a different worksheet?
Another Formula Need
Does Excel 2002 have a List>Create List option under Data?
how do I highlite text within a cell (specific characters)
#REF!
Configuring a cell to take higher values only
In excel the formula bar behaves differently on different machines
Splitting a single cell
Data Validation - mixture of options
copy excel paste to word
Excel file into Word
Can I convert a column into a row?
how to auto save in exel 2003
Removing Print Lines
Link to Workbook
userform for spreadsheet
How do I get a cell value using another cells value
excel hangs when copy 'n' pasting
In Excel, look at a date field and return just the month..
Restore the auto save function, it was a life saver.
reference to other worksheets in FormulaR1C1
Books or websites for Functions
Importing from Access issue
Copy Page Setup from Sheet to Sheet?
XL2002 Clipboard doesn't paste formulae
How can I transfer a Utf8 file from word to excel?
excel template won't download
Page scaling & Page break preview prob
Any insight into cause of Autofilter buttons to stop working?
Highlight entire rows as I scroll?
Ghosting Out Cells
Updating Excel spreadsheets over the Internet?
how can I protect workbook on a drive from deletion
Internet explorer is very slow in opening Excel Pivot Table lists
Printer Selection
Need help formatting cells
Q: age column
ERROR: Too many cell formats
Exporting from Excel to a text file
How do I build a Macro that can identify wooksheet names
Re: Delete Row syntax conundrum
Simultaneous Excel backgrounds....
Add numbers accross columns after stripping away text
Pivot Table with Text
Grouping and Objects
solver
worksheet protection
Is it possible to transfer info between worksheets
Lists
external data
RE: Duplicates
eXceL 2003 - list or combo box question
Duplicates
Is a Drop Down box the best function to use?
When I open a file, Excel goes to Groupwise Lib
Spell Checking - Special Words Not Picked Up by Excel
Calculating the Area of objects in Feet and Inches
Cell Reference in Header
Wrong date on my posts.
Excel Range Names
export data into Oracle table
Copying Data From Internet to Excel
How do I reduce the range of a saved worksheet?
How to get two instances of Excel
Macro running problem
How do you change the column names in Excel?
Word Automation - Find/Replace
Search order
How do I save an Excel file in ASCII?
Need Quattro Pro download to convert a QPW file to Excel.
How do I make a cell appear empty when the formula = 0?
Hyperlink to email address with attachment
Round down for time
My spreadsheet has a control box. box moves after printing. Why?
Ranking
cell automatically turns colour??
prevent duplication
Sorting
Import query from Access
how do I add sum function to the toolbar permanently
using COUNTA
Change result of Macro Recorder
Why can't I save on CD in drive D
Sheet 1/2 to be available in EXCEL
Excel as a database
Display a greater number of recently used spreadsheets on File ta.
Save as Web Help
How do I lock a radio button group if a N/A button is selected
Hiding Column and Row Bars.
existing excel file when clicked opens blank excel document
Using one table instead of another?
Replace multiples from a list
wrap text/row width adjusted - no text
Duplicates - How Place
Subtraction Question
Pasting data without removing formulas
text formula
color of a cell within a nested if function
Font size prints same size regardless of how I set it in Excel
How do I locate the Exploring PowerPoint folder in Word & Excel?
Allow Excel to retain HTML hypertex done from another editor.
How do I return the cell address of the largest of a set of values
Is there any way to use the MATCH function with more than 1 column
Excel 97 problem with access
search after values
calculate the sum based on two different criteria
How can I wrap text within an Exel cell?
Subtraction question
Pivot Table Formatting
"00098" to appear
Active row and column header color
zeros in cells
Guidelines?
How do you turn off automatic "save a copy" in Excel
Trouble with formula
Is it possible to count if within a number region?
Expense report template
Beginners OLAP
How to convert date to text
Stationary Column
Charts in Sheet
Formating Text in a List Box
opening excel files with links to other data sources
No Subject
No Subject
No Subject
No Subject
No Subject
No Subject
No Subject
No Subject
No Subject
Conditional Formatting
Need sberet.msi file after installing SP-3.
excel general questions
Adding in another conditional format on the same cell
Formula input error help
Date format
linking data
formula result not able to be summed
Placing a toolbar and it moves
how can I convert a XLS file into a CSV file
internet data link using wildcard
Sort.....
adding rows
Data Validation - Create dependent lists
Substitution
Excel and Delimited File
Spinner
how do i map an excel column to an XML element
Refreshing a pivot table
Extra Columns
Shift+Arrow does not expand selection
School-boy secret code help needed
add same cell from all files in same folder
How can i stop same data being repeated in a column
Colored cells are showing white on screen, want to see color?
writing a formula