MacBook Pro :: How To Filter Rows By Color In MS Excel 2008

Oct 6, 2010

how to filter rows by color in MS Excel 2008

View 2 Replies


Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?

Feb 6, 2009

I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.

It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.

What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.

Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?

View 6 Replies View Related

Applications :: Excel 08 For Mac - Rows Display In Numbers?

Dec 29, 2009

My rows in Excel display in Numbers (1, 2, 3) instead of Alphabetical (A, B, C). Therefore I cannot type formulas for fields using A1, B2, C3, etc.

View 2 Replies View Related

MacBook :: Lost Program Icons Are Word 2008 And Excel 2008

Feb 8, 2012

I accidentally trashed two of my icons on my icon bar I didn't put them in the trash but when I clicked them they turned into wads of trash. I don't know how to find them now?

MacBook, Mac OS X (10.5.8)

View 6 Replies View Related

MacBook :: Color Calibration Profiles - Late 2008 Aluminum Unibody

Nov 3, 2008

I did this for the Macbook Pro's a while back, but I'm a Macbook guy now. There are a few other threads with profiles but it's no good if you use a profile made from a different panel than what you have. I'm just trying to consolidate things here.

I will try to keep this post current; please only submit profiles created from hardware, not those done by human eye (meatware?) And be sure to say which panel the profile is for. Thanks to everyone for contributing and improving the Macbook experience!

How to determine your panel type/code
How to install and use color profiles

Basic tests to determine if a profile is a good fit:

Black level
White level

9C89 (LG)

See attachment ( Pro. 2.2 Gamma, Native and 6500K whitepoint. I recommend using the Native whitepoint.See attachment ( Pro. 2.2 Gamma, Native whitepoint. This is an alternate profile made from another Macbook with the LG panel. It is similar to the previous but slightly darkerjessica's profileSpyder2 Pro. 2.2 Gamma. Native whitepoint (I think - not confirmed)
9C8C (AU Optronics)

See attachment ( Pro. 2.2 Gamma. I only did a calibration at native whitepoint (honestly, if you really need 6500K then you won't be using a Macbook screen, or any laptop screen for that matter)

See attachment ( Pro. 2.2 Gamma. Native whitepoint.

View 24 Replies View Related

Applications :: How To Use Microsoft Excel With Selection Color

Mar 18, 2009

On Microsoft Excel i want to change/darken the color of the cell that i have currently selected, i can hardly see the cell that I am about to import information into.

Does anyone know of a preference that can change this?

View 2 Replies View Related

OS X V10.7 Lion :: Border Color Of Active Cell In Excel

Jul 6, 2012

Is there a wayof changing the color of the border of the active cell in excecl? 

I have a very difficult time seeing the pale green. I waste a fair amount of time modifying formulae because I'm in the wrong cell. Making it a different color or making it more vivid, or bold, would be great. 

Tried going into Apple preferences and Excel preferences, but did not have any luck.  Maybe I just didn't do the right thing once there. 

iMac, Mac OS X (10.7.4)

View 6 Replies View Related

Applications :: No Add Ins In Excel 2008?

Jan 21, 2008

There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.

View 12 Replies View Related

OS X :: Excel 2008 WTF - Making Chart?

Mar 2, 2008

I have read some complaints about what happens with some big excel benchmark or something but try this one on for size: Making a chart with 6 data points took 1 full minute to make and scrolling down after the thing was rendered, damn near impossible! seriously, Office 97 on a 486 beat this! with the right IO,, a FREE CELL PHNE could beat this! I have a brand new Macbook, smoking fast... Can we sue MS for a defective product?

View 9 Replies View Related

OS X :: Excel 2008 For Mac Won't Open - Keeps Crashing

Sep 27, 2010

Operating System: Mac OS X 10.6.3 (Build 10D2094) CPU: Intel Core Duo, Number: 4, Speed: 2147 MHz
Haven't had a problem to date and after opening a file that excel obviously struggled with for some reason, excel open briefly then I encounter the following error message. Much obliged for any help or guidance.

Error Signature:
Date/Time: 2010-09-27 21:45:42 -0400
Application Name: Microsoft Excel
Application Bundle ID:
Application Signature: XCEL
Application Version:
Crashed Module Name: libobjc.A.dylib...............

View 1 Replies View Related

Applications :: Excel For Mac 2008 Crashing

Jan 4, 2010

I'm having a problem where whenever I change a particular cell in a relatively complex spreadsheet I built, Excel crashes. The cell is a trigger cell that changes a list of assumptions to calculate a particular scenario. The spreadsheet was working fine and then, all of sudden, this problem arose. I had this same problem about 3 weeks ago and ended up copying individual tabs into a new spreadsheet and globally replacing the links so it was working. That worked okay until this most recent incident. The stranger thing is it seems I can open the spreadsheet using Excel for Windows and it doesn't crash.

View 8 Replies View Related

OS X :: Get Rid Of Dollar Signs In Excel 2008 For Mac

Apr 11, 2010

How do you get rid of dollar signs in Excel 2008. I see the $ symbol, but that only adds them. If I click it again, it doesn't remove them.

View 1 Replies View Related

Applications :: Mac Excel 2008 - Vlookup

Jun 17, 2010

One of my favorite functions doesn't work - really weird. When I get to line 50 of the workbook it stops working! It doesn't matter if I cut n paste, drag or manually input the formulae it just stops ! Every row above row 50 - it works - below 50 ... nope #value appears. So an argument is wrong - but I'm inserting the same argument that works above !!!!

Is this an Mac Office glitch or am I losing my mind

Any advice appreciated . . . Stu

edit: just realised that if I increase the lookup to row 75 the reference works up to row 75 but not beyond - weird. I can't replicate the problem on MS Office on a pc !

View 2 Replies View Related

Applications :: Insert Calendar In Excel For Mac 2008

Sep 24, 2010

I have been trying to insert a simple monthly calendar into an excel spreadsheet, but cant find a way to do this on the mac version that im running. Any hints would be great. Idealy i would like to be able to just insert a calendar for that month but if i had to insert the whole calendar each time that would be fine too

View 2 Replies View Related

Applications :: Lost Data In Excel 2008

Dec 6, 2010

Some content in Name.xls may not be saved because it is not compatible with the Excel 97-2004 Workbook (.xls) file format. Do you still want to save the workbook in this format? To save the workbook in a new format and preserve all content, click No, and then on the Format pop-up menu, click Excel Workbook (.xlsx). To save the workbook in the current format and remove all incompatible content, click Yes." Somehow I managed to not read the popup properly and just went ahead and saved (clicked "yes"). I then closed the spreadsheet and now all the work from the past 4 hours is gone.

View 2 Replies View Related

Applications :: Excel Mac 2008 Macros Support

Jan 28, 2008

I know Excel 2008 does not support VB macros, but did anyone notice that "Macros..." is still available under the Tools menu? I wonder why it's there? BTW, I saved an old file in Excel 2008 that had macros and then opened it in Excel 2004 to see if the macros are still there. They are. That's a big relief, because I know I can at least work on files that have VB code in them without worrying that if I save the file in Excel 2008 format the macros will go poof. Ooof

View 8 Replies View Related

Applications :: Excel 2008 Crashes On Saving

Feb 1, 2008

Is anyone else getting this problem? When I hit Command+S in a worksheet, Excel unexpectedly quits. Very frustrating as backing up is kind of a problem.

View 3 Replies View Related

Applications :: Making Graph In Excel 2008

Feb 17, 2008

I need to make a very, very simple line graph. In column A, I have a list of years. In column B, I have the data....numbers that correspond to something in that year. Simple, right? It really couldn't be any less complex. I selected both columns, then I went to create a new line graph, and it created a graph that had the years (from 0-2500 even though the actual range is 1973-2005) on the Y axis, and the data on the X axis. And each column of data was its own series, so I had 2 lines, which, due to the scales, was basically 2 horizontal lines. I removed the extra series (the year series), and was able to get the line to look right. It also put the column B data on the Y axis like I want, but on the X axis, it just counts from 1-33. But I want the years on the X axis. How the hell do I do this? I'm 99% positive Excel 2004 let you set the X axis labels.....did they really remove it in 2008? This seems like something that should be so simple, I shouldn't have to post on a forum to figure out

View 24 Replies View Related

Applications :: Excel 2008 Date Formula ?

Feb 28, 2009

I have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want.

I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?

View 4 Replies View Related

Applications :: Excel 2008 For Mac Save Dialogue Box Too Big

Nov 7, 2009

New to Mac and new to Office 2008. When i try to save an excel file once I click the little upside down triangle to choose where the file should save to the dialogue box which opens is larger than the screen with the save box to the right of the screen. How do i resize this so that I can see, and use, the whole dialogue box?

View 9 Replies View Related

Applications :: Excel For Mac 2008 / Finding Data

Dec 30, 2009

In my old old old excel 2003 when I was searching for some words in excel sheet (e.g. in the column) I could choose "to find all" option. So I saw all the results in the "find" window. In excel 2008 for Mac I can see search results only one by one not altogether. On microsoft site
I couldn't find tha answer also. Does anyone know how to make it in excel 2008 for mac so i could see all search results in the "find" window?

View 3 Replies View Related

Applications :: Data Analysis In Excel 2008 In Mac?

Jan 7, 2010

How do I get data analysis in excel 2008 in mac?

View 3 Replies View Related

Applications :: Excel 2008 Error Message?

May 21, 2010

This might be the weirdest software bug I've ever seen. It looks like maybe a programmer for Microsoft was having some fun. Here is what happens:

A spreadsheet that a coworker uses for purchase order requests has several cells in a column with a SUM field that calculates the number of units to purchase multiplied by the unit price (not sure why they use SUM for just a multiplication, but I don't know if that matters).

If you delete the contents of one of these cells and type in something else (or just type something else without deleting first), then exit the cell, an error message pops up that says, "You can't do that!!!!! So quit trying!!!" with options Cancel and Retry.

Retry doesn't do anything, Cancel clears what you put in the cell. Copying and pasting the cells into a different row creates the same issue.

I've attached several screen shots to show steps to reproduce:
Picture 1 - column F has the suspicious cells
Picture 2 - the calculation
Picture 3 - after deleting the contents
Picture 4 - enter some text, before exiting the cell
Picture 5 - error message after exiting the cell

The only workaround was deleting the entire row and entering those calculations again. I have no idea what to make of this, and internet searches have come up empty.

View 1 Replies View Related

Software :: Excel 2008 Condition Formatting

Jan 20, 2010

I am running Excel 2008 on my MacBook Pro. I'd like to conditionally format some cells in a single column with a condition format like: <COndition 1> AND <Condition 2> AND <Condition 3> However, the (paltry) help seems to suggest that I can only do a logical OR of the conditions. It says "If more than one condition is true for a cell, Excel applies only the formatting of the first true condition to that cell."

Although that is a bit vague, I certainly can't get it to do logical AND through the graphical interface. Google has failed to find me the answer. Sniff.

View 1 Replies View Related

Software :: Mac Office 2008 Excel Versus Numbers 1.0

Nov 15, 2007

The planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.

The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.

View 25 Replies View Related

Software :: Disable Excel 2008 Blank Sheet?

Nov 2, 2008

Excel opens up a gigantic size blank document anytime I launch it. I gather there is no way to disable it giving me a (useless) blank document. But is there a way to not make the stupid document take up 90% of my screen?

View 17 Replies View Related

OS X :: Paste Link A Graph From Excel 2008 Into Powerpoint

Oct 24, 2010

I am trying to paste link a graph from excel into powerpoint. The paste link option is not available. I also tried to paste link the data from the spreadsheet part of excel to the graph slide type in powerpoint so it can create the graph. The spreadsheet in excel is formula driven so it pastes with ref errors.

View 2 Replies View Related

Applications :: Excel 2008 - Reset Formula Bar Position?

Mar 19, 2008

The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in "View" and also tried re-loading excel, but it is stuck. Does anybody know how to reset the formula bar position?

View 6 Replies View Related

Applications :: Excel 2008 Extremely Slow At Plotting

May 20, 2008

I'm trying to use Excel 2008 (I wish I still had my old 2004 CD with me) to do some plotting and it's near impossible. I'm plotting spectrum data off of an optical spectrum analyzer, so we're talking some 3000 data points. I select the data, create a chart (annoying as hell in itself) and once the chart shows up I can't do anything without at least a 10-20second wait, I can't select an axis, move the chart, rename it or anything. Why is this so slow and is there anything I can do to speed things up? Doing such plotting using an old school Excel on an old computer running Windows 2000 was no problem at all.

View 7 Replies View Related

Applications :: Excel 2008 Opens Blank Sheets

Jul 10, 2008

Has anyone else experienced this problem with Excel 2008 after installing SP1? Attempting to open any existing spreadsheet fails, with Excel just opening a blank sheet instead. Microsoft were "aware of a problem" with SP1 which they claimed to have fixed with update 12.1.1, but as per usual and what we should perhaps expect with Microsoft, the "fix" makes no difference whatsoever, and I still can't open any of my existing spreadsheets! Their "workaround" also has no effect. I am running an Intel Mac with OS X 10.5.4 and Office 2008 12.1.1

View 3 Replies View Related

Copyrights 2005-15, All rights reserved