Skip to main content

KNOWUREXCEL

Find Latest Excel formulas and Excel tricks and Excel VBA Codes to simply your work.

Search This Blog

Home
Macros
Excel Formulas
Conditional Formatting
Excel Tricks

Showing posts from July, 2018

Posts

Sum Values in Excel Sheet | Sum Formula in Excel

on July 10, 2018

+

Get link
Facebook
X
Pinterest
Email
Other Apps

How to sum values in Excel Sheet | Sum values in Excel Sheet

on July 10, 2018

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Archive

July 20182
January 20185
December 20179

Labels

Conditional Formatting
Excel Formulas
Excel Tricks
Excel VBA

Popular Posts

formula to sum numbers in a column in excel | how to sum total of numbers in a column | Excel Formulas

formula to sum numbers in a column in excel | how to sum total of numbers in a column | Excel Formulas To find sum of total numbers in a column : Example : If in an excel sheet numbers starts from Column A and Row 1 (i.e. A1) and numbers ends in Column and Row6 (i.e. A6) which is shown in below Picture: formula to sum numbers in a column in excel | how to sum total of numbers in a column | Excel Formulas The Insert the formula =sum(A1:A6) in cell A7 which is shown empty in the picture and then press enter. You will get the result in cell A7. The other method to sum is, drag the cells from A1 to A7 and press Alt + = and you will get the result in A7 cell.

How to Create Shortcut Key to Paste Special in Excel | VBA Code to Create Shortcut Key to Paste Special in Excel

How to Create Shortcut Key to Paste Special in Excel | VBA Code to Create Shortcut Key to Paste Special in Excel VBA Code to Create Shortcut Key to Paste Special in Excel: Sub PasteVal() Selection.PasteSpecial Paste:=xlValues End Sub Open Excel Sheet Press Alt + F11 Key Go to the Insert Menu and Click on new Module in New Module copy and paste the above VBA code and save. Now Press Alt + F8 and new windows will open which is shown in below figure, in that windows you will ask to enter a key to create shortcut for Paste Special Enter a letter in the box. How to Create Shortcut Key to Paste Special in Excel | VBA Code to Create Shortcut Key to Paste Special in Excel How to Create Shortcut Key to Paste Special in Excel | VBA Code to Create Shortcut Key to Paste Special in Excel

How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel Step1: Select the range of cells in excel sheet and click on conditional formatting in excel and select new rule which is shown in figure. How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel Step 2: A window will open when u click on new rule, in that new rule windows select "format only cells that contain". In below edit rule description, select " Blanks" How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel Then click on format and a new windows will open Step 3: Go to fill in format window ...

VBA Code to display Message when click on button

VBA Code to display Message when click on button Step 1: Open Excel Sheet and go to the Insert tab. Step 2: Insert one of the by taking shape in Insert Shapes Box. Step 3: After inserting shape right click on the shape and go to assign macro. Step 4: New Module window openes and insert the VBA Code shown below and save.(before save you must save your sheet as Macro - Enabled sheet) Step 5: Change the code as per your requirement as shown below. Step 6: Now click on the shape and you can see message when you click. VBA Code: Sub RoundedRectangle1_Click() MsgBox "Hello I Am Rahul" End Sub Changes to be made at: MsgBox " "

VBA Code to format rows and columns in filtered excel sheet | Macro to format rows and columns in filtered excel sheet

VBA Code to format rows and columns in filtered excel sheet | Macro to format rows and columns in filtered excel sheet Steps to Execute VBA Code in Excel Sheet Step 1: Open Filtered Data Excel Sheet. Step 2: Press Alt + F11 on keyboard and you can see Microsoft Visual basic for applications window. Step 3: Go to Insert Menu and select Module. Step 4: In empty module, copy and paste below VBA code and save. (before save you must save your sheet as Macro - Enabled sheet) Step 5: Go to the Filtered Data sheet, select rows and columns where you want to format cells and go to Developer Menu and click on macro. You ill see Find Value Macro Macro, click and run the macro. VBA Code | Macro Sub Unhide() Dim Col As Range For Each Col In Selection.EntireColumn If Col.Hidden = False Then Col.EntireColumn.AutoFit End If Next Col End Sub VBA Code to assign seq...

How to Limit Length of the Text in Excel Cell | Limit Length of the Text in Excel Cell

How to Limit Length of the Text in Excel Cell | Limit Length of the Text in Excel Cell To Limit Text Length in the Excel, we should use data validation. Step 1: Select the range of the cells where you want to limit the Text length. Step 2: Now Go to the Data Tab and then click on Data Validation Tab which is shown in below picture. How to Limit Length of the Text in Excel Cell | Limit Length of the Text in Excel Cell Step 3: In Validation Tab, set the Validation Criteria as Text length and Set data and Length of Characters which is shown in below Picture. How to Limit Length of the Text in Excel Cell | Limit Length of the Text in Excel Cell Now Type the Text in selected range of cells. How to fill black cells with color using conditional formatting in excel | Conditional Formatting in Excel

Excel VBA Macros: VBA Code to format rows and columns in filtered excel sheet | Macro to format rows and columns in filtered excel sheet

Excel VBA Macros: VBA Code to format rows and columns in filtered excel sheet | Macro to format rows and columns in filtered excel sheet Step 1: Open Filtered Data Excel Sheet. Step 2: Press Alt + F11 on keyboard and you can see Microsoft Visual basic for applications window. Step 3: Go to Insert Menu and select Module. Step 4: In empty module, copy and paste below VBA code and save. (before save you must save your sheet as Macro - Enabled sheet) Step 5: Go to the Filtered Data sheet, select rows and columns where you want to format cells and go to Developer Menu and click on macro. You ill see Find Value Macro Macro, click and run the macro. VBA Excel Macro Sub Unhide() Dim Col As Range For Each Col In Selection.EntireColumn If Col.Hidden = False Then Col.EntireColumn.AutoFit End If Next Col End Sub VBA Code to format rows and columns in filtered excel sheet...

Sum Values in Excel Sheet | Sum Formula in Excel

https://www.youtube.com/watch?v=d0iyq-4drMU

Countif formula in excel | How countif formula works in excel | Countif function

Countif formula in excel | How Countif formula works in excel | Countif function Countif formula in excel counts the criteria in the data sheet Example: In Excel Sheet, if Column A and Column B contains repeated data, if we want to count one single name in column we use countif formula which counts only given criteria. (show in Picture) Countif formula in excel | How countif formula works in excel | Countif function Here is the formula =countif(range,criteria) here in the formula range = select from which data sheet you want to find the count of particular name. in formula criteria = name which you want to find. In the above picture range = (A:B) columns criteria = (Month or numbers in the columns) Countif formula in excel | How countif formula works in excel | Countif function in the above picture the formula is...

VBA Code to create shortcut key for Paste Special in Excel

VBA Code to create shortcut key for Paste Special in Excel Sub PasteVal() Selection.PasteSpecial Paste:=xlValues End Sub How to Create Shortcut Key to Paste Special in Excel | VBA Code to Create Shortcut Key to Paste Special in Excel

Powered by Blogger

Knowurexcel