Microsoft Excel Misc [Archive] - Page 11

RE: return of blank
Re: return of blank
Why does Excel ask to save when no changes were made?
formula to hide a row in excel 2007
Open Excel slow after upgrade
How can i enable the scrool wheel for a data validation list?
Email macro not working
Pull info from multiple worksheets into one Master
Can I specify what order to refresh tabs?
RE: how do you make one cell larger than all the rest
how do you make one cell larger than all the rest
Programming issue
RE: SUMIF question (although, I think I'm using the wrong function)
RE: SUMIF question (although, I think I'm using the wrong function)
external links
rotate a sheet on its axis
Label ?
Excel 2000 help please - Cell protection
Determining elements that make up sum from a list
how do i copy data from online so it goes into separate cells
Can't open Excel 2007
xl2007 password to open
SORTING BY ODD OR EVEN NUMBERS
Copying four filtered cells
=COUNTIF formula
IS there a way to invert rows?
Combo Bar-Line Graph with single list of data
Creating a customer statement of account
dd:hh:mm:ss
Can I refresh worksheets in a specific order when I open a file?
Help needed with reference formula
Disabling the "&[Time]" or "&[T]" in Excel headers and footers
Copying filtered four cells by means of macro
Excel 2007 with two windows in Windows 7
AVERAGE cells on another worksheet when the range is calculated
Can i drop the year from dd/mm/yyyy for graph
Cells not adjusting to new Column
How do I get rid of Adobe Reader icon?
Subtotals on imported data
How to copy the function SUM but offseted in 7 columns
shift and down keys in macro
stock control spreadsheet
Question for WINSCP software and code for excel application currentlyusing FTP for uploading downloading files from File Server and needs to bechanged to SFTP
Date Format + Graph
ROC curve
Alternate Row Coloring
Excel 2003 compatibility issue
how do i set up a "send as attachment" shortcut in in a document
Is there a test for basic excell knowledge/usage????
Custom Format - Show 12.5 but not 12.0 (drop .0s) ?
Copy formulas in Column
Calculated Item causes undue repitition in pivot table
Protect Cells
changing the title for a spreadsheet shown in IE
Favourites
Inserting Rows into multiple worksheets
Ability to Group and Ungroup while in Protection Mode
running total between two dates
My Home tab closes after every click
VBA - Selection Instead of Range
Using a Count'ed field in a Calculated Formula for a Pivot Table
Cannot save text wrapping in cells-must do individually
Display Totals of Calculated Field
Filter is slow
Pivot Table Running Delta total
=TRIM(LEFT(B50,FIND(" ",B50)-1))
Getting the Last 4 values in a row?
Excel 95 (sorry)
How can I set an alarm Excel?
Compatibility Pack settings?
Cross refrence an index table and sum in one step?
Turn off the formula correction feature
Formula
Calculate weight (ounces into pounds) in Excell?
Search for string containing
Cells are changing format from numeric to date automatically
=IF(Input_Sheet!D52="","",Input_Sheet!D52)
Pivot Table Error
RE: extract value from cell
Lock cells conditionally formatted in 2007
RE: extract value from cell
2007 woes ARGGGGGGHHH!
Surpressing rows and columns with zero values in a pivot table
Hide Cell content from Printing
How do I setup a count down timer in excel showing
Issue with being able to select 64 bit Data Sources in Excel 2007
Re: extract value from cell
programming command bars
Protect Worksheet to share with older versions of excel
My places Bar
Calculated Fields in Pivot Tables using Existing aggregates
How do I stop Excel 2007 from using scientific notation?
Alternatives to MS Query for Pivot Tables & Cubes
adding 4 smallest numbers greater than zero
recalculation not recalculating some cells containing user functio
Personal.XLS is locked for editing. How to unlock it?
create a month column from date column
How to show sub-toal level?
Managing an Outline Manually
How to show sub-total level ?
File name and Sheet name a variable.
in excel, what is the formula that will add a number each month
Changing the cell format doesn't change existing cell content
Fitting to scale?
Time Sheet - Calculating Time Differences for Totals
column reference
row reference
How do I search for a word within a excel document
Vlookup or Other vs Sort?
Converting to Number for V Lookup
Return column header
Separating Date and Time
Making macros unvisible
Pivot Table date format
Linked Cells
Print Excel files from a BAT file.
Filenames ending with :1 and :2
Notify of Replies
formula
where can I find a template for church inventions
#Adding new worksheet problem
Removing digital signature
viewing a subset of information from a large spreadsheet
average
Linked spreadsheets failing to recognised that the linked file is
Can a Numeic Value in Excell be changed in Text
Excel & Powerpoint lesson plans?
Excel & Powerpoint lesson plans?
Excel file size dramatic increase
Dependent "If" formulas
How to design a stock taking report sheet
EXCEL 2003 - Conditional Formatting
CountA
macros off
visual basic book in india
How can I set up a pop-up calendar for 2010 in Excel?
Changing time format
Password Protect Tabs
Formulas
Print Area 2003 and 2007
standard toolbar does not show up when starting up
How to update data from multiple sheets to one specific sheets
Unique project names with complex array formulas
Formula Question
DISPLAYING NUMBERS AS WORDS
How to make the cursor stay in the cell when entering data.
round up the number
Gridlines in Office 2007
@How to add new worksheet on right side....
How do I auto format data so that the middle letter changes. EG 2.
Assign Error message to Standard toolbar icon
Forms Check Box cell link
formula vs constant
How do you find your posts on this forum?
Printing an Excel Spreadsheet
MS Excel performance with Windows 7 Starter
Average Calculation for Sunday School Year Long Goal
drop down lists
ELSEIF Loop to End
Only first of multiple If's returns results
Camera on my Excel Icon (2003)?
Moving information from one spreadsheet to another
Need to know how many users are logged in...
User form
rounding currency amounts
Refernce other files and auto update info
Prompted data entry
Shift + Home highlights entire worksheet to top, not single row
calculation of area below a complex curve
COUNT function
Sort by help
programming to select rows based on condition
Text Box Issues for 2003 vs. 2007
How to Display 12.5 but not 25.0 (drop .0’s)
Maco code doesn't work. Why?
How To Access Thru News Server
Data display incomplete after creating Pivot Table
How do I get running 12 months of data using date filter?
Excel Survey
Filter certain cells
Validation
Copying from one worksheet to multiple worksheets
Macros don't work when file name changes
FORMAT FOR FEET AN DINCHES
Email addresses
Random Samples
formulas with <>
Eliminate macro warning when you open a workbook
Missing text
Are macros inherently slow in Excel 2007
How to Select a % of the spreadsheet
excell 2007 pop up calendar
IF Formula
View Hyperlink in another cell
POP UP CALENDAR
Formatting making file size huge
Import data from text file
Cell Coloring
Is there a way to type in text and not have it print?
VLOOKUP output
Line Series Color on Graph
How to copy column of email addresses and paste directly to addr
Need Formula
Is anybody experiencing problems within the community answers
Excel 2007 spreadsheet
sumif two conditions moving target
Creating a new sheet from specific data in existing sheet
get a folder name
Expand an extra condition in formula
Issue with linked files.
sort help
Any method to copy the hyperlink address from an Office Object?
Multiple data entries in one cell for filtering purposes
Aligning line chart with column chart (4 categories)
Average Goal Calculation
Advanced Filter - Copying to location other than current sheet?
Shift Schedule Formula
Finding duplicate cells across a whole spreadsheet
rounding error
Conditionally formatting text and numbers differently
Timer in Excel
Formula vs. Constant
Formula to enter data of one cell based on greatest amount of anot
Creating Multiple summary sheets
Conditional Formatting Question
Data Validation List (Drop Down) Not Showing
Why is the font tab missing from Format Control box?
Formating issues
Excel - PDF - Excel
Page Break Issues
Useful Additions
Shared workbook
How do I open a Lotus wk3 file in Excel 2003?
automating use of complicated formula
Dates in Excel 2007
Excel
FORM ENTRY OUTSIDE OF RANGE SPECIFIED
Merge? VLookUp? Hmm...
worksheet skipped in page numbering
Macro to hide sheets based upon cell value
If then, vlook up and list box
File access error in Excel
Database Reference Formula Help
PDF > text > Excel - sorting "blocks" into columns.
Prevent printing a sheet
Rows to Keep at Top...
Double quotes when exporting to tab delimited file
Multiple columns into single row
publish as web page
Copy-Paste Alternative Needed...
Time dependant Excel Macro
VLookup Troubleshooting #N/A
Making a Excel file Read Only
Sharing Violation
formatting comment's background color
autoformat add or change
Find unmatched rows between 2 worksheets
@how to select Name Box from ...
trying to insert a 0 in front of zipcode
Text vs Numbers
Filter with a specific character
Notification
Adv. Filter - Want to copy to inactive sheet
How to insert Header will full text across page
Changing Print Order
Workbook size
data validation - cell lock
Concatenating cells but excluding blanks
Average Forumula
Repairing a corrupted excel file
Resummit auto update
Multiple drop down -data validation no freehand text
Splitting out a wrapped text entry
Copying numbers from Excel to Word
Shared book (sorry!) bloating and not disconnecting
invioice email
Excel - exceed nesting levels
Split text at space
how to insert filename in header without file extension
Auto fill
F9 Calc refresh does not work...
Greater than and less than
Ranking an average time from 1 to 5
How do I import data from a text file into Excel 2003
How do a import data from a text file to an excel worksheet
How do I average a row of 13 enries using the 8 highest in value.
Average & eliminating zero value Need HELP !! PLEASE
Reformatting
col gridlines
Urgent assistance required for excel
Making the AND function look at only part of a cell entry
Hide screen movements when a macro is running
Count(s) in Pivot Table
StartZip EndZip Zone
Tracking Changes Column Limit
Search
IN EXCEL, HOW DO I KEEP TWO LINES OF DATA TOGETHER WHEN SORTING (N
Scatter Plot?
Combine Multiple Worksheets into One with a Drop Down Box
Hiding amounts
Edit Comment Function
Reference Formula Help
Error when opening a macro-enabled Excel 2007 file
reference format and column name
excel dowloads won't open automatically
Unprotect sheets, how to?
how do I find duplicate information on 2 sheets using a formula?
Unable to edit comment
how do i "set association" for an xlsx file to open?
Pivot Tables
One cell is printing per page
#VALUE!
Embedding Excel 2007 charts in MS Outlook emails
Printing Different Sections of same Sheet
Test cells for values if date matches
Options/Tools
Test cells for values if date matches
If question
how do I print multiple print areas on one page
how do I create "blink" conditional formatting?
MOUSE POINTER JUMPS TO TOP RIGHT CORNER WHEN I AM WORKING
conditional formatting?
NETWORKDAYS
dates for conditional formatting
Test cells for values if date matches
bulk mailing from excel list
conditional formatting based on the value of another cell
Header/footer
Extracting numbers from alphanumeric string
Multiple headers
Auto Insert Parenthesis
Excel 2007 - Linking
Delete Macro with OR/ELSE condition
help me pls!
Please help with a date formula.
Subject: Formula for two (or more) "If's"
Bring filtered data from another file
Excel save
How to filter listbox data in a form?
A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY
How to bind filtered data in list box?
Inserting information from a database with a macro
Seaching a range
Macro to save information into a table
Bring filtered data from another file
Trouble with Advanced Filter
excel attachments
How do I make the page split into 2, and have them the same?
Auto-Alphabetize
Looping Macro
Ingenious formatting needed?
How do you get the footer to print in Excel?
Compile Error
Formula for two "If's"
Data search problem
How to call a COM add-in function from macro in Excel 2007
Formatting a drop down list
cannot access office 2007 after windows update
Unable to make a pivot table in sheet2
Need help to develop a % formula
Macro error
This One Is Tricky Need Help !!!!!
Compile error
Compile error
is microsoft strong cryptographic provider encryption good enough
Site Problems . . .
Why can't I have NO margins? I select 0"- but still small gap!
Insert Blank Row with data match change
HIDE #div/0
Help !!!
hide #div/0
Excel Icon
requiring column entries
Using "sort" in auto filter not possible when protected?
Password excel 2007
Cannot maximize a workbook
Visual Basic
Consolidate CSV files with historical returns for stocks in onespreadsheet
Formatting rows
How do I customize hotkeys for excel 2007?
Spell Check Protect Reprotect with same settings
Formula to calculate % using negative values
formulae to develop a % containing negative values
Need help (Average excluding zero values)
What is office connect?
Drop Down list Formula Help!!!!!!!!!!!!!!!!!!!!!! Please
Problems with numeric key pad
Excel 2007 workbook
Adding a row immediately following a "true" statement
Run Macros in a Password-protected workbook?
help with the syntax for using range name in a formula?
Move thur range of cells with enter key in excel
FYI: MSDG not displaying posts; expects duplicates :-(
sum=d11+c13 but hide result untill c13 value is entered
MS Excel as backend/database for a website
conditional formating dates, please help me
Getting Excel to return Hiragana using code/char functions
Locking A cell determined by data
How to create a chart showing ranges of prices of different produc
How to extract list of persons available from an availability list
@How to change worksheets with keyboard
cant export to excel unless I reduce data in cells and line breaks
Extract Data to Creat Short List
Shared file keeps losing connection
Need Help on Average formula!!!
Unhide Column
function
DATE WORKDAY PROBLEM
check box column
Update Links Slow
IF
A3 page size on non 2003 versions??
Problem opening up current Excel wksht to mail merge in Word
vlookup help
Excel template location
Cannot Resize Workbook window
Tool bar
Hide Some Text in a Cell
Replacing Apostrophize at Beginning of Cell
excel 2007 date problem when saving as 2003
Icon set based on another cell
RE: POST A QUESTION
RE: POST A QUESTION
Excel Template functionality without using "File-New"
Insert Worksheet
Sumproduct entire month from mmddyyy?
how can I place a comma after each number in a column
Adding or removing rows
Can I use a lookup on data containing duplicate entries?
Move one cell to another
Need to stop automatic column re-sizing when importing XML data
HELP!!! I need to make a simple formula!
stuck in an error loop
importing numeric data
Problem inserting rows (and cutting)
Not Printing Hidden Pages
Keep Cell Data Blank when Copying It
calulate holidays taken and remaining on calendar
Problem creating named ranges in a Macro!
Can I change a file's properties in Excel?
Hundreds of Blank rowas below my content-filled rows
Formulas and Dates not working in compatibility mode
Lookup restrictions
Import External Data
DIV/0 error
A few problems involving LOOKUP and SUMPRODUCT...
Delete drop down list
Worksheet name
Data Validation drop-down
Need a formula that will do C1=A1*B1...Cn=An*Bn
Office 2010
employee business chart
averages/if formulas-need help ASAP!!
Assign Macro to Icon on toolbar
How to format a cell from date to week?
worksheet fonts in cells
Next If Help
I need help
Sumproduct mmddyyy just the month?
Converting length from metres to millimetres
Sum
page breaks and print preview
Setting rows to autofit wrapping text in a cell
what office program do i use to make church bulletins
VBA moving and adding data
Lock Author details
Printing hidden rows or columns
entering data into a premade form
Search formula showing results plus 100 characters
IF formula returns error; abbreviating the formula
What's in the adjacent cell?
use copy paste function in the find & replace box
Pasted Pivot Table looks at old sheet
Student With A Question On MS Office 2007 Ribbon
Parsing Out a Month from a date field
Execute VB code depending on time of day
sumproduct with date range
merging spreadsheets
Descending Values on a Graph
Balance Sheet Formula
Highlighting cells if a value is obtained
Merging worksheet into MS Word mail merge
Toggle for GetPivot Data in Office 2007 Excel
Count specific characters in a cell
how do i increase the value of numbers in a column by a percentage
Precentile calculation
Bell Curve Chart
Combining Letters and Numbers
Toggle between workbooks 2003
I need help to make a not-so-easy AVERAGE formula!
Formula Question
Combining Spreadsheets easy or hard
look up
Mouse pointer or curser
Vlookup and Match combination
printing comments with pictures
Change Preset Columns
Date formatting
Can a workbook be prevented from being copied?
Plz Help
Seoration of Series
Formula
How can I retain the formatting of the data in a lookup table?
Custom VBA toolbar
Automaic Folder Numbering
Run time error message???....Help!!
Removing Duplicate Values
Formula For Excel
macro to replace
adding a box sideways
Colour coding data
OLAP filters from cells
Conditional Format, Color Scale adjacent cells
extracting substring
combining two columns together
Help! Need to ignore 0s and blank cells in average formula!
Embedded Excel worksheet's size changed after double-clicking in P
In Excel spreadsheet what does Ref # mean?
Macro to open, Update links, save and close workbooks
Compound Formula for Substitution
Convert text date to mmddyyy date
Need help creating a simple (?) SUM formula!
Is spellnumber function no more available in MS office 2007?
Change theme colors in Excel
#VALUE error add'g formulas
Macro Help
#N/A
printing with freeze panes
I Really need help with formula
Taking the Zeros out of an array when displaying
#N/A Conditional Formatting affects all cells?
macro for a range
Counting days and text in cells
vertical gridlines
conditional formatting coleman
how do I get a cummulative total in excel
I WANT TO KEEP TEMPLATES AND FORMULAS FROM LAST YEAR'S EXCEL FILE
Find last day of month depending on criteria
Count If Vlookup Array
personal.xls
Excel 2007 highlights multiple cells when trying to select one.
COPY WORKBOOK KEEPING FORMULAS AND TEMPLATES, BUT LOSING THE DATA
Getting my chart to display dates
Repeat Rows at Top - Except Final Page
How to Work with my 97-2003 Excel version in Compatibility Mode?
classic view
Save Workbook as HTML
Import data from one file to another
Convert Age to Months
VBA ln function
EXCEL FORMULA
Excel documents won't print after Windows 7 installed
help with formula
Find a First Occurence in a Column
Excel-Multiple Cells Being Hi-lited
convert text to numbers
getting rid of the second wookbook version
Excel 2007: Filtering Problem
convert text to numbers
How do I Return a Value Using Multiple Criteria?
How to add columns to the end of a spreadsheet--(last col is IV)?
Auto update
hide products without pricing
Status Bar not showing statistics
Fill Options & Formula Help
How do you find and replace unwanted symbols in text cells?
worksheet tabs
How do I wrap text in an Excel spread sheet to fit page?
Moving excel workbook with access query to another folder
Problem not counting duplicates
please help me - page break
integrate flow
Printing spreadsheets with pictures in Excel 2007
Counta not counting correctly!!
Auto wrap to another cell
What causes #######
Formatting Numbers to Text or??!!!
Error bars
Adding descriptive text to formulas without interfering w/ calcula
Excel: keeping rows together when ordering order of left column
How do i change text into barcode in office 2007?
conditional formating for the whole row, based on one cell value
Sumif criteria greater than or less than another cell
Excel formulas
How do i link from one work book to another?
Conditional Summing
forgot my vba project passowrd
Excel 2007: cell shading (not conditional formatting)
unable to get the pivotfields property of the pivottable class
Zoom and view settings reverting after download from a website
ascending sort definition [sorting alphabetically]
Why doesn't excel count function update automatically?
Conditional formating
Formula Help
Min/Max need help
pivot table rolling 12 month filter?
Name of the Day
Can I use & export data & sheets between Excel 2003 & 2007
Build link to an other excell doc
How do I create a list based on another list?
Error bars
Combining multiple spread sheets into one
Odd Dynamic Range Question
Change multiple worksheets at one time to print in color
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous
Is there a way to create a pop-up window in Excel?
Leading Zero Dropped in Text Cell
No Template option under Save As
how to delete the same columns across a workbook
Formatting Numbers into Text or???!!!
Time - By 8am the next morning
nesting functions to compare segments of two columns
Setting Page Breaks
Timestamp
Compare Two Cells
How do I remove spaces at the beginning of cells?
How do I get rid of the PERSONAL.XLS sheet from a workbook?
Hyperlink format?
csv conversion
Why can't I find my posted questions???
Trendline question
Programatically sort and highlight
IF formula with multiple data range in cell
Form Calculations
2010 date in Excel 2000
when I enter my date it transfers
Excel Pie Charts
Unhide row formula
Extremely poor search tool on line
Buld link
Build a link to an other excell document.
sorting problems - error message: identically sized merged cells.
leading zero
Leading zeros
Hide row code help
Expand and Shrink Rows and columns to hide information.
2010 in Excel 2000
Unique Values
Content
specific data points in data range
Mail merge in Excel
my arrow keys are not working
Contents
My date is coming up 0-Jan-00 when I type current date. Why?
log chart minor gridline values at tick marks
Problem while saving a shared excel'07 document - cannot track cha
Add a set number to a random entered number
Help with tax formula for marginal tax rates
copying worksheet including graphs to new worksheet
cell reference
with Excel 2007, f9 doesnt work. please help.
Linking text
How do I ignore blank cells while averaging the solutions of equat
Window resets to A1 when entering data
links?
Data sort seperate by blank row
Find & Replace
my mouse won't scroll left or right in excel but will in other pr.
How do I get rid of "compatibility mode" to protect passwords
Past Questions and Answers
Data Table
Compound Reference
printing i am getting this window "output file name"
Multiple Excel Spread Sheets
Formating Numbers
How can DSUM give me specific data?
Selecting Date
Macro Excell 03/07
Formula to pull last name error (Excel 07)
How do I recover an Excel document saved not saved as
How to stop "Undo" across multiple spreadsheets
Using Forms for Input
All data is converted to #####. Why?
Moving comment box leader arrow head
Worksheet Problem
2007 pivot table display data in row label
Please help with matching spreadsheets
Multiple Qualifiers
Multiple Qualifiers
How can I eliminate multiple instances of spreadsheets upon openin
Re: Count Occurances
column headings
date popping up in error
Help with formula
How do you randomly assign numbers without getting duplicates?
How do I keep duplicate text from being entered in an excel file?
Recording new Macro won't reset drop downs
Formula Help
summing line items by category
excel maths
Date list excluding weekends
how to name many columns
Finding Equations
how do i recover a forgotten password in excel?
Re: Count Occurances
Borders Disappear When Hiding Columns
Large Operation Error
Sum
deduplication
Date Function
Date formula/help
Macro-Enabled saving
Easy question (just not for me)
Large / Small
linking cells
macro save
Shortcut key to 'Clear All'
cell-link to a SAP transaction
Excel 2003 and 2007 problem
sum with multiple criteria
VBA Code User Range Selection
spreadsheet opens in e-mail window
VLOOKUP problem
Macro Help Required
why aren't there any calendars from sun to sat?
How to add same names in the numeral count in the next sheet
Macro - Help
Is 4th January 2010 = Week 2??
transpose rows to column (cell)
Repeating a formula in text
Compare data
2010-01-04 is equal to week 2???
Excel 2007: "Reference is not valid" when refreshing pivot table
summing a column gives me a date
Add author in Excel 2007
Sort dialog box enlarges after each use
Re: vba code
Alerts....
excel 2007 does not automatically calculate
Pivot tables - adding dates, descriptions
Conditional format color change
Set a value in multiple cells based on a condition
Office 2007. Save HTML
How to lock cell and worksheet?
Excel 2007 'contain featrures that are not compatable with Web Pag
Excel files opin in IE8 instead of Excel 2007
Arranging a data in required format
Merge two files based on one column
Counting Occurances (2003)
Division and formatting excel question
Sumproduct question and why cant I find my previous questions?
How do I customize the resizing of my spread sheet to 8 1/2 by 17
FORMULA HELP
Removing file extensions on e-mail
Conditional fomat series
VBA code to automatically colour cells depending on text?
Auto Re-Numbering in Excel
Pivot Table Month Order
Auto Re-Numbering in Excel
Auto Renumbering in Excel