Microsoft Excel New Users [Archive]

Re: Copying out £ amount only
Re: Highlighting a whole row.
Re: Copying out £ amount only
Re: Working out what clothes to get.
Re: Partial match of a text
Re: How can I copy data produced by a formula, not the formula?
Re: Help with determining # of days from certain dates
Re: Run Macro on multiple worksheets
Re: How to list in a column with certain number
Re: "If"
Re: Need help with a formula
How to calculate out of hours?
help needed in excel 07
Help with a formula
Re: Repair corrupt OST
Re: VBA Programming Book
Re: Msg Box Title
Re: Sum of two highest numbers
Re: Sum of two highest numbers
Re: selection
Re: Conditional Formatting
Date Ranges with Gaps - Finding Corresponding Maximum
Not sure of formula help please
Re: Change cell data using a mouse click?
Re: Which Function to be used??
Re: To run a macro
Re: How to use matching values in two worksheets to return another value
Re: Nested if then statement
Re: Multiple Condition in one cell
Can't Figure Out Goal Seeking. Help!
COUNTIF function across more than 1 column
Re: Controlling Cells included in a sum command
Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA)
Convert numbers stored as text to numbers - Automatically - Macro
Need to merge, proper and trim
Compute Tax?
Computing Elapsed Time
Trendline Question
Re: Identical looking cells
Re: Summary of Amounts by Date
Re: counting down dates
Re: Searching another entry with vlookup
Re: I need a macro to associate values in columns
Sort doesn't always work
Help Needed With Count
Count number of text rows???
Excel Rainfall Formula
Re: Trying to work out a formula for time lost/gained
Re: Trying to work out a formula for time lost/gained
Re: Deleting A COLUMN BY MACRO
Re: Shifting rows to sheet2 using Macro
Re: Equipment log
ranbetween
Separation of text - concatenate excel
Re: IF-MID Function
Re: Aloha!
#VALUE! problem
Countif with indirect formulas needed
Re: Min, Max
vlookup
Re: Can I filter cell that have only 0-9 number in it?
Re: How to make cells not editable if it contains any data
Re: Collating columns and rows to one columns
Re: Formating multiple columns
remove columns from a lookup table
Chart Question
Re: Help - hiding multiple sets of rows based on two different cells
Excel formula request
Re: Need a little help!
Re: Drop Down Menus
Re: Auto-populate a balance sheet?
Re: Newbie here - hope you can help
Re: Macro/formula?
Re: How do I use letters to represent numbers?
Re: Counting Days
Re: Inventory List
Re: Removing part of a String
Re: Formatting based on one cell
Re: Is this possible?
Re: Autopopulating a date
Re: creating a estimating template
optimising formats for minimum column widths
Re: if then formula
Re: if then formula (CORRECTION on Earlier POST)
Re: if then formula
addind date stamp
How to set a value in a cell whose address is held in another cell
Re: How can i apply formula in next ?
Lookup problem in Excel 2003
Re: Text to column and paste special transpose
Re: Last used row
How to open a file in another window?
Re: how to program a cell ?
Using data between date range
combobox populating.
make a cell invisible
Re: Using VLOOKUP to Sum values from multiple columns
changing colour cell and text by clicking cell
Re: How to lock cell
Re: How to lock cell
Re: Average function for letters
Re: formula
Re: Sharing a worksheet/tracking payment dates
Re: Can This Be Done in Excel?
Re: SUM help please
help with formats please
Re: comments font size
Re: multiple cells populated by one single cell?
Re: Can This Be Done in Excel?
Re: Can This Be Done in Excel?
Re: Help with VBA Error
external functions
help with formula please
Re: Automating Model Spreadsheet
Re: converting Postal codes to numeric value
Re: count values across multiple sheets
Re: Automatically renaming Cells
Re: Sorry if already here. Average HELP!!!
Re: Sorry if already here. Average HELP!!!
Re: Sorry if already here. Average HELP!!!
Calculating one of two colums with a 3rd, for result?
Re: multiple inputs into same cell and totaling
Saving file to a differant name
Re: Caculating the remainding amount
Re: Caculating the remainding amount
Re: Create business form in Excel
Posting messages
Re: Sharing infor between worksheets based on terms
Re: Need to create a list of non-duplicates
Make first imported CSV row into column names ?
Keeping Leading Zeros; How Please ?
Part of the screen has blank spots (not refreshing properly)
Importing from a Notepad file
Is there a template for this sort of thing?
Create set based on column items feature in Pivot Tables 2010
Seeing What The Format Is ?
How to use first row of delimited file for field names when importing ?
Merging data from several Excel 2010 spreadhseets
Re: Sheet Protection
Re: Sheet Protection
Fill function
Frequency of Unique Values in a cloumn
decimal point in general number
Networkdays Today + 1
Summarize By Category?
Insert same value across many cells
Re: Excel 2007 noncontiguous cell highlight color=light,light blue.How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZHELP !! )
Runtime Error on Linest
Copying selected rows to a new workbook
Looping through permutations
Re: Autocomplete
InputBox Choice
SUMPRODUCT
Excel reference sheet cut off printing
Re: Problem with VBA code and Range
Re: Problem with VBA code and Range
Problem with VBA code and Range
Re: Launching from a cell
Re: How can I refer to a row
Excel 2010 Service Pack 1
Re: Formula help please
ignore -- testing
Re: How do I get a popup window on a VLOOKUP lookup failure?
Re: Moving cell values
Re: Filter problem
Retrieve last non zero value in a range of cells
Re: Freeze the first line of a sheet
Re: Freeze the first line of a sheet
Appending A Column By What's In Another Column ?
Merge/consolidate text cells based on unique keys ?
need fomula
hiding rows
Favorites
help with dates please
Prep Cram 70-573 actual Questions Answers
Removing Cell Outlines ?
Hurray !!!! Passed Certifications Exam
640-801 FreeExamKing
Need Help Merging Cells
FreeExamKing for latest brain dumps
Leading Zeros; How to Keep ?
Hide/Unhide without using macros
fifty thousand rows
Inserting Blank Lines ?
macro
Pivot table question
worksheet references
Automatically format
Re: A useful AVERAGE calculation without using the built-in AVERAGE function
Row height AutoFit help
Too many Excel applications running at the same time
Re: A useful AVERAGE calculation without using the built-in AVERAGE function
help with a formula please
Save as ...
convert a string into a textbox name
Incrementing Numbers ?
if between statement
Finding data sequentially
Can't store '10 cleanly
Rows to repeat at top
Colors flakey in Excel 2010?
Complete Novice! Require help with "simple" Excel doc
Finding Unique Records
Problem Starting Word & Excel
Change default format in 2007
Locking in a Snag-it(jpg) into a Cell so it stays with that row
How do I make the smallest number in a column red ( No VBA Please )
Column Headings (Excel 2007)
Date and Number cell formats
conditional formatting: multiple conditions with min
Modifying Text in a column
Consistent formatting in a column
Determining How An Existing Cell Is Formatted ?
Question about borders
IFERROR function from XL 2003 to 2007
Adding Text To A Column
What Am I Doing Wrong Re Some Simple Math On A Column ?
Charting Question
Convert text to text - Citi Funds names to Laurel Funds name
Sorting by cell colors
How can we group rows? I have problem....
Re: Finding a string in Excel cells
Re: Finding a string in Excel cells
Help, please: sorting the Legend
Help needed for inexperienced MS Excel 2003 user
Grid Line Question
Now you can pass IT Exam with high scores
cannot paste source column width to destination column width
CCNP FreeExamKing [ 642-901 ] BSCI v2.85
Vlookup autofill for multiple worksheets
Vlookup based on multiple criteria
Problems with Goalseek
MS Excel help needed for newbie
Callaway Handicapping System
dragging formulas acros adjacent cells
Can't open xlsx file
control combobox nightmare
Hey! (please read this)
Trial Version of Excel (Office)
24 Hour Clock Calculations
display in taskbar in excel 2000
modify series data by changing chart lines?
test for #NA , help please
Calculation based on changing conditions
Re: how to compare formula's values?
You will pass all the exams at 1st attempt
Hotel Work Order Printing
Fixture square / league table in excel
Reset option buttons to default value
Please Help With Daily Sheets!
Latest Q&A for Certifcation Exams.
Re: Dancing Baloney
Can I rotate my spreadsheet?
Sort behaves unexpectedly
best option please
tricky
Increasing the value of the content of cells by one.
Changing A "Lot Of" Data With One Command ?
Opening Two Spreadsheets, Side By Side ?
Can I link *.jpg files to Excel cells?
Excel Desktop Icons: Changing Possible ?
Importing stock quotes
How can I freeze a pane...
Go back to last selected Worksheet
Create seqiuence numbers?
Copy And Paste problem ?
Hurray !!!! Passed Certifications Exam Hello, Visit
.csv spreadsheet To Normal Excel Spreadsheet Format: How Please?
once every year, ideas please ?
Why No "Format Cells" Choice Option Always ?
Security Alert Setting
From OP (Bob)
Re: Testing post
Row & Column Headings
Keeping A Derived Column Of Numbers ?
"Custom Sort" Question
Re: Testing post
Re: Testing post
Sumproduct problems
copy selected rows to second worksheet (NOT Cut + Paste)
Sorting Problem
Excel
NEW MENU - List of Files to Open
The Day After ???
JUST DO IT
working with textboxes-VBA
how can i group coloum
how do I use the daily calorie and fat percentage template?
What Excel formula converts hourly wage to annual salary
#VALUE! result when using defined name in formula
text column - via macro
The last day
How do I find older versions of a spreadsheet
Reverse Row Order?
Combo Box
Golf scores
Data Analysis Toolpak for Student Treacher edition originaly insta
Header
How do I swap data in columns and rows around?
program link
Rephrasing Interior.ColorIndex 36 question.
Conditional formula with an if statement
How DO I get the bold face toggle to show
Data conversion: Text to Numeric to Support Averaging
How do I hyperlink from spreadsheet to content within a word?
Finding last occurence of Interior.ColorIndex 36
Excel 2007 will not refresh cells
RE: Excel 2007 will not refresh cells
Formula Help PLEASE!!!!
Excel Invoice followon autonumbering
New To Formulas - Help please
How to insert static time using a laptop?
how can i relate between two columns in two sheets?
excel 2007 csv gibberish
How do I calculate monthly gains/losses in excel
Formula returned in vlookup function
I would like to convert my dollar totals into a bar chart format
Re: AND - OR
Re: AND - OR
Excel format conversion
Re:formula to convert 15 minute to hourly data
spreadsheet switches to bold involuntarily messing up figures
Calculation
Continued Headers on successive pages in an Excel document
Find and Replace
create text effects in excel
Conditional Formatting
Pivot tables
Help with If statement
Please Help!!!
Opening any excel document NOTHING shows
how to make a bar graph
Difference between 8/15/2009 & 8/5/2009
Currently no help is associated with this page.
can i import an adress book
Conditional Formating by word(s)
if-then functions
How do I number sequentially omiting the headings in excel?
#N/A error
How do I match records from two Sheets?
how do I enter this in excel sumif
Prevent dialogue: "save changes"?
how do i link cells that contain text in excel
Timesheets
column information changes when printed in excel document
Sorting by surname when first name and surname are in the same cel
link text box in powerpoint to a cell
Different cell heights within worksheet
For John, et al. Re Combining Columns (previous post)
Combining Columns
Need help creating a sum based on variable data.
Counting with two criteria where one is between values
formula showing in cell rather than answer for formula
where can I find a simple home budget work sheet?
Copy and Pasting Formulas are incrementing
Question not posted?
Excel 2007 Need to permanently change Normal settings for gridlines
Add up a column
how do i switch to a right to left worksheet
dates
unwanted extra pages at end of document
MSN Money stock quotes add-in for excel
Excel Time Stamp help
how do I merge two adjacent cells and keep the data from both cell
Building a Pricing Model
deleted worksheet
How do I Get Rid of "###" in an Excel field?
QuickBooks export to Excel
Selection after enter
How do I create an absolute cell reference in Excel 2003?
Comparing, Matching, and Sum formula
Set a minimum row height a the same time with autofit row height
Hiding graphics elements?
filters don't work after combining several spreadsheets into one
How can I unprotect an Excel worksheet without the password?
How to write the SUM of two MAX numbers in four or more than four cells
Tab referenced to a cell
converting line-delimited text into cells
use current month in ad If satament
Comparing 3 Columns and Returning a Result
how to unrestrict access to a cell
How to add a leading space to an existing text field?
need a nice price letter format
Excel
RE: Duplicates - ??
how to remove hyperlink for the entire worksheet?
Looking up values in a table
Count matching data
How to round the numeric value?
extact data
how to use for dummies
Eliminate rows in a worksheet
Text control won't expand
Option Buttons disappear from the frame when not in design mode
search for a string
To find due days of debtors
Changing fonts with a formula
HOW DO I KEEP THE # SIGN IN THE CELL AUTOMATICALLY SO I DONT HAVE.
Finding Unmatched Records
Quarterly Data in Pivot Table
Access Groups from IE?
Formula/worksheet error
Is it easier to do math in excel, or just use a calculator?
Time Formatting Question
How do I stop my mouse from changing the size of the spreadsheet?
Re: Attachment :SUM of a colum where IF function is used
Re: Attachment :SUM of a colum where IF function is used
RE: Attachment :SUM of a colum where IF function is used
SUM of a colum where IF function is used
Average Function but exclude info
Showing Only Actual Typing Area ?
Sum of retuned valus as digits
Printing Excel Colmns& Rows / Left To Right 1st across, then nxt l
highlight only complete row currently being used.
Production/Inventory
Filtering throough cell color
Pivot Table calculated field error
if/or formula
Row Numbering
Locking Fomulas
urgent help needed - hyperlinks
=if formulae
Sumif with a few criteria
Sumif (I think)
e Mail attachment
microsoft public excel newusers tips
Quarterly Formula
Calcualate Time
Sorting tables on protected worksheets
deleted text character returning numbers when deleted.
Clearing values automaticaly when different function selected
No zoom to page option ???
Custom macro and custom button
ignore test from ms/communities
ignore test from ms/office
new features in excel 2010 solver add in
Difference between real number and a perfect fractions
hyperlink question
Hyperlink problem and question
blood pressure chart for excel?
Excel always in bold
i want to mutliply c10 to c20 by e4
Need undo a highlighted spreadsheet where there's no white area.
Excel 2007 Pivot Tables
copy specific rows to different work sheets
how to calculate the grading for staffs
Controls collapsed with outline
How to open 2003 excel in excel 2007
Date format clarification
I want a cell should 2 accept only >=0 or <=30 or Y or N
Linking Excel Tables
Re: multiple scenario forumla (maybe a nested if statement)
Data Validation - Error Alert
Count Days until Completion
How can I change the numbers in words. ( Ex.100.00 = One Hundred)
compatibility mode
using dmax
How to compare and move false information to another cell
dynamic named range
Border Limitations for Conditional Formats
Need to know how to set up a email profile
column header labels are numbered but need to be lettered
How do I rename my columns? (i.e. - A1)
Linking Data Columns
creating nested formulas
How do I work in excel and then save it as a doc or docx?
block of cells appear as single cell
Text to Columns
Conditional Formatting for a Range
EXCEL
remove space BE 039 to BE039
Radio Buttons in Excel 2007
make calculations work with one worksheet closed
copying formulas with fill handle
Salary Reciept
Number of days falling in various years
If Statement - Returning Quarter based on Specific Date
sum of cells containing text
.csv And (Possible) Spreadsheet Differences Questions
Macro Problem
Drop down list
What is the deifference between writng A3 or $A$3 in a function?
SEARCH BOX
how to do an alphabetical sort by using page break
macro - replace
automation - import into excel
In Excel, I cannot move my cursor to another cell with arrow keys
IS THERE A FORMULA MARKER IN EXCELL SIMILAR TO THE ONE IN 123?
is there a comand to return the mane of a worksheet inside a cell
Re: Excel formula to list out the info according to criterion
downloading excel from Office home and Student
Creating a Graph from a Drop Down List in Excel
Duplicate Entries: Determining If Any ?
Sorting a column in a spreadsheet
Extended IF Formula
A link to a collection of videos and tutorials on MS excel:Data mining Add-in
Using header on first page only
Functions for dummies
I put in the wrong server name. How do I fix it?
Is this a trim issue
copy / paste as values
Adjust tab key function and enter key function in Excel
formula required
eliminating decimal places
Analysing data from several excel workbooks
highest value between rows
VBA code needed
Navigation Questions
Why does an Excel 2007 file lose its format when reopened?
addins
excel file will not open
convert number to dozen showing remainder
Re: Excel 2007 Macro Recorder not recording shapes
line graphs
pass to textbox on a form and to excel worksheet
addins stopped working ?
need a bank rec template
Sub-menus of main menus for Excel 2007
Two Spreadsheets Open Side By Side: How Please ?
FORMATTING A CELL BASED ON ANOTHER
excel file size blew up
Changing Of Column Values ?
Copy column and rearrange rows
How do you set your printer to manual feed a worksheet during pri.
Poor .PDF conversion
Formula help
Filling In A Column With Incrementing Values ?
From OP:
Replacing A Column Of Numbers
Scanning with a hand held unit?
Scanning data in Excel 2007
Percentage Formula
How do I set the print range on a form. Regards
Cannot select multiple controls
excel formulae
VBA menus at side
How to convert a ($200) cell to a written amount(Two hundred doll
Can I do a global find and replace on the tabs in Excel 2007
fill a color to a row
Making first column number in order
rows & columns height & width
Question for JLatham
multiple files open upon startup
SUMIF non-blank cells?
SORTING HELP!
Cell formulas display "0" (zero's)
EXCEL files and Windows - - an open and shut case?
Re: Spelling options
Spelling options
Text To Date Conversion
One column to another
looking up a value only if it returns a value in another list
how do I specify a date range = date(2010,4,1 thru 30)
EXCEL - NEW PAGE
pictures
Conditional format
Problem with Auto fill
Organizing rating scale information into a narrative paragraph
Create a button with a macro vba
Formula in a coloum
Formulas
How can I change worksheet direction from right to left
Excel: Combine contents from identical cells on multiple sheets.
copying/sorting data with blank spaces in between?
Data change as scrolling
Floating Column
Cells in spreadsheet are in edit mode.
printing excel 2003 spread sheet
VBA copy cell to another worksheet
Reverse naming of file
Converting string to number
RE: commands are disabled and I can't enter data
Keys to access the tabs and commands on the screen
Insert Comments on a Protected Worksheet
could someone write me a VB code? thanks
Change format to mm dd yyyy hh mm ss
Database fields in Excel?
Count with formatting
How do I delete a "function" from a cell in MS Excel?
Download latest Q&A and brain dumps
Formula
Excel View
Workbook back up
get Cell to not display ( $ - )
Column widths change with each new import from Access 2007
Count Cells with alphanumeric data
Save as Template
Sort list
Re: Adding a number to itself
incremental counting?????
I do not want to allow third party cookies. I want to learn tips
Using the "if" function, the "and" function and the "or" function
Excel 2007 Compatibility Mode
RE: number
MS Excel 2003 - Advanced Features Add-In
sumif
Is it possible to use a formula in the middle of a sentence in exc
copy row to different tab
Worksheet printing
in xcell, how do I select on 1 cell? my cursor selects multiples
Functions
one code to do multiple things
open excel file
How to apply Macro on a same type of format but columns no. r chan
ignoring text data in a cell when summing values in the same cell
IF/ISBLANK formula
how do you flip a column containing different text in each cell
Constant required
pivot table
importing text as a URL
vb macro format is wrong
Sum of product
how to stop data shifting into new cells every time workbook is o.
help with inputting code
column heading label
Delete worksheets in Office Excell 2007?
VLOOKUP Range_lookup TRUE
Sum and If
Column Sorting
How does "Search For" By or Subject work?
Visual Basics Error - Goto
Making actual projects with Excel 2007
How to hide a vaue
how do i use the daye function to insert a serial number
OR within Criteria of SUMIF
just need to display formulas nothing appears
Excel 2007 won't print spreadsheet
Excel 2003 Drop Down Box
RE: Where is Excel 2007 on my computer?
RE: Where is Excel 2007 on my computer?
find&press button
HOW DO I CHANGE THE COLOR OF THE EXCEL SPLIT LINE
New free mail add-in for Excel/Outlook 2007-2010
Variable Frame Reference
How do I convert text to "proper text"?
Display ranges in a Pivot
Template
Percent column in Pivot report
what does a mini toolbar contain
how to insert a collum on a sheet without it changing cell referen
formula help
format for weight
Calculating averages and not including blank cells
how do I turn on the voice in excel?
SumIF
there should be a modified date of a single cell modifacation
Converting text to numerical values
excel formula
Copying & Dragging Cells & Keeping Rows On all Screens
How to re-size a Balance Sheet template??
Please help with formula
formula help
numbering
how to attach doc.to an email?
CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
How to email documents
Timesheet calculations
help with dates please
macro to action formula
how do I unlocked michosof excel
Can Excel fill in numbers to equal a predetermined total?
How Do I Copy Customized QAT from Desktop to Laptop?
Compare numbers in to raws
Automatic totals.
Top Row on Excel has changed to 1, 2, 3... in lieu of A, B, C?
File saved yesterday is blank today, how do I retrieve?
Formula?
how to consecutive number same worksheet
What is this macro?
RE: macro
Converting MM/DD/YYYY into just MM/DD and Sorting
why does numbers automaticly turn to dates in Excel?
Text to Columns
cell value
how do I add 3% or 5 % to a column
Excel Chart Customization
Day and time difference
How to create unselectable cells
How to multiply ALL numeric cells in a sheet by same number ?
HOW TO FIND THE MEREGED CELL
Moving from cell to cell
How do I remove border lines around cells; I want to clean up the
Paths to becoming an Excel Expert
write number amount convert to in words
Add new page to Template which is included in the summary
Report Options
Unique addresses
Â¿QuÃ© he de hacer para sumar una columna de una fila, con otra de .
When "IF" gives result of zero
How do I make a negative balance automatically appear in red?
Excel 2007 auto select
How to delete a workbook in Microsoft Excel
In Excel how do I force text into next line before first is full?
can't get the pratice excel spreadsheet to download for training
How to stop Excel from rounding a number?
Insert Existing Worksheets into a new Workbook
excel pivot table formating
Excel 2003 + 2007 on same computer
if statement with or
Upgrade To MS Office Home & Student: Non-Commercial Use?
Help in EXCEL functions - needed badly
Why is the right hand margin so large when I print?
How do I enter new data alphabetically into a workbook w/o scroll.
How do I write a formula with absolute cell references
check spelling as you type
transfer data from multiple columns to singlr column
How to Change Media Player in Excel
Forms Results in Excel
Vlookup & If
A question of time
Excel 2003 + 2007 on same Win7 computer
Replacing Printable Ascii Codes
go to command
How can I change the cursor color in Excel?
Problem with Excel 2003 and 2007 on same computer
Compatability Mode
Flowchart toolbars in Excel 07
Trusted macro
Match Many to One
Excel 2007 Forced Word Wrap
How do I delete an entire document in excel 2007?
excel function search
Excel 2007-programming macros that apply to data validation
Excel formula
Subtotals format
Re: Usiing a formula to Conditional Format XL2007
i cant open a file for editing?
import the data to match the column titles in Excel
Hyperlink in excel...
How to change font size on formula bar in Excell 2007
VBLookup help
VB Code Or Macros
Duplicate data
External Links
highlighted cells
delayed response to any command
How can I extract a list of numbers missing in a list?
How to look up and copy a changing range of data ?
How do I combining several worksheets onto one
Formatting a number within a text formula
drop down list
Lookup_vector
Color Coding cell based on date (over a large range)
Copy formula
2003 s/s and css
Repeat rows in Excel based on Quantity Field
columb width/height
Windows in task bar in MS EXCEL 2007
how do you show the task pane in office 2007
IF function