Share Your Excel Tips

[ashish]

[ashish koul]

1)  Press "CTRL+ 9" to hide a selected row

On Wed, Oct 2, 2013 at 10:39 PM, ashish <koul....@gmail.com> wrote:

--
----------------------------------------------------------------------------------------------------------------------
You received this message because you are subscribed to the Google
Groups "Excel VBA Codes & Macros" group.
 
To post to this group, send email to
excelvb...@googlegroups.com
 
To unsubscribe from this group, send email to
excelvbamacro...@googlegroups.com
 
For more options, visit this group at
http://groups.google.com/group/excelvbamacros
---
You received this message because you are subscribed to the Google Groups "Excel VBA Macros" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excelvbamacro...@googlegroups.com.
To post to this group, send an email to excelvb...@googlegroups.com.
Visit this group at http://groups.google.com/group/excelvbamacros.
For more options, visit https://groups.google.com/groups/opt_out.

--

Regards

 

Ashish Koul

Visit

My Excel Blog

Like Us on Facebook

Join Us on Facebook

P Before printing, think about the environment.

 

[Chandra Shekar]

Hello,

 

Short cut key for applying filter is Ctrl+Shift+L

 

 

Regards,

 

Chandra.

[rajan verma]

ctrl tilde to show formula press again to hide formula

[Michael Pablo]

alt+c+v+v to paste just values.

[Kuldeep Singh]

Press Ctrl+~

Show formula & hide...

Regards,

Kuldeep Singh

Assistant Manager Quality

Game Zone India Limited

Phone.: +91-8586978644
|| naukri...@gmail.com ||
Please Consider the environment. Please don't print this e-mail unless you really need to.

[ashish koul]

Use ActiveChart.SeriesCollection(1).Border.Color = RGB(198, 128, 18)  to add border to chart series using vba

Regards

Ashish

[Chandra Shekar]

Hello,

 

Press CTRL+SHIFT+7 for getting borders.

 

Regards,

 

Chandra

[Kuldeep Singh]

Press  Alt+H+O+R   for Rename Sheet.

Regards,

Kuldeep Singh

Assistant Manager Quality

Game Zone India Limited

Phone.: +91-8586978644
|| naukri...@gmail.com ||
Please Consider the environment. Please don't print this e-mail unless you really need to.

[Basole]

Press  Alt+H+O+R   for Rename Sheet.

my 2010 does not work

Em quarta-feira, 2 de outubro de 2013 14h09min25s UTC-3, ashish escreveu:

[Kuldeep Singh]

Hi Mr. Basole,

Alt+H+O+R is working fine...Please Recheck...thanks...

Regards,

Kuldeep Singh

Assistant Manager Quality

Game Zone India Limited

Phone.: +91-8586978644
|| naukri...@gmail.com ||
Please Consider the environment. Please don't print this e-mail unless you really need to.

[Basole]

Paste special values ​​with AppKey:

                                                                                                   AppKey + S + V :

Appkey

[Kuldeep Singh]

Hi,

Press Shortcut : - Alt +N+V+T & Alt+D+P for open Pivot Table.

Regards,

Kuldeep Singh

Assistant Manager Quality

Game Zone India Limited

Phone.: +91-8586978644
|| naukri...@gmail.com ||
Please Consider the environment. Please don't print this e-mail unless you really need to.

[ashish koul]

Use ActiveChart.SeriesCollection(1).Border.LineStyle = xlDot to change line style of series border of active chart

On Fri, Oct 4, 2013 at 7:47 PM, Basole <ricar...@gmail.com> wrote:

--
----------------------------------------------------------------------------------------------------------------------
You received this message because you are subscribed to the Google
Groups "Excel VBA Codes & Macros" group.
 
To post to this group, send email to
excelvb...@googlegroups.com
 
To unsubscribe from this group, send email to
excelvbamacro...@googlegroups.com
 
For more options, visit this group at
http://groups.google.com/group/excelvbamacros
---
You received this message because you are subscribed to the Google Groups "Excel VBA Macros" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excelvbamacro...@googlegroups.com.
To post to this group, send an email to excelvb...@googlegroups.com.
Visit this group at http://groups.google.com/group/excelvbamacros.
For more options, visit https://groups.google.com/groups/opt_out.

[Basole]

VBA:

Alt + F11 - Toggle between Excel and the VBE window.

Ctrl + R - Displays the Project Explorer window.

F4 - Display Properties window.

Ctrl + Tab - Switch between forms and modules.

Ctrl + Y - Deletes the entire line.

Select multiple rows + Tab: Increases indendação of selected lines

[ashish]

• Use ActiveChart.SeriesCollection(1).Border.Color = RGB(198, 128, 18) to add border to chart series using vba
  

• Use ActiveChart.SeriesCollection(1).Border.LineStyle = xlDot to change line style of series border of active chart
  

• Use ActiveChart.SeriesCollection(1).Border.Weight = 4 to change the size of series border of active chart
  
• Use ActiveChart.HasLegend = True to hide/unhide legend from active chart using vba
  
• Use ActiveChart.HasTitle = True/ False to hide/unhide chart title from active chart using vba
  
• Use ActiveChart.ChartTitle.Font.Size = 9 to change font size of chart title vba
  
• Use ActiveChart.ChartTitle.Font.Color = RGB(255, 10, 35) to change font color of chart title using vba
  
• Use ActiveChart.ChartTitle.Font.Name = "Comic sans" to change font name of chart title using vba
  
• Use ActiveChart.PlotArea.Border.LineStyle = xlNone to remove plot area border of active chart using vba
  
• Use ActiveChart.ChartArea.Border.LineStyle = xlNone to remove chart border using vba
  
• Use ActiveChart.ChartArea.Fill.Visible = False to remove chart area fill color using vba
  
• Use ActiveChart.PlotArea.Fill.Visible = False to remove plot area fill color using vba
  
• Use ActiveChart.ChartArea.Interior.Color = RGB(205, 104, 137) to add fill color to chart area using vba
  
• Use ActiveChart.PlotArea.Interior.Color = RGB(205, 193, 197) to add fill color to plot area using vba
  
• Use ActiveChart.ChartArea.Border.LineStyle = xlContinuous to add border to chart using vba
  
• Use ActiveChart.ChartArea.Border.Color = RGB(10, 255, 186) to change chart border color using vba
  
• Use ActiveChart.ChartArea.Border.Weight = 3 to change the size of chart border using vba
  
• Use ActiveChart.PlotArea.Border.LineStyle = xlContinuous to plot area border using VBA
  
• Use ActiveChart.PlotArea.Border.Color = RGB(10, 255, 186) to change color of plot area border using vba
  
• Use ActiveChart.PlotArea.Border.Weight = 1 to increase border of plot area using vba
  

On Wednesday, 2 October 2013 22:39:25 UTC+5:30, ashish wrote:

[Basole]

Learn the name of the Windows users:

Sub UserWindows()

       'User Windows

[A1].Value = Environ("USERNAME")

      'User Excel (version 2010) defined in (File / Options / General / User Name)

[A2].Value = Application.UserName

End Sub

'Basole

[Kuldeep Singh]

Ctrl + K  go to the Hyperlink...

Sent from Samsung Mobile

[Basole]

 How drag the sequence of letters?

Ex.: =CHAR(64+ROW(B1))

Regards

Basole

Em quarta-feira, 2 de outubro de 2013 14h09min25s UTC-3, ashish escreveu: