Microsoft Excel Misc

date
Change pivottable datasource
Max worksheet in workbook
Formula for current month minus one = Quarter number in a macro.
Merging Pivot Table Data
Bullets
Select values from list
Custom format
Importing from Access
Conditional Formatting
Finding unnamed cells in a range
working with dates
Unable to create any link/hyperlinks in a particular excel file
Search between two dates
Text to Columns from drop down list update
Print preview is not available in Excel only. help
Negative number formatting
large numbers not losing the end without formatting column
conditional formatting on specific text in cells
Help - Need experts help!
recognize the cell
merge/extract data from identical worksheets in a workbook
Conditional formatting.. how do I copy cells?
Returning the Row and Column titles of a certain value
VLOOKUP question
Upgraded to office 2003 now cannot find personal.xls
Drop down list
Cell shading problem
Big Sum
Using a validation list drop down box with keyboard only
combo box named range
How do I calculate the Root Mean Square (RMS)
mouse locked
Input boxes in excel and MS Query
How do I convert works file to excel without works software?
creating a list from a column of semicolon
Input period, but get .+
Time restricting a file
conditional counting
Pivot Tables
Calculate message
If Info. from one Sheet matches, send it to another sheet
I can't see the data (###) in a merged area?
Sorting while grouping 3 rows together...
Returning a value if data is in a large list
Empty space around charts when copying
how to lock a row so that it stays on top when scrolling
How do I print an entire workbook w/diff orientatns to Adobe PDF?
Sum cells in different colors
how to freeze only one row
Search/Extract Data w/in Text File
Comparing Two Columns of Text
corresponding numbers and letters
Pivot Table - show items with no data
V-Look Up
Good Excel VBA book???
fix for worksheet limitation
Links between sheets
Some Cells Not Working
HELP! I KNOW U KNOW HOW TO DO THIS....
Excel saving problem
Sort a Subtotalled List?
Conditional formatting on named text field
How do I keep formats (eg.color) when making a relative reference
Counting Question
control command
Frequency of occurrence
Rounding
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000.
HELP - Room booking spreadsheet hell
how do I make a table from expoted data?
Can I create and save a formula for text fields?
Copying A Spreadsheet
percentage not working right
Office XP Web Components supported by Office 2003
Deleting specific records
softball standings
copy and paste
adding cells with text and numbers
how do i import multiple data sets at one time?
SUMMING COLUMNS IN DIFFERENT WORKSHEETS
Concatenation query
User forms "back" buttons
conditional sum and macro
Excel spreadsheat to track homework assignments
how do I prepare a excel spreadsheet to track homework assignmen.
Excel-copy first row onto each page ok but not last page How?
Set Multiple Print Areas
Comparing value in two different files
Extract Unique Values, Then Extract Again to Remove Suffixes
getting stock quotes
Re: Exporting excel to text file
Error in EXCEL OLAP Cub
Way to Link Tab Names
Need Assistance: Average/Remove Duplicates
Pointers??
TextAlign in Combo Boxes
ROUNDED NUMBERS IN FORMULA'S
field validation
Format question
SUMIF function
Currency to Text
Seperating duplicate cells
How to Blink a cell in Excel if negative or red colour
Prevent formats from copying
Printing in reverse order
Auto installing software
Importing CSV files
sorting issue
It formulated, but it's not functioning
Sharing Error
Search in Excel
why do check boxes move when printing excel spreadhseets
help with if formulas
Refresh all pivot tables in a workbook
Automate a macros when data in a cell changes (e.g.when using quer
Sumif help...
alternative to msgbox
Change colour of worksheet tabs in Excel
Excel- Saving only unhidden rows
Total Questions
sorting date " MMM-YY" (Jan-05)
UserForm Data to Spreadsheet
Too many arguments, IF only I could sort it out
Print area will only go up to 101 pages
I want a blank space on a worksheet when the question is blank?
How do I find and replace a symbol in an excel spreadsheet
Required fields
Data Validation
Excel 2003 Add-in: Access Links
"Send to Mail Recipient" icon not working
Excel-how (find/replace) for multifmat cells w/o changing fmat
How can I compare data on 2 workbooks
Multiplication in one cell
Copying Filtered Data
Data Connection wizard quits working
How do I remove an e-mail heading from an Excel file?
Finding middle value
How do I display a dialog box that pops up when you first open exc
Finding Values With more than 2 decimal Places
populate fields with macro
Want listbox to move when scrolling down spreadsheet
Percentage Question
Insert text in a cell with a macro
Deleting both duplicate records
Extracting last 5 characters from a cell
IF FUNCTION...SHADE CELL
Can you allow cells to be merged under a protected worksheet?
Is there way to enter multiple values into excel cells w/ a form?
macros in excel
Sumif?
when word is typed in cell, how can the row auto displays data?
Conditional Formatting
How do i make a macro "relative" to cell?
Macro to pause for user input in dialog box
Can I fix the exponent in scientific/engineering format?
Date depentdant cell additions.
LOOKING FOR A NAME, THEN SUMMING ALL VALUES ASSOCIATED WITH NAME
ifsum
Macro to sum lines-HELP PLEASE!!!!!!!!!
Simple question: Difference between two dates?
What happened to Pivot Table "Show Pages"?
Excel formulas
Page Breaks
"Links cannot be updated" error
Runtime error for macro that works in workbook created in
clickable buttons
find and replace
Excel Sort
Drop down menu help
How can set up Excel to be able to print checks?
Workbook Protection
How To....
Adding Stock Quote to EXCEL
VBA Question
Copying and Filling Cell With Functions
Sorting alphanumeric
Formula needed
How do I change column label from number to letter?
Time as number
How can I set a default font for a comment in Excel?
Search for most recent date from list of dates
XL2000: "Filename is Not Valid"
Can you Find and Replace values with in a formula?
expert with formulas needed again
calculating time/dates differences
I need an excel plug in to save workbooks in adobe acrobat format
How to copy subtotalled cells to a new worksheet (in a macro), wi.
Shadow/duplicate excel file .xls:2
Cell always equals 'C: regardless of computer
Import wizard limitation
Wrap Text from one cell to another cell
adding scroll bar to comment boxes
Count values bigger than cell
Automatic Date Update
Re: Exporting excel to text file
Sorting from a list with data on different cells
Excel - saving file
Re: Automatic Date Update
Re: Automatic Date Update
How do you sort a date range by month?
dropdownlist- I want user to choose a # but can I add definition
Excel Save As... text with special characters
cannot open a file
converting fractions to decimal
exceL NOOB needs help w/sales tracking
I deleted MS Outlook from my start menu, now EXCEL won't work?
go to - special - visible cells only - takes too many key strokes
Protecting Workbooks in Excel 2003
word wrap question
Drop List
How do I make a column in Excel into two columns for only A3-A8
totals
I need a template to track expense + VAT when building a house
Conditional Formatting
How do I calculate the Root Mean Square (RMS) of line of equality
Pivottable
Making list of items to truck monthly usage
Slow print preveiw Excel 2003 SP3
apply a formula to multiple cells
FORECASTING SALES (please let this be a worksheet function)
java message with VBA
Show minus figures with brackets
Protecting single cells or a range
Visual Basic
Background changes conditionally
How to link cells?
When calling a different file, can I make the tab equal to a cell?
Reference cells from another worksheet problem
Is it possible to use 'grid' as a value in vb to process XL data?
Spoolsv.exe & csrss.exe services
Date Formatting
date Format
Date Format
How do I print excel document duplex (double sided)?
Logical ELSE statements
Creating a link between cells in two different spreadsheets
drop downs & data validation
Possible to view spreadsheets without scroll bars?
Pasting mutiple paragraph text into a single cell
Sorting in Excel
Report help
Printing issue
How do I stop macro alerts for a spreadsheet with no macros in it
Synchronizer: in my opinion, best diff tool for excel.
A pivot table report cannot overlap another pivot table report.
Move page breaks
How do I un-embed images in Excel and save them to another folder.
Excel Autofilling to 65543-need macro correction
Printing/Displaying File Properties
Workbook Headers & Footers
Comment Box
Last Column(=spaces) is Dropped When Importing from .Txt file
graph with one column and two lines
How do I use flash drive in Excel.(selected drive is not in use)
Copying font and pattern dynamically
Changing default font for copy / paste
Open Excel files/folders
need to increment value
Text Alignment in Excel Cells
Formulas
Opening Files/Folders
Stacked Bar Chart Over 100%
Format numbers / Concatenate
shortcut to scroll to last cell in row or column
In Excel, sorting columns automatically by clicking column title
Asking Excel Solver to use binaries, but selects other values
how do I forecast a 15% increase over 7 months?
Getting message can't save all data in excel xls file
Is it possible to make a Button on a tool bar to launch an Add-in
Continuous page numbers in workbook of multiple worksheets
Put comment directly in formula
Regression with more than 16 variables
Read-only problem
How do I find duplicate entries in Excel
Date dependant values.
GRAPHS PLEASE HEL
How do I change data that has been entered in a column to a row?
VBA to set AutoFilter to List all rows with same values in column?
Visio Text (Number) Automation
Social Security Numbers & Leading Zeros
reference to a bimonthly date
How do I only calculate cells which have a filled color format?
Referencing
Refresh Imported Data - Does the Excel file have to be open?
Can I set up a formula to lookup a value for a condition
Populating another tab.
Has anyone built an Excel spreadsheet to calculate churn?
opposite of IsNumeric
Pivot Table Sort & Top List
Why does excel grow to 34mb with 2pgs, no pictures and autoformat?
Phone number format from 000.000.0000 to (000)000-0000
data validation lists
How to get a listbox to move when scrolling down spreadsheet
named range, data validation: list non-selected items, and new added items
Why is "send to mail recipient as attachment" greyed out in excel
Adding a line after a date
Simple Simple Excel usage question
CVS file won't open in Excel 97, Help Please!
excel file .xls
if statement with text
Why do pivot tables not read numbers that are copied and pasted
mileage reimbursement formula
Formatting problem
Linking cells in a worksheet to other worksheets in a workbook
formula to return certain cell
Excel validation drop-down: how show codes with descriptive info?
How to display multiple pages on one large monitor
Showing 3:54PM instead of 3:54:03PM
Adding value to drop down list
Can I freeze multiple rows?
Re: Adding value to drop down list
Answering InpBox prompt
Sort by 2nd word in a cell?
scrolling in VBA editor
Help replacing text with Yes or No
Help
windows explorer will not open an excel spreadsheet.
Automatically put negative sign in cells with positive numeric dat
Remove middle initial from "first name middle initial"
How do I create an Outlook distribution list from an Excel column
Green Triangle in Cell
Counting Rows/Columns for Copying Formulas
How do i open a file in a new version of Excel
LOCATING A CHART SAVED IN A WORKBOOK
how do I count cells with only red font?
a data entry form with combo box
would like to know the formula amount and display word
Re: a data entry form with combo box
how do i save excel workbook every 30 seconds.
return decimals only
How to change the order in which excel addins gets loaded?
How to apply survey weightings
cannot open an xl97 file
how do i get answer is 1 from CELL("color",sth) function?
Protect multiple worksheets
Data Validation
Merge cell & Copy Data from different cell
USA to UK Dates
how, in excel, can i generate a number, eg consecutive order nos
Combo Box Moves
Export html page to Excel - support files folder
Background colors are printed but not shown in normal vieuw
Two Excel tables in MS Query
Convert data from rows to columns
Macro to link Sheets to main workbook
macro/new sheets
Hyperlinking to Many Pictures
Why is font so small in the autofilter dropdown
Reports from rows
Printing one column
HOW DO I ENTER SAME DATA IN EACH CALENDAR DAY AT SAME TIME?
Repeat statements "x" number of times...
offset a looked up cell
Excel macros should be able to record pauses, thread.sleep(23489)
PivotTable and column widths
RE: How do I type 24 square metres using arithmetical notation
How do I automatically generate dates?
Graph formats after updates
How do I type 24 square metres using arithmetical notation
IF formula question
Fit large amount of text in 1 cell
Conditional Formating in Excel
Clipboard
Zero Suppression
Debra Dalglish
How can I move Project tasks into an Excel outline?
Page Numbers in worksheet background
External lookups won't load
Need to convert Office 97 Excel doc to Office 2003!
Formatting
exporting excel to csv large fields save as "####"
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
How do I save a filtered subset of a worksheet?
Re: virus scanner has blocked this file
How do you make the little autofill box in Excel go away?
Formula to always point to C drive (peer to peer network)
Cell data overruns into adjacent cell(cells).
templates on network drive
Getting Excel to treat merged cells as one cell when printing
Why won't pasted values from a formula appear in a pivot table
hyperlink greyed out on shortcut menu in Excel
Excel showing old or new version of file for 2 - 3 seconds
How do I stop automatic insertion of rows in Excel?
Concatenate Countif formula for VBA fill-in
Copying Worksheet
Moving Files in Excel
how do i get excel to show mm/dd in Funcation bar
Opening Attachments
sorting question
Locking down worksheets
Working with Pivot Tables
Printing
how do i get excel to show mm/yy
Conditional SUBTOTAL
How do I copy data in single cell format to a merged cell format
How to remove duplicate entries in column?
Elimate year (either YY or YYYY) in data
How to post sample data to this NG
Using VLOOKUP to draw data from two columns
How do I unlock a cell in a page set up for pricing? changefactor
How can I work with more than 15 numbers
naming .xls file based on a cell in excel
export access to excel. change access & update excel at same time
Excel: how to merge data from 2 workbooks with 1 col. in common?
An array formula to sum row max
How to change the return of a textbox from TRUE/FALSE to YES/NO?
Search Range for Criteria in given cell and produce results
How do you control scroll rate when click and drag to select cell
print button
extract comments
Use checkboxes with linked external data?
prevent Excel from pasting icon when it starts
Excel Simple Calculations help
I want to set up a form in excel where I can place a jpeg or pic.
concantenatring 2 cells with with a line break
How do I copy a formula/paste w/o losing the cell content?
Copy from merge cell
If I change page margins headers don't line up???
where to find engineering drawing symbols?
Conditional Formatting
How do I link a picture to a text cell
Column additions query
Selecting a filepath based on cell contents
Copy and paste
horizontal page breaks
Custom drop down menus
HOW DO I TOGGLE FROM FIND AND REPLACE TO A CELL EASILY?
Excel 2003 Slow Function Argument Window
Scroll the screen view with the scroll bar
Copy from 1 sheet to another
How do i copy a spreadsheet with the formulas?
How do I create a form that can be filled in on the computer
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response
Colour Banding in pivot tables
customising the Excel invoice
open data excel w98 on xp program help
AutoFilter toggling in VBA (How to use correctly)
How do I produce a number in parentheses?
Words wrapped differently on screen and on print preview
VBA IN EXCEL
move page up and down in Excel?
Sorry, my clock is off
Moving rows
Hyperlinks to network files
how do i import a file list in to excel
Opening Excel spreadsheet in MAC
merging cells and maintaining the fonts size of each cell
how do I save a column to a file (in ascii format)
Workbook Protectionand stiil use Comment function
Autocomplete numbers help pls!
Book
Subtracting lunch breaks from different shift times
Excel File fonts
Macro Recorder-Relative relation
ActiveWorkbook.Protect password:=range("rangename") does not work
Link between similar sheet
How do I resolve too many different formats in a spreadsheet?
clean characters
Strange behavior w/ Text, Button, & Check Boxes
Sort a numeric field
I want to email only 1 page of my excel sheet how do I do that
Obtaining information from a database for a worksheet
Excel to Html
Can Excel reveal factors for success?
how do i create a quiz using excel?
How do I omit/prevent "" in tab delimited text
Conditional Formatting
Copy cell values across separate sheets
Completely Locked Out
Scrolling chart
LinEst with operator
Update Links to current Directory??
reverse/manipulate order of numbers?
stop highlighting cells when launched
Lookup question
Select Text Files from Combobox
Excel 2003 crashes loading excel files created Excel 2000
Macro Button
Begineer with (seemingly) hard problem
i have a document i need but i don't have excel
How do I convert excel file into ASCII text file with alignment?
Newbie - needing advice on formatting webform data
DFS RENAMES MS EXCEL FILES TO ALFANUMERIC!!!
Zero with a slash
Re: Calling a common XLA Library file, stored on a network drive :)
Conditional formatting of date
Executing of excel Macros.
Clicking on restore window button changing the freeze pane in exce
the attribute "nullable" is not supported in convert excel to xml
Active sheet
VBA Function to explode string
Extract sheet name/number to cell
Making pick list conditional on selection from previous pick list
Numerical characters in a cell
Spell checker
Deleteing empty rows
Conversion of Dec numbers to Bin, Oct and Hex and visa versa
How do I insert currency symbols in Excel?
How do I input currency symbols in Excel?
2005 Excel User Conference
How do I find replace special characters?
calculations across sheet and other workbooks
Use of Now() in Excel
how do i read an 2000 office Premium Excel file? I don't have the.
A small problem for you but big for me!
dynamic range
Protection issues
Suppress Zeros in a Pivot Table
multi function cells
sumif help...
what is the max no. of nested Ifs can an If Statements have in EXC
Hide columns
Counting blank and filled cells within a range.
How do I set up a cumulative column, without entering it manually
"Arranged" files scroll together
tab order
Combo boxes and Protection
use replace command to change the contents of formulas
Excel not detecting that a file is currently being edited
Bob Phillips followup question on text macro
Re: Next Cell
Can anyone give me the equation to convert watts to Decibels?
Social Security Number
Cannot change formats of cells???
Formulas stop calculating
Get Msg "Cannot shift objects off sheet" when hidng columns" Why?
Protecting A Workbook from being saved/written over
Very easy question about filter!!!
Different display for same file
Convert Social Security text to number?
transpose 3d cells to a column in single workbook
hyperlinks
Dash in format
Merge cell values
Message Box "Value"
Sub Total Cost by MFG
turn a column into a row or visa versa
adding worksheets together
Windows Explorer maximizes over XL 2000, if opened w/ explorer
Conditional Format for Numbers
DateValue & Vlookup?
How do I format the tabs of a worksheet in Excel?
How do I do a search and replace in a textbox in Excel?
Pivot Table with two row header?
Time stamp in Excel Sheet
Linking Excel columns in two different excel programs
Conditional Formatting options
RE: Comment position after filter
automatically open .txt file with all fields as text?
Is there some way to pivot nested tables or subtable in excel
Jump to data in a list as first letter is pressed
Vlookup Multiple Returns #REF
Excel Charts and Restricted Permissions
Re: Comment position after filter
Excel Documents in Windows Taskbar
Time and Invoicing
Question about formatting addresses
make excel files executable
Downloading from Bloomberg!
External links
Set a password in Excel that changes after after a fixed time
sort numbers based on initial digit.
Reference cell contents
routing slip
have put a passowrd onto an excel file and now cannot remember it
IF NOT or IS NOT function
COLUMNS IN EXCEL
data validation
IF NOT or IS NOT function
How do I get a field in excel to auto complete with a check mark
Template Wizard with Data Tracking
Excel sheet not loading
excel timesheet and drop down boxes
Password protection of Excel Sheet linked to Bloomberg Data
Completely Stumped
CUMULATIVE ADDING IN A COLUMN?
IF NOT
Compare dates (one cell not in date format)
Excel2000/2002 migration problem
Countif(table;(">"&A1)&("<"&B1))
Change the input in a sheet by OptBox
where can I find a excel based questionnaire template?
Calculating working hours
how to copy old price data onto new stock list if match exists?
Excel - shellexec error: 2
Averaging
Data transfer
Date sensitive cells
How to create a line chart with two X-axes in Excel
ADDRESS function - dynamic input cell
Find text in cell, copy row to new sheet
Disperse one worksheet into several...
Problem printing more than one copy in excel
password protect individual worksheets
Fatal Error!!
MSCAL.Calendar
Error Message on some files
Automatically clear values from a range of selected cells
vlookup??
How to show 2 MAX values in a list
Date/ Phone log
Tab key moves
Need help with macros
Convert xls files
How do I transfer macros in excel between two computers?
suddenly when i use formula it just show - or 0
End Of Excel
change column name from letters to numbers?
Conditional formatting
conditional formatting
Excel97 faster than Excel2000!!
dynamically enter name of last modified by in spreadsheet on save
How can I resize columns and rows to inches?
formating military time
Page Numbers in Excel
Conditional formatting font
Averaging/Rounding Equation problem
Text in cell
Export from Access
File Association
How do you format a sheet to fill the entire page to print?
rotate rows and columns in a spreadsheet
Formulas
LAPTOP KEYPAD
Filtering
Data Validation with Formula
Percentage function formula
Creating Relative Links in Excel...
Combine to Sheets...
How to convert numbers to corresponding letters? Ex: 123 to abc
How do I find an unknown value on a line made from known data?
Number format for Combobox
Excel error message
"No more new fonts may be applied in workbook" - but not adding ch
Help! Formulas
Template for Excel to keep running record?
Merging data to one cell from many
Jump to the item in a list as the first letter is pressed
Mail merge works with Forms but not with Labels
LARGE function does not segregate between identical max values
reversed columns
how to create this formula please
I need to add mew rows for different spots.
Formating Latitude and Longitude co-ordinates
How do I Select Multiple entries from Valid list for a Cell
How do I maintain my date format, when I copy a sheet, in excel?
how to create multiple hyperlinks within a dropdown list
Problems using Excel 2000 to open/save file saved in Excel 2003
Show Filename Only in ComboBox Pulldown
burning hyperlinks on CD's
How do I use an Intellimouse to scroll listbox enteries in ExceL?
Matching contents
Custom cell format problems
Re: Exporting excel to text file
matching contents
Pivot Table
Opening a file and enabling macros automatically
Issues with sorting
How do I create a command from a list box
Background Printing
Prevent Excel closing all workbook instances when clicking on "X"
Removing shared workbook protection
Names and Subtotal in office 2003
How to calculate the day before last two working day of each month
How do I use <= in a lookup array?
help:missing data in excel
SUMIF using two columns in both Range and Criteria
How to increase the maximum rows in the worksheet?
How do I automatically update a chart range in Excel
Format date in excel 2000 like '31st January 2005'
Format date in excel 2000 like '31st January 2005'
Format date in excel 2000 like '31st January 2005'
How to compare two tables in Access 2000?
Password Protecting
Returning the formula in a cell
Format date in excel 2000 like '31st January 2005'
Format date in excel 2000 like '31st January 2005'
Formatting Cells
Format date in excel 2000 like '31st January 2005'
TEMPLATES
Data Validation does not work when selecting another cell.
Sum filtered values only
can I use the 'fill color' as part of a formula
Recalculating Formula - Getting the wrong answers
Can you calculate no. CHARACTERS
Short-cut for Paste Values
How to Replace Numbers with Phrases
How to Replace Numbers with Phrases
Startup macro
PDF hyperlink issues
background color
Formulas Translator Tool
paper size different in different office
Help wit text in formula
font size in a drop down list
2005 Excel User Conference
help with sumif to calculate column
How do I convert a column from USD to GBP
Lost Toolbar / Right click disabled
break links problem
Shift/Control Key locked
Spinner Button Reset
last digit in string gets changed to 0 (16 characters long)
Password to open file
Using data forms
file save as
Hiding Non-Duplicated Entries
If and Or statement
Page display is abnormal
Help!
Is there a keystoke to navigate between worksheets in a workbook?
Sheet Protecting password
Slight Problem
Open file
Removing link to another workbook
Formatting number cells
copy formats column width & row heights between Excel WORKSHEETS?
Find a net in a column
retaining fonts when placing excel worksheet into pagemaker?
Increment dates
Want to auto hide rows in excel when no data in a certain column.
How can I convert a formula to a value in excel?
Opening two separate instances of Excel
Delete row depending on criteria
beregning af tider med negativt fortegn
Can I print a list of all of the worksheets within a workbook?
Mouse right click problem
Mouse right click problem
how do i count time numbers whit a negativ sign ( ex -19 hours, 25
mailing one sheet from workbook
When I move scroll bar in excell the contents do not move with it
Need quick help formatting cell
how do I remove Carriage Returns from a column in a spreadsheet?
Excel document protection
Tyring to shorten a formula ..!
Trying to shorten (or use new) formula
macro quandry.....??
Copying as Picture Link - using Macro
csv drops decimal places
Re: Automatic Quote Numbering
How to show dropdown list from another workbook without running it
I need to merge text from an Excel doc. into a powerpoint slide?
Conditional Formating
Dropdown list from another spreadsheet doesn't work if close sourc
How do I set a comments location
Formula for the word "between"
How to center a title across a range of cells in Excel ?
How to allow multiple users to update workbook (on network)?
Query disappears from worksheet