code VBA to move data from the cell to the left (step to the right)

Office

Question:I have vba code provided for me several months ago by a member of the Star community on this forum. I now need to adjust the code slightly, and I do not know how to edit properly. I am not quite familiar with macros. Previous code has moved to the right data. I need now for new data to be moved to the left. The vba code I have is:Option explicitSub ShiftFilteredRows()Dim rg As Range, rw As...Read More

Posted: 12 May 2012

Tags: code VBA to move data from the cell to the left step to the right code VBA move data from the cell left step right

How do you make the two rows of words in a cell - one on top and one below?

Mac

Question:In a cell, I want to have the words of the other like thisAnswer:To force a line break use command + Option + return orControl + Option + return.You can also form the cell to wrap the content of text based on the width of column using Format > check cell - alignment, Wrap Text.Regards,.Bob J.Read More

Posted: 09 May 2012

Tags: How do you make the two rows of words in a cell one on top and one below How you make the two rows words cell one top and below

Protection of all but a few cells on a sheet

Mac

Question:I cannot operate. When I try to lock a single cell via the format cells - > protection, I am informed that a lock on a cell has no effect unless the worksheet is not protected. When protect the entire sheet, I no longer have the possibility of changing the status of protection of a cell. What I am missing? I have, in passing, has studied and followed the entry "Protect sheet" help, without...Read More

Posted: 21 Apr 2012

Tags: Protection of all but a few cells on a sheet Protection all but few cells sheet

Distribution of the text in the cell on several lines

Mac

Question:On my PC, I could force breaks in the text in a cell so that they appear on different lines. I think I used Alt + Enter or if, to this end.Now that I have turned to Mac and use Office Mac 2011, I can't understand how to do this more. Help?Answer:If you were to look at the "Excel keyboard shortcuts" topic in Microsoft Excel Help, you would find that the keyboard shortcut is Ctrl-Opt-return...Read More

Posted: 17 Apr 2012

Tags: Distribution of the text in the cell on several lines Distribution the text cell several lines

disable the calculations of formulas in cells

Mac

Question:Is there a way to disable these calculations to cell in cells?For example: I would like to just have the text in a cell: = priorityIt provides a replacement with a sort of code, it thinks I want.Help!Answer:Yes. Type a single quote as the first character to indicate to Excel to process the input as text instead of a formula' = priorityRead More

Posted: 17 Apr 2012

Tags: disable the calculations of formulas in cells disable the calculations formulas cells