Excel 2010 :: Inserting Column Without Formatting

Sep 30, 2011

Whenever I insert a column in Excel 2010 it takes the formatting from the Column to the left. I want to insert a Column without formatting. Just a blank column.

View 4 Replies


ADVERTISEMENT

Excel 2010 :: VBA Code For Inserting Text In All Column B-cells Of Multiple Selected Rows

Jul 11, 2012

Software: Excel 2010, Windows 7

What is the VBA code for inserting text in all column B-cells of multiple selected rows?

I am creating a worksheet with a table containing various data related to orders of various materials (this is more or less data gathering from an older, paper-based 'system'). This table spans, columnwise, from A to D and expands downwards as more orders are added. The information in each column is: A=order number, B=type of material and C=material specs. and D=additional comments.

I've set it up so that the only thing I really have to do is to insert the type of material in the cells of column B, and the rest will sort itself out. Instead of having to insert a new row for each new entry and manually typing in the name of the material (these entries are often done in the midst of already existing data), I created several similar, macroed buttons for the different types of materials we use. These macros work by selecting the row of the currently active cell, inserting a new row and then add the name of the material in the column B-cell of this new row. What I am having trouble doing though, is to get the text-entry to work for a selection of multiple cells.

As an example, lets say that I would like to add 5 orders of "Grade A Steel" in the middle of the table - in the row above row 8. With the macro I currently have I can select cell B5, click the macro, and a new row will be inserted with "Grade A Steel" in column B of this new row. This action could be performed 5 times over, but would be easier if I could just mark a range of 5 cells, say B8:B12, click the macro and get the text/data inserted the column B-cells of all 5 of the new rows. So far I've been able to create a macro that inserts multiple new rows, but I've only been successful in filling the column B-cell in the first row leaving the 4 below empty.

View 8 Replies View Related

Excel 2010 :: Condition Formatting On Column Of Text?

Jul 22, 2014

I have a column of numbers that are already formatted as text. Some of the data is duplicate which is fine. It's like a list of 6000 numbers. I want to conditionally format the column so that I can fill the cell with a color as long as it stays the same number, but if it changes to a new number make it a different color. I don't need a lot of colors. Two is fine. TI have Excel 2010.

View 4 Replies View Related

Excel 2010 :: Conditional Formatting Of Table Rows Based On Value In Column?

Jan 2, 2014

I'm working in Excel 2010.

I setup a table with a column titled "Type". Each value under column "Type" defines the type of row it is: "Section", "SubSection", "SubSubSection"

I wish to create a set of conditional formatting rules that apply to data rows in this table, each rule controlling how cells within a whole row should be formatted, according to the value found in "Type", for that row.

Example:

Rule1: [@Type]="Section" -> fat red line on top of cell.
Rule2: [@Type]="SubSection" -> thin black line on top of cell.
Rule3: [@Type]="SubSubSection" -> dashed black line on top of cell.

I can't seem to make this work.

How can I leverage the nice column names, and the "@"-this row designator, within a table to create conditional formatting rules that apply to all the cells within a row, in the same way one can refer to in table formulas?

View 2 Replies View Related

Excel 2010 :: Inserting Dropdown Calendar

Jul 6, 2012

Using excel 2010, how do you insert a drop down calendar? Will this be able to display the date and then can I add a nuber to it and the result be a date

View 1 Replies View Related

Excel 2010 :: Inserting Pictures As Formula?

Jan 2, 2013

What will show in column B will change each day as a I am creating a ordering picking list and want to show a pic in column A of the item to pick the item. Is there an easy way of doing this.

I have been messing around with the following

=showpic("C:DesktopItems46004978Thumb.jpg")

And thought I may be able to show this as by doing the following in the desired cells

=IF(ISBLANK(B1),"",INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B,0)))

On sheet1 I have all the model numbers next to

=showpic("C:DesktopItems46004978Thumb.jpg")

And the index formula will grab the correct showpic string depending on stock code that is showing in various column B cells but this isn't working.....

View 9 Replies View Related

Excel 2010 :: Inserting New Rows In Selected Files?

Mar 3, 2010

I have problems inserting new rows in selected files. The files with the problems have a macro. I don't know if the problem can lie within the macro. There is no error message, it just won't insert the new row(s).

View 4 Replies View Related

Excel 2010 :: Inserting Columns / Rows And Cells

Nov 20, 2013

For some reason I don't seem to be able to insert any columns/rows/cells in to my excel spreadsheet. This is a problem in both basis sheets and more advanced ones.

View 1 Replies View Related

Excel 2010 :: Code For Inserting And Removing Dates

Dec 14, 2012

I need a code that when i place a date in a cell D10 (Example:25-January-2013) it will then add 40 days of dates daily to AP10.In D9 can it also add the weeknumber (every 7 days the weeknumber increases by 1) corresponding to the day date in D10 (iso).Can this be attached to a button.Enter the date in D10 then press the button and the dates auto insert across the sheet daily to AP10.

Can the button say ADD DATE or REMOVE DATES.First date in D10.When the button says REMOVE dates all dates deleted when button pressed and cell D10 then says "add date here".If no date is placed in D10 and ADD DATE button is pressed a warning messagebox appears and says NEED TO ADD DATE .Will not work until date entered.When date entered in D10 "Add Date Here" disappears until REMOVE Date button is selected and again "Add Date Here" is displayed....not sure if this is possible but would be good if achieved. Excel 2010

View 3 Replies View Related

Excel 2010 :: Inserting Blank Row In Table Without Copying Formula

Mar 15, 2013

I am trying to insert a blank row into a table (created using the table function in Excel 2010) without the copying the formulas. Every time I insert a row the the formula is copied.

View 3 Replies View Related

Excel 2010 :: Inserting Sheet Name Into Footer Of Every Worksheet In Workbook

Mar 26, 2013

I am trying to add the sheet name to the center footer for each worksheet in a workbook. The workbook has about 80 sheets and it is cumbersome to do this manually. I am using Excel 2010.

I have tried to record a macro capturing what I do manually, but when I run the macro on another sheet, it does not add the sheet name to the center footer.

I have tried searching for a macro online and the ones I have found just crash excel.

I know I am probably missing something obvious in my macro code.

View 4 Replies View Related

Inserting Rows Or Column In Excel?

May 2, 2014

macro for inserting rows and column in Excel.

View 1 Replies View Related

Excel 2010 :: Inserting Image To Cell / Merged Cells As Background Fixed To Cell Size?

Jan 18, 2014

Excel 2010. I need to place picture into one cell or one big merged cell, as a background fill. picture must resize to size of cell. must be fixed in, not in front. i still need write into that cell, so it needs to be really background.

View 2 Replies View Related

Excel 2010 :: Conditional Formatting Whole Row?

Sep 24, 2013

Using Excel 2010

I need to "Fill" cells A1 to A10 with a fill colour if cell A1 contains anything (Value or characters)

Is it even possible using Conditional Formatting rather than VBA?

View 3 Replies View Related

Excel 2010 :: Conditional Formatting And Dropdown Box?

Jan 5, 2013

I'm running Windows XP with Excel 2010. I would like to be able to have a group of 19 boxes of which each box has a unique entry, ie 1, 3B, 5C etc. Each box I'd like to have a way in which when selected only the single or dual unique characters show as a color. See attached spreadsheet with sample. When a cell with lets say 1 is selected, a drop box appears and the color and description are shown. Select a color but only show the 1 and the color selected, leaving behind the description. How can I do this for all 19 boxes. This seems like its a classic conditional format. Unfortunately it appears to be several orders of difficulty than a normal conditional format.

View 2 Replies View Related

Excel 2010 :: Generate Conditional Formatting

Feb 19, 2013

I need to generate conditional formatting in Excel 2010.

For the planned date of material submittable should turn yellow before 10 days ago & planned date of material submittable should turn Red when overdue.

View 1 Replies View Related

Excel 2010 :: Formatting Minutes And Seconds?

Apr 17, 2013

I have a sheet where staff enter the time it takes to do a task. I'm using a custom format of [mm]:ss. However, I enter (for instance) 5 into the cell, the value becomes 7200:00. I finally figured out that this is because that is the number of minutes in 5 days. However, I don't want staff to have to enter 00:05:00 to indicate they worked for 5 minutes. I would rather them be able to enter something like 5:30 (or something along those lines) to indicate this took 5 minutes and 30 seconds.

View 1 Replies View Related

Excel 2010 :: Conditional Formatting Using AND And INDIRECT

Jan 10, 2012

I'm trying to do conditional formatting that applies to an entire column (that way there are fewer conditional rules), but it only applies to a certain range of cells within that column. So what I did was setup the rule such as:

Applies To:

=$B:$Z

Formula I want to use:

=AND(MOD(ROW()-3,49)=38,INDIRECT("B"&ROW()-4)>=0)

If I copy the entire formula into a cell on the spreadsheet itself, it works just fine returning TRUE and FALSE depending on what row I'm on.

However, the above formatting rule does NOT format ANY row. But if I remove the AND function and the first condition (the one that limits which rows it's actually going to apply to) then it will work...OR if I do NOT use the INDIRECT function then it seems to work, it's some weird combonation of using the two together that is causing it to not evaluate to true.

Oh, and I thought of trying to get the formatting to work with the INDIRECT...then I put in the AND function but the only parameter was the original INDIRECT function (see below)...it stops formatting!

=AND(INDIRECT("B"&ROW()-4)>=0)

Office 2010 on Windows 7 64bit

View 5 Replies View Related

Excel 2010 :: Right Click Formatting Context Menu?

Jun 26, 2014

In Excel 2010 onwards (probably 2007 as well) there are two right click context menus that pop up on a cells.

The "Cell" command bar and also a smaller formatting bar.

What is this bar called and if you remove it how do you get it back when you have removed all the standard bars.

VB:
Application.Commandbars("Cell").Reset

The above doesn't seem to get back the formatting bar. I did managed to get it back but through luck rather than judgement. Just through looping through every commadbar and printing it to the immediate window.

I've added the name of the context menu to each commadbar but the formatting one does not get a name put at the bottom of it. I've looked on this site and it doesn't seem to say anything about this new menu.

View 1 Replies View Related

Excel 2010 :: Conditional Formatting On Expiration Dates?

Jun 21, 2011

I have a spreadsheet where we track our contractor's Worker's Comp and General Liability insurance certificate expiration dates. I want the expiration date to highlight in red if it is expired and to highlight in orange if it will expire within 30 days or less.

I have attached a testing sheet similar to what I'm working on. The F column has the dates that need to highlight. I have MS Excel 2010.

View 6 Replies View Related

Excel 2010 :: Conditional Formatting With Multiple Criteria?

May 16, 2013

I am trying to do a conditional formatting based on the result in one cell but it needs to add up multiple cells first to determine which conditional format it needs to use. I am not sure whether I need to do a formula conditional format or whether to use cell is greater than with =sum() in it. I have tried both but neither seem to be working correctly. I have attached an example of the spreadsheet and the conditions I am trying. I am using 2010 version.

Basically, the closing amount for Monday in prod 1 (cell c4), needs to display in red if sum of the cumm value for Tuesday (L4), Wed (N4), Thur (P4) & Fri (R4) is greater than that value or display in amber if the sum of the cumm value for Tuesday (L4), Wed (N4), Thur (P4).

I need to complete the same for the whole column for Monday (col C) for each appropriate product. Then the same for column B but this will sum different cells but the principal will be the same.

View 3 Replies View Related

Excel 2010 :: Highlight Duplicate Value Using Conditional Formatting

Nov 26, 2013

As per my attached file : duplicate value.xlsx

How to highlight duplicate value by using Conditional Formatting in office 2010.

Actually i Know how to use this feature in sheet "example" of my attachment.

But i want to highlight inv# 457878268 in cell E9 of sheet "My requirement" if it is exist above in cell E2 to E6.

View 3 Replies View Related

Excel 2010 :: Formatting As Phone Number From Text?

Jan 13, 2014

I am trying to format a cell (in Excel 2010) as a phone number. The problemis that the data comes over from our download as text. Is there an easier way then using the 'SUBSTITUTE' function to change format to a true phone number (so that we can mail merge into WORD)? Since it is extracted out as a text, using the 'phone number' format (under special) will not work. Using the 'SUBSTITUTE' formula to remove the parenthesis', the dash and the space work but is cumbersome.

Below is an example of the text format that is being extracted: (706) 378-7585

View 1 Replies View Related

Excel 2010 :: Formatting Chart Axis Values?

Oct 8, 2011

Why the recorded code doesn't work? I recorded the code below to format the Y-axis values of a chart with the recorder.

Code:
ActiveChart.Axes(xlValue).Select
With Selection.Format.TextFrame2.TextRange.Font
.NameComplexScript = "Arial"

[Code].....

View 6 Replies View Related

Excel 2010 :: Conditional Formatting Based On Two Conditions

Mar 29, 2012

I have a date in column A. I want to format to YELLOW column F based on whether column F is blank and 20 days past column A. I also want the formatting to change colors to RED if it remains blank past 30 days. Then, when column F is filled in I want the formatting to be removed.

I am working in Excel 2010

View 1 Replies View Related

Excel 2010 :: Conditional Formatting Inconsistencies - Seems Beyond Logic

May 30, 2012

I've run into an issue where conditional formatting is working correctly 98% of the time, but 2% seems beyond logic. Basically if I have more than 120% of Stock Limit on hand I want the cells to turn green. To do this I entered the following Conditional Formatting formula in cell D4:

HTML Code:
=((D4-$C4)/$C4)>=$E$1

I copied the formatting to all the other cells in the range, and most are colored correctly. This is what I get:

Sheet1

ABCDEFGHIJ1

Overstock Threshold: 120%

2Location:ABC

3ItemNameMin Limit5/1/20126/1/20127/1/20128/1/20129/1/201210/1/201211/1/20124123Part A2-328765435234Part B35-2-21212489898

As you can see, it works correctly for the most part, however some cells, such as cell H5 in the example, that should be colored by they aren't.

My first thought was that this is an issue with the reference, because as I examine other cells it doesn't look like conditional formatting formulas are updated relative to that particular line, however that is the same case for my red formats and those are correct. I have over 50,000 rows so creating a new formula for each row certainly isn't the preferred option, neither is writing a macro to manually color them because of the processing time. I'm using Excel 2010.

View 2 Replies View Related

Excel 2010 :: How To Force / Refresh Conditional Formatting

Jun 18, 2012

Excel 2010. I have a field that is color formatted based on the value of another field, which is calculated.

The conditional formatting does not refresh when the value is recalculated, but when I go away from the tab and come back, it works fine.

Any simple VB code to refresh the conditional formatting upon a workbook change?

View 1 Replies View Related

EXCEL 2010 :: Conditional Formatting With Date Formula?

Oct 11, 2012

USING EXCEL 2010

I'm looking to create a conditional format which highlights a date RED if it is within 90 days of today's date (the date the file is opened). What would the formula for that look like?

View 2 Replies View Related

Excel 2010 :: Conditional Formatting Highlight If Not On Another Sheet

Apr 24, 2013

I am trying to use condtional formatting to highlight a row in a table if the order number is NOT on another table, on a different sheet. Example: Order Number 1001 is in my table on Sheet4, Once the order has been filled is comes off my "Pending Orders" table on Sheet1, which is based on a data connection, so it updates once the connection is refreshed. I would like the row with order number 1001 in my table on Sheet4 to be highlighted letting me know it can now be removed, since I have to manually manage this table. I am using Excel 2010.

View 3 Replies View Related

Excel 2010 :: Conditional Formatting With Two Conditions In Different Cells?

May 28, 2013

I have two conditions for a cell. One is that it counts the time elapsed in cell M4, (=now()-J4). The other is whether or not we are still waiting for a response (in cell L4, Y or N). What I would like to do is make it so that when we are still waiting for a response the M4 cell is highlighted yellow if more than 3 days and red if more than 6 days, but if cell L4 is changed to "N", then the formatting goes away. II use Excel 2010.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved