View Full Version : Microsoft Excel Misc
- cannot get to borders of worksheet to drag it into place.
- pivot table
- Excel 2003 Power Programming with VBA
- Sorting on years and months
- Possible damaged links to other files
- Find & Replace
- Time Format, change the separator
- Hiding ABC and 123
- Putting pictures into cells
- Not Enough Memory
- Excell: Column Changes
- find
- Columns
- Error 0167:BFF9DFFF
- Sorting cells by date
- Counting dates
- Inserting Text from a Cell into Formula
- Cannot open file form File Open menu
- How to set trial?
- Repeating cells
- Match w/more than one result
- Data Analysis Toolpak--Descriptive Stats Question
- Minimum cost, MAXIMUM returns!!!
- Excel Histogram - Input Range must be contiguous reference
- Minimum cost, MAXIMUM returns!!!
- Memory Problem
- Horizontal Page Breaks
- Add times and genral numbers
- Variable format is not what I expected?
- Leading Zeros and Text-to-Columns
- Function Help - List of RANDBETWEEN results
- better reporting system?
- Minutes to decimals
- Finding links and getting rid of them
- RADIO BUTTON OR SCROLL BAR QUESTION
- General
- Excel Formula - Depreciation calculation for opening balance and additions
- Swaped sides
- Excel 2000, Close, Maximise, Minimize buttons disappeared
- Repeating column layout is wrong (and PDF worse)
- Looping through Pivottables
- remove hyperlinks
- variable number formats
- Show more than 23:59:59 hours with time calculations
- Counting occurances of pairs of values
- Problem with connection ODBC
- Graph source data
- File recover
- Dragging Formulae down the sheet
- Help with a formula a second grader could probably write!
- Excel on top
- Weed out words using Excel??
- Weed out words using Excel??
- counting a range
- .sxc files
- Printing - Various Workbooks/Worksheets
- Sort Macro
- Counting words in cells
- Time Formulars
- PivotTables: avoiding nesting in 2 row variables
- printing the saved date/time
- Worksheet Event Change Macro
- Selcting a picture as part of a range
- Checking if values are between values
- Reading Excel file from IE
- Different Print Setup Same Page
- XML to Excel
- Specify a range rather than a specific value with COUNTIF
- Evaluate result of CONCATENATE()
- Precedence Issue?
- Doubt in " HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET"
- Setting custom header widths
- Summarizing Filtered Data
- copying excel 97 Macro to different machine
- Pivottable Refresh
- CUSTOM TEXT FORMATTING???
- VLOOKUP won't work within SUMPRODUCT
- excel2000-password shared file over wireless network-crashing
- Excel bug?
- Replacing information
- Re: Auto Filter Sorting Error
- Re: Mulitple users for one file.
- Quick Formatting Question - Column Layout
- Can I sort a column by its 'formatting'...
- FORMULA
- Re: rounding
- charts not showing up in excel
- exporting 97 to 2003
- When I moved data from one workbook to another...
- Nesting If Statements
- MS Query installation error
- error message
- Get rid of Office Clipboard
- VBA Help
- Average and Mean Formula needed
- Nested Subtotals in Excel 2003
- Re:Advanced Printing in Excel
- Keyboard in Excel will not work
- Re: Sum the highest 8 scores from a list of 10
- Print Preview Print Button Greyed Out
- Findlink.zip file
- Aligning multiple checkboxes
- ExKel
- Need Help
- Formatting Negative times
- DSN
- Re: Consolidating and filtering
- Forms and databases
- sorting by date
- Bad Macro References
- Unable to read file
- Solve function?
- Counting for a value in a column, after a Filter is created
- Values not being recognized as dates
- Auto sort in real time
- pushbutton to print all sheets
- tabname=A2
- Re: printing problems
- multiple criteria
- send 1 worksheet in a workbook via e-mail
- Desktop shows through instead of sheet
- Re: send 1 worksheet out of workbook
- Printing Problem
- Work Sheet Question
- Disable Copy/Cut
- Named Ranges - Slow Workbooks!
- Default Data Type for TXT and CSV files
- Excel 2002 - Changing Variables on formulas
- Help Creating A Formula
- Convert number to time format
- Excel 2002 - Formulas containing Invalid External Reference
- show sheet tabs
- Formula: Search for Dates and Sum values
- Autocomplete
- Managing a Large Workbook
- Cannot insert object
- Problem with custom formats
- Excel Guru available
- Combine date and time to a single cell
- Missing Toolbars/Menubar!
- copy sheet1 from bookA to bookB
- Selecting Refedit value
- Due date
- How to distribute Excel/Access App?
- email one sheet
- How and where can I learn advanced formulas?
- Cannot Calculate the Formula
- time format
- ATTN: MR EXCEL GURU
- Himanshu's time format
- SIZE OF EXCEL SHEET
- excel wont open file
- excel wont open file
- probably very simple
- corrupt file
- accidently deleted excel program during recovery
- Auto Invoice numbering
- color coding by order of value (highest to lowest)
- pushbutton
- Sort Macro
- INDIRECT formula probs!
- tabname=A2 (part2)
- Inconsistent conditional formatting
- IF function
- multiple lookups?
- paste in excel
- count only R
- Look up a value
- Checking for repeated content
- Macro to delete certain value
- Displaying itmes in list that have a quanity next to them
- Copy down vlookup Formula
- copy worksheet via pushbutton
- conditional format
- need to total occurances of Long distance Phone Number
- insert rows that retain formulas of rows above
- query ar remedy
- Concatenate Problem
- comments area shows black box on one machine
- test on empty cell
- Membership retention
- Sharing a workbook
- Excel deleted during recovery
- Make rows be columns & vice versa
- Fill Series With Filter On
- Weed out words...part 2
- Excel errors--account specific
- Too many different cell formats
- Automatic Review Toolbar
- Row Height Adjustment
- Deleting Empty Rows
- How can I display a cumulative total of hrs as hhh:mm
- problem with amortization schedule
- Re: Help! My Excel is broken!
- IF funcitons
- data validation - to enter unique value in the cell
- Misc
- Lookup sheet
- name conflict
- checkbox or radio button
- menu bar is gone
- Diagonal Pivot Table?
- Excel 97 - unique values in one column
- Finding Last Cell value in row
- Detting up subtotaled income statement
- Printing comments using a named range as cell name
- Sheet tab text color
- Could not reestablish DDD connection
- Sheet tab text color
- Save as web takes away my chart
- Printing more then one copy in excel
- Question on macros
- Macro question
- Excel - Formula problem
- Personal Macro Workbook
- Pick lists
- Control Comboboxes Skip to letter
- changing the default cell format
- Re: calculating dates
- Re: calculating dates
- Re: Conditional Formatting with Named Ranges
- ms097.dll
- Cursor in A2 upon opening sheet
- Re: Sheet tab text color
- Excel 2002 Display Directory contents Listbox
- I guess only super computer can solve this
- Lookup formula
- help with lookup formula
- Changing default email
- help with lookup formula (SHEET 1 attatched)
- help with lookup formula (sheet 2, not a double post)
- Query Wizard not returning data
- vlookup problem
- How do I keep two Excel Files open at one time--once I click on another excel
- Please Help Vlookup
- Re: Help! My Excel is broken!
- Problem with spreadsheet
- Comment Indicator
- Display and calc of time formatted colum
- Convert Excel sheet to Database?
- text file to excel
- Long "Print title column" cells truncated on multiple-page prints
- Emailing Query Results in Excel
- Selecting and highlighting
- Deleting Blank Rows Subject to Criteria
- Formatting Worksheet Tabs
- A question in need of an answer
- toolbar customization
- how do i display excel results in vb.net textbox
- Open Excel with a particular sheet to be displayed first
- Excel Check Box problem
- Pivot Table - Monthly time series
- Excel: Autofill list deleted
- Excel formula problem SUMPRODUCT
- Can't start Excel!
- Web Query Update
- How do I automate the opening of hyperlinks in Excel ?
- EXCEL WORKBOOK LOCKING
- disabling Upadte Links message
- Inserting a LOGO into an Excel 97 header/footer
- Slow Saving Workbook
- List manager problems
- including dblink in a query to retrieve data
- Snazzy Add-Ins
- Excel 2000 Track Changes
- Count totals with date
- Conditional Formating on Row
- Graph is getting resized
- Excel to word.
- Linked Workbooks
- error messages
- Need help with AVERAGE formula
- lose text formatting when copy text from one cell to another
- Extracting Information 1 column to 2 columns
- Search...
- header question
- Excel - Return column alphabet from column number
- Using More than 7 if functions in a formula
- Get the name of the version
- Excel corrupted - automation error
- comment boxes
- calculations
- Macro - File Save As
- Multiple Fill Series
- Huge file size
- Adding color to pivot tables
- Auto Filter numeric values.
- emailing indivual worksheets
- Auto Save
- Autofit rows - excess space above text in rows
- tick
- shortcut for end of sheet
- Electronic Signatures?
- Counting the frequency of multiple values within a column
- Question Box ?
- Excel Tracking
- form fill-in and text manipulation
- Date format problem
- Recieve data loss error
- Workbook will not display properly
- Naming and Symbolism
- converting minutes to hours
- Apology - Sorry about the multiple posts same subject,, system issues, didn't realize
- Saving as A WebPage
- Inactivity Notice?
- Referencing worksheets in order
- Representation
- Columns numbered instead of alphabetical.
- Rounding time to the next minute
- Comparing two lists for uniques
- Footer on page 1 only
- Frank Kabel Please Help !
- changing letter sets to numeric equiv
- Print Worksheet on A2 sheet using 4x A4 sheets?
- Using IF with a list
- Re: How to have vba automatically tab to next field when on web page
- How to use more than 7 IF functions in a formula?
- formula help
- save and close
- Date functions?
- Non number cells
- Getting data from Access into Excel
- Re: create new workbooks from sheets...
- Merging
- Protecting a field
- using underscores in file names instead of spaces
- feet and inches
- sort data inside combo boxes
- Calculated field in pivot table
- Excel 2002 Formula Problem
- Querystring
- dave peterson, just responded to your comment of 3/31.
- Mouse Wheel Won't Scroll in VBA Editor
- Non-Automatic Link Updating in Excel 2003
- Restricting number of viewings?
- Change default Settings for Comments
- Paste from Excel to a text box as straight text
- Excel 97 Fails to Open File
- rounding off
- XIRR
- Problems when saving worksheet into tab-delimited text file
- Sorting Question
- Excel main menu
- Screen gets jumpy while macro executes
- Random numbers formula
- Day and Date
- Getting Started Section in Office 2003
- Auto date stamp once only
- Error with Load command on UserForms
- Stemplots
- Bloody Toolbars
- Auto Filter in Excel
- How do i attach a custom menu to a workbook???
- urgent..pivot table
- O.T. - But maybe, Not Really!
- pivot table ????
- Saving in PDF format -excel
- power point
- help me in powerpoint
- Numbers beginning with 0
- AVERAGEIF
- count a range
- opening excel files in outliik express
- I do something wrong with SendMail macro...Please help
- Copying Data
- Frank Kabel - Multiple Fill Series
- Difference between 2 worksheets
- dates
- Cannot view cells that contain 3 or more digit numbers
- File in Network server not closing
- Export to file only values > 0
- Maximum file sizes
- Shortcuts
- data fill sheet 2 from sheet 1 based on criteria
- Show Numbers of Cells/Add number to cell
- Dependent check boxes
- many rows into discrete rows?
- Working with date data
- Using "Like" expression in Parameter Query (Query Tool)
- How do i write a goal seek function?
- Retail Pricing Rounded to nearest 9
- Could excel replace accounting packages or other management software?
- Separate letters and numbers in postcode
- installing worksheets on other machines automatically
- VLookUP
- Time Calculations
- Excel bug?
- AutoComplete from Validation List
- Count Function
- Logic of xlCellTypeBlanks i.e. "Blanks" period or "Blanks" in used range?
- True/False Statements
- Excel to Outlook on condition
- Excel docs won't open from clicking file
- enabling macros
- Multiply columns
- Display decimal with multiplier
- Matching lists to give a new list
- Combining data from 3 fields (colums)
- Re: Show time when looking for Max value
- populated sheet, saved blank
- Pivot Table vs Data Source Format
- Exporting leading zeros
- can't rename a sheet
- Update Links Error
- Remove Group Box border lines (without using macro)?
- Excel 97 Fonts
- Having a Row Appear as the First Row on Every Page
- Contains command in a Formula
- Copying file to another location
- Exporting Excel document into Acrobat
- File type on Open document window
- Problem in setting Excel formula through VB
- returning ALL values that match
- Amount of time between dates
- update filename in macro
- Re: update filename in macro
- range checking
- Excel 2002 - How to delete all defined names {references} in workbook
- COUNTIF problem with Circular Reference
- Allow Query Refresh Prompt in Excel
- autofilter max # of entries?
- How to update a linked spreadsheet without opening it?
- Trying to convert a Time Format 1:24:23 to total amount of
- Opening Multiple files in separate Excel folders
- Turning off the automatic Copyright symbol
- Format Cells
- Printing problem
- combo boxes and list boxes
- excel document is automatically changing colors
- Combo Box Selection Format
- Office Service Pack 3
- Excel will not allow me to use the funtion MROUND,
- Workbook not Maximizing
- text color???
- Re: Sum of one column if dates in another column are in certain month.
- How to make Excel treat the dates AS DATES which are taken from a Web Page ?
- Excel 2000 - Data Validation/Dynamic range drop down menu problem
- Formula to calculate affiliate commission
- getting rid of the "Comment Stored as Text" indicator
- Re: looking for appreciaton formula
- Excel Macros
- Re: looking for appreciaton formula
- problem with formatting
- Sum of one column if dates in another column are in certain month.
- Toolbar Buttons
- Opening a New Excel file?
- Pivot Table - Group Headings
- Macro Subroutines
- Re: auto correct entries
- Shadowed Characters
- =(Cell) formula does not work
- Printing A2 size using A4 paper size
- Re: Display a floating toolbar when opening a workbook
- VAT calculations
- How...get a cell to offer options
- How do you convert Lotus 123 files to Excel?
- self extracting download help
- formatting cell in vlookup
- Protection of Command Buttons
- dropping leading zero's from .csv file
- Need formula to check data in 2 columns to sum 3rd column
- macros
- Linking Time Sensitive Data
- How to reference cell in different worksheet?
- Macro for selection change
- Red triangles in a cell but not comments
- Date will not load
- visual basic message telling me to enable macros
- Mail Merge from an Excel Worksheet problem
- named excel lists
- Need SOMETHING that updates a linked spreadsheet automatically
- time-phased budget
- VBA to adjust Row Height
- EXCEL
- Locking Toolbars in Place
- drag to copy and change only middle number
- new xls book -- problem opening the workbook
- Footer Date Format
- Absolute vs Reletive
- Auto time recording in another cell for data entered in one
- Summarising per page
- re post range check
- How to select a sheet and input data into certain cells
- default colours in excel
- Use Goal Seek or Solver ?
- Easy Money - RETRACTION..PLEASE READ
- Organize chart labels automatically
- Excel - Combo Box problem
- "Avoid Inserting Rows / Columns"
- IF, OR, CONCATENATE Formula
- doc w/ same name open?
- Next without For error Message
- Controlling automatic rows for inserting in Excel lists
- Counting Data
- counting consecutive days
- Format a cell as seconds
- Quick way to shade alternate columns?
- More Columns
- MSQuery requires Access?
- GetPivotData
- STATUS BAR SIZE
- Need help auto-updating chart data sources.
- disappearing toolbars
- Forecasting using SUMPRODUCT and dates
- Excel
- Excel 2000 vs. Excel 2002 - Opening Files
- More Rows
- CELL FORMATTING
- Removing trailing zeros
- Deleting Formulas... After using =VLOOKUP
- calculating a variable percentage?
- How to do conditional validation on one cell, dependant on specific data in a second cell
- Pivot Tables
- converting .dat files into excel
- Adding color to Pivot table
- Buying Digital Signature to Bypass Security in Excel
- shading cells that are not consecutive
- Excel Crash when using set command
- multiply workbooks opening in 2003
- Function for hrs:mins:secs:frames for timecode calculations
- Using Excel data to create mail merge/report
- Toobar Buttons (2)
- Replacing Cell Contents
- Tools/Options/Calculation/Auto Problem
- Excel in Window 95 environment
- replace lines order
- Dates and Time
- Comma Delimited (CSV) Files
- percentage symbol
- How to set up an option button?
- EST/DST Time
- dragging array UDFs
- Recovering last saved version?
- insert blank line when text changes
- Office 2003, Excel 2003
- Need help for a specific find & replace
- Auto filling of form letters
- Unwanted Link Msgs & Errors
- moron who knows nothing needs formula
- Use cell value as cell address
- Headers/Footers
- re-try..excel wizards!
- Splitting a cell???
- Absolute values
- Heades & Footers
- Calculation formula needed
- opening an excel file
- Changing page orientation within a worksheet
- SendMail version 2.2 for Outlook Express
- formulae
- References to sheets from cells???
- opening spreadsheet problem
- to many formula
- missing button on toolbar
- Create an XML map?
- How to get this marco going?
- Excel 2000 footnotes and cell superscript number
- using hyperlinks or macro buttons to time stamp
- Copy Down
- Copy down the same content of cell
- Replacing text with number.
- Do You Have a Digitally Signed Excel Sheet?
- deleting all html from excel files
- preventing excel from launching a new browser for each hyperlink
- Windows Keys: Help Request
- SendMail 2.2 : Thanks Ron
- Fomrula with 2 pages
- Counting values in arrays
- Excel file with macros involved really bring in danger?
- Trying to make part of an output in another cell italicized.
- Convertina number, say 110 hours into amount of hours
- Complex numbers in polar form.
- Excel Newbie - page break problem.
- COUNT items in a list
- Document Tracking
- Excel VBA Password project keeps asking on close
- Dropdown Box Based on IF Statement
- Use of Monotype Sorts Font and Value 4
- Need Macro
- Sheet Optimizer
- Pivot Table : First function ???
- Two Text Lines in one Cell.
- Row Height and Column Width in millimeters
- need help opening .wks files (works 2000 -> excel xp?)
- Chart in Excel
- advanced filter
- Re: Data | Filter | Advancefilter
- Handling missing data in IF/MID formula
- Daily Importing of External Data using Web Query
- Excel and Metastock
- Excel 2003 - workinf with SUMIF for a range of dates
- Excel question...
- Excel XP Word Wrap Problem
- Current time for data entered in column
- Formatting cells according to arrays
- transpose music key
- excel vba - set "if name = ?" password to show data
- Indian Comma style
- Excel charts on a webpage
- Refreshing ODBC link in Template
- Error 13 Type mismatch
- linking multiple workbooks
- Excel Security
- Sorting by a custom list
- Got "file could not be accessed" error while opening an .xls file through IE
- Remove the password?
- Toolbars
- Comment boxes
- Missing Title Bar
- Converting wb1 files in Excel 2002
- Pivot Table Calculated field
- vba formating
- NameBox defintions
- Printing Multiple Documents
- Cell Duplicates
- =IF VLOOKUP Question
- Protecting Command Buttons
- Shadowed Text
- Removing multiple hyperlinks
- Record COUNT missing when using Auto-Filter??
- tracing precedents and dependents
- Reading from test.csv file
- Subtotal not displaying Grand Total
- match column for value and return next cell value
- Worksheet prints differently on different PC same Printer
- Re: Aborting from a "Before Print" Event
- Importing tab delimited file into excel
- Macro to hide details of groupings
- How to search closed workbook for number?
- cells as a picture
- Re: Changing a worksheet reference in a macro
- Excel drop down menus stopped working in IE
- Working out positions based on time
- Re: XIRR versus IRR
- Excel 2000 auto-save add-in
- Re: XIRR versus IRR
- displaying a number like 1/8,000
- Copy worksheets from file A to file B
- shared on a server
- Project Management Template for Excel?
- Pivot Table Sort
- Suppressing auto format in Excel
- "Average" calculation formula needed
- Visual Basic Error
- arrow keys
- Excel Lookup Problem
- two-way links / references
- Moving Reference Cells, Keeping Formula Pointers Constant
- Formatted query
- Time & Range error
- Buttons and List Boxes Moving
- Link Paths changing to UNC paths
- anniversary
- error message on startup
- Where can I find the Text Import Wizard?
- Can't E-mail excel's anymore, Why?
- Primary Key
- DDE link error Excel freezes
- Links between files in different folders no longer dynamic
- Primary KEY
- Macro on protected sheets
- hide unhide
- Deleting rows based on font
- adjacent to highest Digit
- Query with header, detail and total
- Saving when no changes are made
- Can I add to a cell reference?
- Forecasting
- I need help making an Excel Quiz
- Excel Question: How to Delete All Blank Rows from a worksheet?
- Here is a question that nobody knew the answer...
- Double-byte text in CSV file
- Cannot open read-only document error after cut and paste
- Custom Toolbars
- MS QUERY COL HEADINGS
- Excel cannot save to a folder containing square brackets
- too manny different cell formats message
- Re: Lookup Match
- graphing
- Excel Audit Trail
- Excel sheet tabs
- Import Text File
- Need IF Formula Help
- "Contents" worksheet in a wkbk
- Purging old data from pivot table
- Cloning objects between workbooks without external reference
- color scheme
- Excel TCP port number
- count
- File Size Confusion...
- Unable to open workbook
- Satisfaction.........
- Using protection with passwords withiin macros
- Spreadsheet Disappears when opening a new sheet
- need help- count w/ multiple criteria
- spreadsheet data prints outwrong info
- Using Excel OS 9 to connect to a WAN data source
- Clearing contents without deleting formulas
- MS EXCEL - minus sign and brackets
- Remove blank spaces in an address
- vlookup table
- "cannot empty clipboard" error message.
- Sort by formatting
- Hyperlink a Visio shape to a worksheet
- Fill-in rows with specific value by conditoning.
- Create an outline
- Consequences of changing the base table for PivotTable Reports
- How do I set background color?
- Excel Help
- Data Validation
- Shift+click save button launches open dialog (& vice-versa)
- sumproduct
- excel 2000 error when opening an xls file
- getting rid of parenthesis
- Linking a range from an external workbook to a single cell
- Tab order
- need help with timer button
- Historical Share Price query
- Sort House Numbers
- Calculating Amount Due from Hours Worked
- Angled borders/text and filling in empty cells
- permission to use object denied
- Pivot Table Cache
- Comments - Formatting Print Settings on 2nd Page
- adding comment to multiple cells
- Displaying linked data as zero
- deleting duplicate rows
- Sorting Question
- Custom Menu - lunching local macro (97 vs 2000)
- Comments in Excel
- Comment Formatting - First Reply Invalid
- problem with macro
- Plans de plans dans les feuilles de calcul
- Loosing Zero's in front of number
- excel: real slow to start up
- Cell Names in Scenario Summaries
- building a health tax calculator
- Finding a filename within an excel worksheet
- Compiler for Excel
- Can you set order in Pivot Table Drop Down box?
- Drop downs w/ pop ups
- Excel 2000/ Excel 2003
- In need of horizontal sorting macro
- Changing values in a range does not update the total
- enter # 12.00 for examples and excel use 12.00000028434000
- Helf for CountIfs with combination of AND
- help with email buttons in excel
- Fonts
- Excel not calculating anything
- number to words
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.