Microsoft Excel Misc [Archive] - Page 15

TextToColumn when destination to other sheet
Excel found unreadable content
How can I limit a worksheet to one page?
Binding a Graphic
Different perspective of RANK
Typing Over Pivot Table Rows and Columns
Automatic Data Changes
Make Excel see columns as rows and rows as columns
Hidding rows and colums
Hidden column becoming unhidden upon forwarding
will formulas be lost when moving data in a worksheet?
Excell Lookup formula question, 2 criteria
Conditional text display
Works on one computer, but not another
Rearrange data from columns to rows
How do I reactivate "Save On Exit" in Excel 2007?
Hopefully a real easy vba question
E-mail automation
Macro "on off" switch
Fill Colour problem
Complicated Forumla Help
Stop Scrolling When I double-click cell wall
Way to keep formulas unchanged when deleting rows?
EDI transfer to Excel
Formula to reach goal percentage of migrating customers
Trying to do a Rota
Losing Print format when copying wrksht to wrksht or wkbook to wkb
Automatically Hiding Rows when certain cell value has been selecte
Sorting data with the letter 'E' included
I need a template to track physical inventory
"Cell border" appearing around edited cell
Scrolling in Excel
calendar year versus fiscal year
My conditional formatting evaluates only when I double click cells
Exel 2003 and Excel 2007 on same computer
How do I fit to 1 page on entire workbook
Formula do excel
Pastelink to Word
Excel Formula
Color palette in Excel 2007
shade one cell that will shade multiple cells
Excel Image not displayed when the physical file is N/A
how to get auto next due date for the renewal of some document
How can one append information in an Excel spreadsheet to a barcod
Tracking history of Office files chronologically
vlookup with 2 criteria or more
Internet transfer controls
Show Ranking
CheckBox Ticked, ComboBoxBox visible?
Hyperlinks were lost
Format a macro button
need to jump cells in column data when finding average, max and mi
Move data on multiple tab to one
using fiscal year calculations in a formula
Posts not appearing on discussion board
Want to Plot Recovery
I'm getting the #DIV/0! error
Concatenate Error
Count if using multiple date criteria
Email notification from microsoft.com users groups
finding and then moving entire row to new sheet based on cell value
csv, how to set excel to auto load
Pivot Table Formatting
Macro to automatically save document with cell reference as filena
Excel 2003
Wildcard in the Replace function
addition, subtraction in a single cell formula
Dates between cells in one column and another
conditional formating with text
Help With My Excel Database
Calculating Difference Between Two Dates Using Only Year
Pivot Table - Finanical information by Period as a month
Text box disappears with 2 columns
MS Excel 2003 Window
Can an Autofilter go horizontally?
How do I see my own message posts ?
Win7 and Excel07 - Items appear in NEW Excel Taskbar icon not Exis
engaging filter option in multple tabs
Compare two cells in two different files and return answer
email addresses tied to a spread sheet
Save or Export to CSV
Excel -
Win 7, Excel 2007 - When Pin to List all sheets in new Taskbar ico
Workbook LOCKED - Up
Can I use solver functions in a protected (locked) worksheet?
Conditional Formatting on cells beginning with a hyphen
conditional formatting
How to split cell based on capitalised suburb name
Not able to see all data but can see on another computer
PowerPivot Beta
Increase cell value by 1 month
what does "calculate" mean in status bar?
Why is this formula returning "#Name?"?
Is it possible to set tabs within an excel cell?
How can collect data from multiple sheets in the same workbook?
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007
Would like help making a function
X-Y gridded data into columns
current time
min,average>0 if 52 cells read zero
How do I stop a letter c in parentheses becoming a "copyright sig.
Excel's localization of scientific notation
Excel grouped data
Non reciprocal formula?
Excel Help Please quick question
HELP WINDOW PROBLEM
putting a column of names into alphabetical order
How do I convert US date with 12hr format to European date 24hr
Combining 2 Tables Dynamically into third new Table
Changing the screen tip on a custom button, Name change does not w
How do I get SQL data to show CRLF instead of question marks?
How do I hide the Quick Access Toolbar in Excel 2007?
Down Arrow problems
How do I display a 'tick' on excel 2007?
Loading the Analysis ToolPak
VLOOKUP Question
Vlookup only the last 6 characters
Superscript in Custom Format
Reporting Dashboards
XLSX Format
need help in formula
XLSX
formula problem
Indirect
Apply to all worksheets
How do I add more ranges to the following formula?
SumProduct question
excel 2003 - saving workspace as a .xlw file - excel shuts down
Help window setting workbook collapse
Indirect function countif
Using excel to process QIF file
Preserve formatting of Pivot table template
How to generate simple reports from a time log?
My Posts
Formulas: Averages
How to show top students' name in PivotTable
return the row of any selected cell
Formula to count cell text by value
excel 2007 will not print to my default printer
use pivot table data in vlookup formula
Pivot Table operation is different
make my own list like formula autocomplete
BVE = BE?
sumif based on 1 criteria
If formulations
Mysterious "Arc" appearing at the bottom of the page
Concatenate not working
Resetting the scroll bar
download credit card statements to Excel
Count Names
Average Time for Specific Item
merge to word - whole cell contents not going
How would I do this sum in Excel please?
nested ifs
averageif with 2 other criteria
file format is not valid
Problem with a simple formula
Excel 2003
Pearson fucntion on excel
Confusion with INDEX & MATCH
Copying Cells times out after a few seconds.
creating labels from excel spreadsheet
Splitting text and numbers from a cell
Cannot tab from colum to colum
E2007 - Macro for splitting text and then replacing something
pssword protected worksheet
if then and conditional formatting of dates
Extract Surname from text
Help with IF - THEN
spreadsheet problem
Match with copy
Simple Formula
Excel 2007 Custom Lists
HLOOKUP - Relative cell reference in row index number
XLSX
refer to range in another sheet
MATCH with MAX formula question
help in saving an excel file opened in IE
number 12 digits to 15 digits
Macro if condition
How to combine hyperlink and filter into one-click
how can I print more than 8 columns on a page?
Excel formula help
Compile Error: TPUtils
Scrolling down my drop down box
Sorting order of foreign languages
Contextures Order Form
Lines Between rows
Large Worksheet Conditional Formatting
Excel 2007
Roll up Bars broken
I need to find the sum of the best of 6 scores.
Open files in seperate instance
Ebay fee formula
How do I Convert TEXT to EST Time ?
Formula to return Vacation weeks
Combine multiple columns to one with separator, omitting empty col
Problem with Saving Excel File as PRN
sum the number of rows in a spreadsheet given 2 criteria???
IF Statement in Excel 07
Something is not right
Pivot Table criteria
Compare 2 lists / conduct gap analysis (XL 2007)
Data Validation using dependency logic
How to XML Map Repeating Rows?
Return Column match
copying conditional formats
Fix this make it an optional feature.
manage tags for microsoft office 2007
Preformatting Excel Prior to Opening Spreadsheet
Linking Password workbooks
Is there a way to make the enter button work as regular enter in c
sub routine
conditional formatting entire column referencing data from other c
PivotTable Title
Excel 2003 had a function to "SumByColor" -- it's not in 2007?
change a positive number to negative
Quickbooks export to Excel 2003
why is excel defaulting to the Euro currency
Exel 2007 click on one cell and several cells are selected
Change hyperlink throughout excel
Excel 2010 - choose codepage when saving as text?
Opening a spreadsheet - can it ask the user for a date?
excel hyperlink not working
Freeze panes grayed out
Cell reference
Copy & Paste
Column & row heading directions
divide by zero error
Filtered columns slower than others
sub procedure
Scroll Lock key to hold cell and return to it
Reinstalling Microsoft Office 2007
Unable to select sheets when maximized
quantidade de planilhas no excel
Check for text in multiple cells
convert each letter(text) to number
Macro save workbook
Saving changes to option to apply all the time.
text calculation
Formula to count new records in pivot table
Autofill question
Short listing the Data Validation List
How can I import a very large PDL from outlook into excel
How to use 2 conditions in conditional formatting
Error calculation
Copy from one worksheet to another changes the year from 2009 to 2
Hyperlink to PDF not working
Formula Extend in Excel 2007
Unable to open .xls files saved by other users
can I use dates as the lookup argument with HLookup?
Contextures Order Form
win or lose formula needed
VBA Code for "" empty cell
How can I scroll within an alphabetical list in Excel?
Retrieve data from excel database
How do I insert a pop-up box to alert me when numbers are wrong?
Linked files extremely slow to save.
min thats = 0
Stock Values in Excel
File Compatibility
How to copy task pane to clipboard?
RE: Search for text in multiple columns
GETPIVOTDATA
Add-in
if then formula
Sorting a column with Text and Numbers
underline in an empty cell
Insert Cells every other row
XML File IMport to Excel
How can i create a gradebook in excel
Find a Unique code cut and paste
how to assign cell value which the users has filtered by?
vlookupformula
hidden Hyperlink
In excel, I can't get my right margin to zero, It goes to (.51)
Copy Problem with 2007 Conditional Format
Numbers in a formula!
Hide/Show details in an Outline Group
Autofit Unmerged Cells (XP & Excel 2003)
Automatically color merged cells
How to make an entire column of web addresses into hyperlinks?
Saving in new file format
Error 1004
Sheet Macro Help Needed
Excel 2007 .tif file
tools options view window options
Re: Excel Dashboard
Excel 2007 - How to create a routing list, one after another?
Setting Multiple Variables with a loop
Keycode description creator
Identify text nums in scrambled fashion
Re: Excel Dashboard
RE: Excel Dashboard
Truncating a VIN
# of Copies
counting values only once
Possible to get a time/date when a cell is written?
Tex-to-column
How can I do to create a one-line diagram from two columns?
percentage
Second workbook (book2) opens automaticaly
Date reverts to numeric format
Pivot Charts
Calc duplicates
Excel 2007 compatibility issue - speed between cells
Basic file, data only once to summary?
Pivot tables and percentages
Unable to open .xls saved files by other users.
"File Open" box Excel is full screen, how can I size it down?
Excel hangs after using "Send to mail recipient (as attachment) "
how do I work out age in years, months, days in excel
List with files and sub-dir + comments that can be updated
"Dynamic" hyperlink
Alphabetize in multiple columns
Calcution with two conditon
Addition based on left column
Additions
Why are my header & footer overlapping text?
macro help
Help with Dates in Excel
Concatenate formula
Concatenate formula
excell file size
Named range labels in formulas
Is there any way to get the dynamic hyperlinks working in PDF expo
excel is making binary changes without adjusting date&time
Fill-in formula which calculates automatically
Shortcut keys for copying data down 29,000+ cells
How do I build a calendar from an excel table of events/dates?
Copying data down 29,000+ cells---Shortcut
Pivot ... Drag Multiple Fields from Field List?
Replace with wildcards
Pivot (Data Items "Count" vs "Sum")
listing unique values
macro for chart data range extension
Re: extract duplicat values
retaining email addresses
Password for cells and Password for sheet
Convert julian date
Using INDEX and MATCH in an Array
Formula Help
FLOOR FUNCTION
How to highlight what's different between two columns
"GWXL97.XLA could not be found"
filtering dates in a Pivot Table Report Filter
Special Financing Calculator Help Please
Pop up formatable positionable message box when hovering over a ce
Need Date Formula Help
Complex match
FAO VBA Code MVP's!
RE: Adding an "X" or Check to a cell by clicking on the mouse
RE: Date to text/number Conversion
RE: Adding an "X" or Check to a cell by clicking on the mouse
RE: Adding an "X" or Check to a cell by clicking on the mouse
RE: Date to text/number Conversion
Date to text/number Conversion
Adding an "X" or Check to a cell by clicking on the mouse
Excel 2003 Clipboard Question
Personal.xlsm
Subtotal placement issue
Center across selection frustrations
Cascade Drop-Down Lists?
Help please!
Multiple text search in a cell
Sorting Column A & Include date in the Entire Row
Variable statement
Quick way merge 2 databases using a unique field.
how do i set up a cash in hand statement in excel, money withdraw.
Experienced Users Chime in on Recommended books for EXCEL 2007
Finding data amongst empty cells
Pivot Table Calculated Field - Sum/count
Date Picker & Slow Open
cell opens the linked tab/destination
How to create a master sheet of several (12 maybe more) worksheets
Modify excel office online template
get cell to automatically change colour depending on text in adja.
Loss of Right Button Functionality in Tabs
28/10/2009 10:00 am calculate transit hours 75 hrs = total calcula
how to remove every seventh column from excel
location of a link in server
Calculating duplicates
"if" formula not working- seems to be formatting
Refreshing ODBC data on Protected Sheets
Editing large numbers of cell names
Default format of cell comments
min ,max,average
min & average 52 work sheets all read zero
Can't access cells
check box macro
Shared Excel Update Problem
Referring to cells on a different worksheet
need to display 123,000 instead of 123000 using mail merge
excel passwords
Copy Sheet #'s, but leave cell reference
i just need to make a sheet for Ticket # and name with who sold i.
I tried, but...
Close all files without exiting Excel
Turn off prompts
SUMIF no longer working
Pivot Table Calculated field error
excel formula won't copy down
Deriving winners from a list
alter code to apply to range (links cells w/ row insertions)
RE: cell to stay same
searching for text and returning information
ToggleButton to Unprotect/Protect all worksheets
How to store a connection with parameters into a workbook
lock not working in Excel 07
Formula Question
x if six cells are blank
How can I show and print text with line breaks within cells?
Re: 2003 spreadsheet - gridlines won't print when opened in 2007
removing #na from a sheet
Code Help for naming a worksheet tab
Auto code to add tab
Is there an AVERAGEIF function in excel?
How to open XLSM file in IE9
VBA filter ?
Calculating acruing interest
Sharing or Emailing Macro
Importing Access database into Excel 2007
relative defined name references?
Need V-Lookup to Return A Row, Not Just Single Value
Simple concatenation including date
Variable substitution
Completing Formula For Hours Worked
How to get the full list of drop down menu
Images in embedded worksheet do not print correctly
StatPlus
Dates for Hyperlinked Documents
Conditions
Converting hijri date to gregorian date
Importing pdf files to microsoft excel
MS Office XP SBE & Windows Vista 64bit
how to add 3/4 as a fraction
web query
Excel 2003 Conditional formatting challenge question
Conditional Formatting Font Change
insert rows automatically to avoid overwriting
excel
New link
Linking docs
Using percentages
Rows to Col Macro Question
Jululian Excel
Impossible? dynamic copy/paste
Editing cell names
how do I put in a name for the columns?
Find first empty cell in column
How to search for a code, and have the correct information auto fi
Looking for assistance for an unusual conditional formatting probl
Constant Data to be used for different possibilities
Finding First Empty Cell in a Column
Finding First Empty Cell in a Column
Find first empty cell in column
Help with Excel
Counting ?
Counting 3 columns?
printing setup in excel 2007
printing setup in excel 2007
printing setup issue in 2007
printing setup issue in 2007
How can I attach an explanatory note to a data cell?
formulas
VBA
CountIf formula
Jululian Excel
Calculates field in pivot table
Excel Function
Header in row to column
How do I lock certain cells in excel 2007?
Sort data in rows to column
Different cells that need to sum in one
Convert SPI Open Access Spreadsheet
max,min,average
Number format TextBox?
What is the simplest IPC from Excel VBA to a .NET app?
How do I disable WizardQuit Macro?
User Defined Functions
Add or Delete borders of a cell by clicking on that cell
If cell empty delete row
Automatically Incrementing Row in Formula Copied Horizontally AcrossColumns
Automatic data entry problem in EXCEL 2003
how to average a range of cells and ignore #div/0! answer
Is it possible to have non-printing characters in Excel?
function query - not sure which one possibly vlookup
sorting rows
Find Cut and paste
lookup functions
Deactivating a macro button
Want to keep 'historical' data using formulas
unreadable content with no further actions
Excel Spreadsheet
Telephone Bill
Using Intersecting Names for lookup
How to change number formatting?
Jululian Excel
Compting 99% of a col range while autofilter is on.
getting data from a range in another workbook (excel 2003)
Printing multi-pages
compare 2 columns of numbers and place the matched numbers in a 3r
Copying formulas to tables
Drop down list
Time Format and Calculate difference in time
Using 2007, cannot open old 2003 files
How to auto create "backup of filename.xls" in Excel 2007.
Date percent complete as of today
Sorting in excel 2000
external data
Look Up a number
Populate Serial Number
Automate External References
Using SUMIF and AND functions simultaneously
subform with 2 requirements and 2 fields
subform with 2 requirements and 2 fields
Use of Wildcard characters with replace
Collating Data from Many Worksheets Within a Workbook
VBA: Collapse Column Groupings
what is the best way to pull in external data from SQL table
Sumproduct with multiple criteria and both numbers and strings
putting date in a cell referring to the tab sheet
formulate email address based on last name & first letter of first
Print Preview and hard copy cut off in mid page
How to make a cell filled w/color more transparent?
Count in a Cell Reference
Conditional function row formatting based on columns values being
Count Distinct
Help locating Object Libraries
Set Excell 2007 to open new from G drive
Pulling Data from other excel workbooks?
Can I 'hyperlink' within a workbook from the first worksheet?
Hyperlink failure after saving document
Counter Problem
Summing Based on Conditions using Array
I need to take partial information from two columns and then add t
Hyperlinks
why does tab button jump pages in Excel instead of cells?
How do I sort blocks of information in Excel?
Macro error opening text file
Save as .xls causing format loss
how to have cells automatically fill when entering value in ref
Links between workbooks in excel 2007
how to have cells automatically fill when entering value in ref
Array Formula Syntax question...
Find and Replace
how to have cells automatically fill when entering value in ref
Paste Link from Embeded Exel
how to have cells automatically fill when entering value in ref
Help with a Macro
sumif and left
merge two excel files like in word mail merge
How do I open a workbook at startup
Unchanging Cell Color
How can I assign a different value to a number (for ranking)?
Excel drop list reference?
Multiplying 2 columns with IF
How to combine more than one condition for CONDITIONAL FORMATTING
changing font using conditional formatting
Sorting by format - is it possible?
Slow to open
creating a form to search for books in a library
Weekdays between two dates in Excel?
How to import external data into excel?
COMPATIBILITY CHECKER ON 2007
Hide Names
Images do not resize when using 'fit to' or 'adjust to'
how do i get tick boxes on excel 2007?
If and Vlookup Query
Inconsistent Conditional Format Copying
subtraction task
can 2 tabbed sheets be view at once
Hyperlinks from Excel to .JPG files are opening in an explorer win
Selection problem
Microsoft Ofice Web 24 Hr Time Loss
Problem with VLookup
How do I get rid of a series of hyperlinks in a column or row
Return multiple values in one cell doing a single value lookup
how do i set them colors to aqua, accent 5, lighter 80% in excel
wrapping text in cell
Path, File & Sheet Tab
Comparison Operators in formulas
can a drop down list be set up to enable multiple selections?
How do I repair corrupted data from a restore in Word and Excel?
Can you combine if and vlookups?
How do I display trending data in different colors (up=red)
Flowchart shapes don't scale with "print to fit" function
Fill color palette remain on screen
I need to creat a pop up window when I open an excel sheet.
Formula help: Duration Without Weekend Days
how do i remove the 0 in the cells
Filter
how do I set a maximum characters in a specific cell
Pivot Table?
I need to import my Excel Mailing list into mailing label format.
What is causing "Too many different cell formats"?
Excel
Using the Countif option
Sheet copy limit
How do I turn off Autofit
Embed Multiple Worksheets in PowerPoint
Insert blank row macro after a break in a group
Can Excel duplicate Access's PivotTable Detail Data feature?
Can I simplify a VB code??????
Logo Not Visible
How can I change the size of a check box in excel?
Formula Assistance Financial system export
SORTING DATA IN TABLES
Excel is asking for a password while I never set one
VBA to break out worksheets from a workbook
formula to select value from 8 cells
Conditional Formatting
Sorting by "High", "Medium" and "Low"
Validations
changing case
Excel 2003 Database Query
Can I restrict a text column to a specific number of characters?
Visual to copy format one row down when data entered
Charts do not update
Excel 2002: How to look up for the last entry ?
Fill Handle doesn't increment
Copy Cell From Subtotal Line To Detail Line
IF & AND combination not working
How to convert vertically address list to horizontal
Cell empty if value is 0?????
Inverse Ranking
Changing Data Links
Conditional Format Range of Cells
SUMPRODUCT issue
hyperlink to cell based on formula results
Transpose or Macro?
Pivot table cutting information of a part of the information
dynamic range ??
Faulting application excel.exe
Possible? Copy/paste to&from moving sources/destinations
address bar in a EXCEL 2007 FILE
How to keep "1:1" as text
How do I stop Excel from copying date format from cell above?
How do I refresh in Descriptive Stats in Toolpak add-in?
VBA - Can I?
why cant I merge cells in a reguler spread sheet
2 conditions
Split cell based on UPPERCASE text
RE: if question
Writing Macro to Run after changes are made
Sorting
How can I change default file for saving documents?
Questions on using conditional formatting
template for machinery hire out scenario?
Vlookup Erros
nested function to select value from 8 options
How to get date to move down to next cell & other referances, macr
protection on excel 2003
Sheet Tabs & Right Clicking
Autofilter
xlsx file synchronization
Net Send to Many by macro
Looking for a simple interest template
Convert multiple excel files with multiple sheets to PDF - how?
Excel 2007 - how to do PivotTable on filtered, visible data only?
Column Information
Excel - Creating Tabbed Delimited Text File - Need help with blankcell output
LOOKUP help....select like names and enter sales
Excel 2007 with no increase in rows and columns
Subtract Min() from MAX()
Copy headin
Password Protected Files
Sorting multiple rows...
Reformat dates
"Fit for Excel?" checklist for applications
Changing from lower case to upper case
copy sales volume data from sheet 2 to sheet 1 by sales person
If you have office 2003 and just want to upgrade Excel
Pivot Chart Bar Chart?
Update Files Automatically with Links
Upgrading just Excel
How do i add a pop up picture in 2007
Excel 2003 Clipboard
Picture displayed when item selected in a different cell
how to transpose multiple rows into one column with row labeling?
how do i unproctect a work sheet, forgotten password
When Opening Excel 2003, it opens but displays a Gray Screen-No ce
Password Protected Files
Launch Click Event Using Application.Run
Converting word document to excel
Filtering issues?
Has anyone set up a training recrod template?
COUNTING GROUPS IN ONE COLUMN
average range growing
Urgent help needed!!! Saving in Excel 2007
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm
how do i make #'s auto and 000 behind large numbers
how do i unhide columns after saving in excel 2007
Sorting a spreadsheet by strikethrough?
ecell
TextBox linked to cell?????
time = say 05:00, how do I change font colours at 15 minute incrim
Drawing objects in Excel 2007
Aging Report
Workbook protected itself?? 2007
aged receivables
How to copy a whole Excel spreadsheet page in 2007 vs 2003?
Very large database (600k rows, 40 columns in xlsx)
In excel how do i get from this 44345678912 to this 0345678912 us.
Problem with filtering columns in Excel 2007
Auto-Completion on Drop-Down Lists
Print a worksheet to a page
How to count the numbers in a report
Cut the last 20 characters out of a text string
finding a value with parameters
Collating multiple .csv files into a single work book
Copying from different files into 1
cannot see the content of a file
opening tif in link
Split numbers and text
Using another .xslx file as an external source (and how to update)
Text to number conversion with trailing -
Pivot Tables and Fiscal Year
i do not want colored cells print
Translation Problem
excel programs stopped my security updates
password protect allowances
v look up and rounding
Column count if's
Sum Column C for duplicate account number in Column A
Set properties in Excel comments
msgbox in sheet
Error Message on Excel
Printing Faxes from Excel 2007
not printing correctly
change view side by side to on top of each other
get source data from pivot table
Find/replace format preview asterisk
Excel Macro with custom subject line
excel 2002
Password Protect Sheet with formatting allowed
Top Percentage Problem
vlookup question - bring in all values?
Autofill
how to create a self calcuating aged receivables?
SUMPRODUCT Problem
Subtraction that doesn't produce an error
Array lookup
Excel 2003 - Inquiring about the benefits of a higher end PC.
"indirect" cell ref change....
Data is not refreshing-Excel 2003
Seperate last name from a cell with full name
Shared worksheet saves blank files
macro and automatic page break
How can I open excel template form in a shared file using vista?