|
|
forget excel password by
Grey
I have set a file password on the excel file. Unfortunately, I have forgotten it. Is there any way to know the password or disable this function
Million Thanks
|
August 26th, 2021 12:25 PM
by psscvr
|
5 |
27,277 |
|
|
Combining different worksheets using VBA by
jimmy2016
Combining different worksheets into a single worksheet.
Dear helpers,
I am new to VBA and have the problem:
To combine worksheets into a single worksheet we...
|
|
0 |
16,482 |
|
|
Array formula in merged cells by
vtisix
I have a simple array formula that sums 3 criterias. After I've entered
the formula and do Ctrl+Shift+Enter, an error pops up stating that
"Array Formulas are...
|
|
8 |
14,000 |
|
|
Convert a Cell Reference to Text by
Chuck Buker
Cell A2 contains the text "a100". Cells A5
through F15 contain indirect and offset functions that use
the text in A2 to cause cells A5 through F15 to refer...
|
|
6 |
11,626 |
|
|
Movie Times Calculation? by
CAMooV
I work for a major theatre chain an no one (inclduing the help desk) can figure
out how to make a show start/end time schedule calculate the ending time. ...
|
September 18th, 2003 05:08 PM
by Charlie
|
3 |
8,772 |
|
|
Radio Buttons on Worksheet by
Jeff Monroe
I am just trying to add simple groups of radio buttons to a worksheet for yes-or-no questions to be filled out by the user. No funtions, no data being entered....
|
|
0 |
8,474 |
|
|
Sort & Filter grayed out by
ljCharlie
I have a table with A-G columns and 20 rows. If I do not select column A then the "Sort & Filter" is enable. The "Format as Table" also works. As soon as I...
|
|
0 |
7,916 |
|
|
Select a worksheet by
Phil
I'm using the below formula to determine the specific type of equipment from
a list named:...
|
|
4 |
7,690 |
|
|
Signature question by
ElaineT1
I am trying to set up a workbook in Excel 2007 with multiple tabs and two signature lines at the bottom of each sheet. The idea is that my boss can read, sign...
|
|
1 |
7,554 |
|
|
Conditional Drop Down by
sunil.kini
In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs....
|
|
2 |
7,491 |
|
|
|
|
2 |
7,376 |
|
|
copy paste via macro by
Azrael
I need to copy certain data from a page and move it to another form, in the same book. The basics is that data will be entered each day then the user will hit...
|
|
1 |
7,252 |
|
|
maintaining constant percentage by
SF123
Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of...
|
February 4th, 2011 11:01 PM
by Azrael
|
2 |
7,180 |
|
|
Selecting a Particular sheet by
shajizz
I'm using Excel 2007, workbook there is several sheets, I want to select the particular sheet from the first sheet, any tips please...
Expl:- I'm making...
|
|
3 |
6,971 |
|
|
Scoring or Rating by
JamesZ
From a previous post. Thought this example might be easier to understand.
I have an Evaluation Sheet that has four cells of different ratings each...
|
|
1 |
6,897 |
|
|
Conditional Delete Statement by
chrisjack001
I want to create a code that can run through the entire spreadsheet and delete the rows of all accounts that have $0 or less Outstanding balance. Example in...
|
|
1 |
6,614 |
|
|
convert angle to vector by
dslocum
I have Excel 2010, can anyone help me come up with a formula to create a chart that converts angles to vectors? I would like to show that Zero degrees has a...
|
February 21st, 2012 04:43 PM
by dslocum
|
0 |
6,472 |
|
|
Multiple Cascading Dropdowns by
Emmaly
Hi All,
I have an issue with cascading dropdowns.
I have the following data. Entity = UK, GMBH, JAPAN, SING
I have then got lists of products, suppliers and...
|
November 2nd, 2011 10:34 AM
by Emmaly
|
0 |
6,469 |
|
|
Moving comments in Excel by
sollc
I have moved a comment by dragging and dropping it. However, when I 'hover over' the cell with the comment, the comment box goes back to its original position....
|
April 13th, 2011 01:18 PM
by sollc
|
0 |
6,453 |
|
|
|
|
0 |
6,019 |