General

Removing Cell Borders
Is it possible in Excel 2007 to remove just a portion of a cell border (i.e. remove bottom border and leave top and sides)? This was accomplished in Excel 2003 by clicking on the Bottom Border icon and it would either add or remove for that cell. In 2007, this functionality aoppears to be gone. It looks like... 19 Jan 2010 10:10

Automatic Reminder
Is is possible to set up so that a reminder 'flags up' when stock level reaches a certain level please? ... 19 Jan 2010 10:10

Column heading is numeric. How to change to Alphabet?
... 19 Jan 2010 00:21

Excel 2007 highlights multiple cells when trying to select one
I have also come across this problem (my keyboard is almost brand new, when I click on a cell it is selecting that cell plus a couple above and a couple below so 5 cells altogether. Did a google search on it and the only tip I found that sometimes solves it is to click in the cell very quickly. Once I've done ... 10 Feb 2010 20:15

Click 1 Excel square, computer highlights 3 vertical squares, why
Using Windows 7, I haven't had any problems until now. When I click on 1 square, the computer highlights 3 verical squares. Did I turn something "on" and not know it? And how do I get it to highlight only the square that I click on? ... 18 Jan 2010 18:49

max date
I have a list of log enteries for different engines: C D F Date Serial Time 12/31/2009 PCE-BJ0340 108019 12/31/2009 PCE-BJ0450 63107 12/30/2009 PCE-BJ0340 201324 12/31/2009 PCE-BJ0486 45209 12/30/2009 PCE-BJ0450 9... 18 Jan 2010 15:26

resize my worksheet-there is no maximize button showing
I, too, am having this problem on my newly converted Excel 2007 worksheets. Does anyone know how to resolve this, or what causes it to happen? "dj95" wrote: how do i resize a worksheet to fit the window. for some reason there are no minimize/maximize buttons showing on it and also you can't click and dra... 18 Jan 2010 15:25

Excel 2007
Have Windows 7 and Office 2007 Pro Plus. On certain files whether locally or on the network I try to open a spreasheet and the excel page goes white. Error"Microsoft Excel has stopped working" File will nopt open. have done diagnostics, repair install and a complete removal and reinstall of Office. Business con... 18 Jan 2010 14:18

Dynamic Charts - working across multiple Worksheets
I have a workbook containing embedded charts that show the performance of investment funds (rows as 'series') on a date basis (columns 'category') which for each worksheet updates the chart(s) dynamically as new data are added at each new time point. So far so good! However, I have a number of different works... 18 Jan 2010 14:18

ranking numbers in a column
I have 100 (100 rows) with different numbers all in one column. I have ranked them in another column by largest to smallest in the past. The 100 numbers change from time to time. I would like the rankings to automatically update. I wish not to sort. Is there a formula? Thanks, Darryl ... 18 Jan 2010 15:25