Over 1 million tech questions and answers.

Legion Y730 15 4-cell compatibility

Q: Legion Y730 15 4-cell compatibility

Hello, Lenovo, I really like my laptop, but the battery capacity is not enough. I assume that the 15 inch and 17 inch versions have the same motherboards.Is it possible to install a 4 cell battery in a 15 inch laptop, and will it require any modifications?I can only leave ssd.Thanks.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Legion Y730 15 4-cell compatibility

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 79.6

hey everyone,well. i will lay off ALL the previous problems that the laptop came with (such as an unplugged touchpad, a broken charger and an absolutely horrific repairs i got).my cpu seems to work at only 0.79 ghz and doesnt go up.  rarely it goes to 1.6 ghz. when unplugged.when i plug it in it seems to work around 2.2 which seems normal but as soon as i start putting some load it just drops down. only thing which solves it for a cuple of minutes is if i go unto bios and load default settings then boot into windows, only then i get the boost speed of 4 ghz. temps are pretty normal (laptop is repasted witharctic mx4).alldrivers installed windows 10.what can i do guys really dont know.....

Read other answers
RELEVANCY SCORE 78

I bought a new lenovo legion y730, when i installed the new wifi driver, it has frequent sudden disconnections. When i installed the previous driver, it helped a little but still there are sudden drops and disconnection of the wifi. Can anyone one help?

Read other answers
RELEVANCY SCORE 75.2

So. After I wake up the laptop performance in games is so poor. I suppose the laptop starts to use Intel integrated graphics card instead of nVidia's one. But i'm not sure.Performance drop for example on Apex legends from 100 FPS to 20 FPS in the main menu.I use 430.39 driver from official nVidia site.

Read other answers
RELEVANCY SCORE 59.6

Heeeey everyone, sorry to bother, can anyone help me and let me know if this 8GB RAM memory is compatible with the Legion Y530. My memory is almost the same, but this one on amazon is AC and mine is AD. Thanks  https://www.amazon.com/Hynix-PC4-21300-DDR4-2666MHz-260-Pin-HMA81GS6CJR8N-VK/dp/B07JP4C1PD/ref=sr_1_...

Read other answers
RELEVANCY SCORE 56

Dear all, I have this gaming laptop some time ago and now would like to change the 128Gb with a 500Gb or 1Tb. Which Samsung or Crucial SSD are compatible to fit in my Laptop? Regards 1 screenshot 

Read other answers
RELEVANCY SCORE 50.8

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?
 

A:Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers
RELEVANCY SCORE 49.2

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?
 

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers
RELEVANCY SCORE 49.2

I have the Legion Y520 -15kbn  Model name 80WK i7 16 gig ram and Nividia 1050ti 4gig gragjhics card. I bought to us VR headset my question is the HDMI port off the Intel grapghics or the Nividia 1050ti??? If its not off the Nividia GPU then it VR will not work. Before I am not able to return system and pull my hair out trying to get VR to work. I know its a very technical question not easy  but need an ansewer. Thank you.

Read other answers
RELEVANCY SCORE 49.2

Lenovo Legion Legion Y520  running windows 10 I am connected to a Sony TV by HDMI.  When I use the TV as the only display or as an extended display the image is downscaled to 720p.  If I clone the display from my laptop it will render full 1080p. All of the settings I can find appear to be correct.  The laptop says that it is displaying 1920x1080.  I would like to get the TV to work as primary display.  I know it is not the TV.  It can display the cloned desktop and works properly for game consoles also using HDMI.  I have tried using different HDMI ports on the TV.

Read other answers
RELEVANCY SCORE 46

I can not seem to find where I would download Windows 7 Drivers for my Y730.   When I go to Support, Download and Drivers and go through the Model selecion there are only Windows Vista Drivers.  I find this very disappointing as you are now supposively shipping these laptops with Windows 7 installed.  I would like to be able to download the new drivers as well as the support applications that have been reworked to properly function with Windows 7. Can Anyone Point me in the direction for getting what I'm looking for?  Thanks.













Solved!

Go to Solution.

A:Y730 Windows 7 64-bit Drivers

Hmm, there are some drivers for Windows 7: http://consumersupport.lenovo.com/en/DriversDownloads/drivers_list.aspx?CategoryID=18 Perhaps they have added it overnight.

Read other 4 answers
RELEVANCY SCORE 46

Hi new here. Bought a y730 a month or so back and worked great until recently. After getting all the updates, the fingerprint scanner no longer works. Seems to be a fairly common issue? I read here and tried all the fixes (tried to update the intel software and also the drivers for the reader) and still nothing. I called support and they were essentially worthless. Rolled my computer back and finally suggested I re-install windows after that did not work. It seems as if this is related to the 1803 update?  Does anyone have this working and or a procedure that works? If I install the later updates to the fingerprint driver I get error code 10 (device won't start I think?) and the intel security update that was listed refuses to install (it says both there is an older and newer version during its install).  Any advice is appreciated. 

Read other answers
RELEVANCY SCORE 45.2

It seems Lenovo doesn't even remember (or is playing revisionist history tricks) that they made the Ideapad Y730.  Looking around the support pages, NOTHING will turn up any reference to the Y730.  There are no drivers, etc to be found  on this site.  I have tried searching by the two different serial numbers taht show up in BIOS, and they can't manage to find themby those either.  And forget about their "automatic" lookup utility; it will sit there spinning for ***HOURS*** (yes, I left it to run overnight once) and can't manage to even START finding anything.  Their site is severely broken.Even trying the so-called-"support" line, the "tech" couldn't find the machine by S/N either, and kept insisting it couldn't be that number.  Well, if it's the wrong number (on the sticker *as well as* the BIOS), then it's Lenovo that got that wrong. So what's the story?  Are they trying to deny the product?  Did they fubar this one worse than usual that they have to pretend it never existed? 

Read other answers
RELEVANCY SCORE 45.2

Hello Everyone  I just need help with my Y730 15inch model wifi card. I saw someone replace that as Intel AC 9560 on their Y530. So I thought that should work on my laptop too. I replaced with 8560 once. But I could not find that card in my driver manager. I mean somehow there should be a device logo with yellow thing there, right? (I did not install the software driver at that time.) Therefore, I come to ask if anyone has an idea what should I do first? I mean, should I install the driver before I replace it physically? Or, should I replace it first, install driver and reboot? I am still not 100% sure Intel AC9560 will work on this laptop. Also, I want to ask I do not need to reinstall windows when I replace the wifi card, right?  

A:Y730-15 WiFi Card replace

Most laptops have a whitelist of cards that can be installed, so while you laptop may support the AC 9560, it would have to be a Lenovo branded one to work, which for the Y730 is FRU P/N:  01AX768 Here is one that is compatible with your system.https://www.ebay.com/itm/Intel-Dual-Band-Wireless-AC-9560NGW-bt5-0-Card-For-Lenovo-01AX768-hp-937263... Once you install the card into your system, you just need to install the driver below and it should be detected Intel WLAN Driver for Windows 10 (64-bit) - Legion Y730-15ICH, Legion Y730-17ICHhttps://download.lenovo.com/consumer/mobiles/mdlg03af08rb.exe Cheers,

Read other 1 answers
RELEVANCY SCORE 44.8

Hi Everyone, I have a Legion Y730. I spent days searching for an answer and was not able to find a solution that worked until now. It seems that this was something that many people had posted about over the years and the solution was very difficult to find if at all. I wanted to share with everyone so that they may find the answer in one place. After reformatting my drive recently and freshly installing Windows 10, my F4, F8, F10-11 secondary functions stopped working. There was no solution anywhere until I saw one post in a random forum that stated that he had Lenovo Utility disabled in his startup and needed it to be enabled for them to work... Low and behold, I found this driver: https://support.lenovo.com/ca/en/downloads/ds500481 It is not automatically installed with Lenovo Vantage, or Windows Update, or even DriverEasy (which I have the pro version). Install this, restart, and all of your function keys work once again! I hope this helps whoever is trying to search for a solution to this once and for all! 

Read other answers
RELEVANCY SCORE 44

Hi,I'm thinking of upgrading my stock SSD to https://www3.lenovo.com/gb/en/accessories-and-monitors/memory-and-storage/storage/HDD-BO-ThinkPad-M-....Will it work ? Will it be faster than the stock 256GB one ? Will it void the warranty ? 

Read other answers
RELEVANCY SCORE 44

Looking for a parts list or service manual (presuming it has part numbers) for the display/video cable/harness for an IdeaPad Y730, model 4053 (not the completely unrelated Y730 "Legion" series; why would Lenovo feel the need to re-use model numbers). The video is intermittent; on extremely rare occasions the LCD will start working, then next time it will be off again.  Video works off of the external/VGA port, and I'll notice if I connect to it remotely with TeamViewer when there's no monitor attached, device manager won't show any dsplay devices, which leads me to think it's the cable.  Definitely not an OS problem because a Linux bootable DVD will show the same symptoms.

Read other answers
RELEVANCY SCORE 43.2

I have a sheet with 2 simple columns: Date and Price. I have imported the dates (##/##/####) and the prices ($###,###) by copy/pasting from the search results given to me by a niche database program I use. When the cells paste in, they all have the format "General".

When I try to format the "date" column into dates, it _does_ change the format as far as the cell is concerned, but the content of the cell doesn't adapt to the new format. For example, I have the date as 3/05/2001 and when I change it to a date format of MMM D, YYYY the content should change to March 5, 2001 but it doesn't. It is as if all the cells are forced to stay as text regardless of what the formatting is that I'm applying.

Same problem with the price column: if I change the format to include 2 decimal points, that format does apply to the cells, but the content of each cell remains without a decimal or anything following, as if the content is just text.

I have like 1000 rows in each column, and plan to do this analysis of the database's results frequently, so I'm hoping the answer isn't just to retype the data. There's got to be a way to copy/paste or export or something. Maybe I could copy/paste into notepad first to scrub out any formatting or locking from the niche database program?
 

A:Excel 2007 Cell Values Won't Take On Characteristics of Newly Applied Cell Format

Good news: Made some progress. In thinking that maybe each value had the textual single-quote forcing it to act like text, or maybe if I find/repaced all the dollar signs and commas that had been imported, I accidentally discovered that each and every value in my imported columns has a following space!

Bad news: Seems like Excel has a bug that thinks that if I say "Find=[singleSpace]" "Replace=[null]", then I should be given an error saying "Excel cannot find any data to replace". I think I'm doing the find/replace correctly because it worked on the dollar signs and commas.

Anybody know a workaround for the bug?
 

Read other 1 answers
RELEVANCY SCORE 42.8

Hello Everyone! :-) This is my first time posting at this forum.  I have a Lenovo T520 laptop that is experiencing intermittent problem shutting down when I am trying out brand new 9-cell and 6-cell batteries that are fully charged.  Based on the seller instruction; they said to go into the bios to see if there is a battery resync option and/or charge the battery with the laptop powered off for a minimum of 10hrs before using the new battery.  I followed their instructions but the laptop continued to suddenly powered off while I am using it with a fully charged battery.   Has anyone experiences similar issues and know of any troubleshooting method or fixes?  Of course I first naturally expects the battery to be bad, but I bought 2x 9-cell batteries, the seller then send me an additional 2 x 6-cell batteries because I am having problems with the 9-cell.  The 6-cell also resulted with the same symptom so I find it hard to believe that all 4 batteries are bad.   Here is the info on the batteries I purchased:  https://www.ebay.com/itm/9Cell-Battery-for-Lenovo-ThinkPad-T410-T420-T510-T520-SL410-SL510-E420-E425... Thank you in advance for anyone that can help me to resolve this problem. Best,Vinh Le

A:New OEM 9-cell & 6-cell batteries causes laptop to suddenly shutdown with full charge

Hello and welcome,
 
I can't say with certainty what is going on - but those aren't OEM (Lenovo) batteries.  They are unbranded generics from who-knows-where.
 
I'm always suspicious of non-OEM batteries and their internal control electronics.
 
Z.

Read other 2 answers
RELEVANCY SCORE 42.8

Hi Tech teams, I went to the lenovo site to customize a T440S Thinkpad and got stuck at the REAR BATTERY selection. I have searched in google and the site and could not see the picture difference's between 6 Cell Li-Ion Cyl HC Rear (72Wh) and 6 Cell Li-ion (47Whr) Cylindrical. I know those will be large and will bulge out of the laptop. But I would like to understand in which way and want to see the pictures of the laptop fitted with these 2, so that I can proceed with my order. Will it come out like a cylindrical bulge at the back of the laptop or at the bottom it will have an extra step like thing. Why dint the lenovo put 3 different pictures showing the laptop with these batteries in the "help me decide" option while customizing the laptop. That would have been very nice to the customers. I have wasted 2 hours to compose this and search everywhere, without any resolution. I found a similar thread in some forum, asking for the pictures, and no one replied him as well. Please see the below screenshot.  ThanksManu

A:Difference between 6 Cell Li-iion Cyl HC Rear (72Wh) and 6 Cell Li-ion (47Whr) Cylindrical

Hi,
 
look at Notebookcheck review

Read other 6 answers
RELEVANCY SCORE 42.8

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

Read other 3 answers
RELEVANCY SCORE 42.8

I copied a cell from sheet 4 and pasted a link in the target cell (on sheet 1) and the number that was perfectly shown in the source cell was shown twice in the same target cell on sheet 1 of the same Excel 2016 spreadsheet. I have included a partial screen shot of sheet 1 to show the actual image of the double number.

Bottom right cell is a link to the other worksheet (sheet 4) in the same Excel file and in that source cell the number is 12542.09?. For some weird reason, it is showing up here twice in the same cell. This is the second time in the past few days this has happened but the first time I was able to DELETE or CLEAR CONTENTS and it stopped doing that. But not this time.



I am running Excel 2016 on a PC with an Intel Quad processor under Windows 10 Home.
Any thoughts?
 

Read other answers
RELEVANCY SCORE 42.8

I'm attempting to write my first macro for an Excel 2003 workbook. I'm not completely code illiterate (I've got moderate skills with AutoLISP), but I'm new to VBA and am not yet an Excel power user, so please be gentle.

The macro I want to write will:
check that the selected cell's content is underlined before proceeding
copy the content of the currently selected cell into an external plain text .log file
.log file lines should be: year/month/day - time - username - cell contents
.log file names will probably need to be generated
clear the cell's content and formatting (particularly underline and text/background color)
Here's what I have so far:
Code:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
Else
If MsgBox("The selected cell is not underlined...are you sure?", vbOkCancel) = vbOk
Then Selection.ClearFormats And Selection.Clearcontents
Else Exit Sub
End If
End If
End Sub
If I've written it correctly, it should currently do everything except log the cell contents. This, from what I've seen, is going to be the trickier part. I intend to use this macro 50+ times per weekday, so at some point the .log files will get too long to be useful, so I assume it will need to automatically create new logs (perhaps "year-month.log"). I've seen some useful info about appending to an external log here and here, ... Read more

A:Excel 2003 macro: log contents of selected cell, clear cell

You need to use the "File Scripting Object" to create and/or append text to a file. I've included a link below to get you started. If you are unable to figure it out on your own let me know and I'll write the code for you.

http://www.virtualsplat.com/tips/visual-basic-fso.asp

Rollin
 

Read other 1 answers
RELEVANCY SCORE 42.8

I want to have a range of cells store something. When one of those cells data is changed, I need another cell to show the date of when the cells data was changed automatically. For example: If Someone changes cell B2, A2 will show the date B2 was changed. Or B78 changes, A78 should show what date B78 changed. I need this to happen for the entire column. Is there a way to have this happen automatically? Please help, if you can.
 

A:Changing Cell Info, Date tracks when cell changed

Read other 6 answers
RELEVANCY SCORE 42.8

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 42.8

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 42.8

Using EXCEL, I have a need to copy the cell contents from upper cells in col. A down a few rows in col A. There are various changes in data in col A as you will see below. The periods in the following info are used as placeholders only. B1, A2, A3, A4, etc. are blank. I need a formula because I have 60,000 records in the spreadsheet. Thanks in advance.

Here is how the data looks now.

....A.....B
Apple.........
..........Fire
..........Ice
..........Snow
Peach
..........Sleet
..........Rain
..........Fog

Here is how I want the data to look

...A ...........B
Apple
Apple.......Fire
Apple.......Ice
Apple.......Snow
Peach
Peach.......Sleet
Peach.......Rain
Peach.......Fog
 

A:[Excel] Copy And Paste Upper Cell To Lower Cell

With the workbook open press ALT + F11 to bring up the Visual Basic Editor. Once the VB editor opens, click INSERT --> MODULE and paste the code below into the blank module. Close the VB editor and select the first cell in column A containing your data you want to copy down. Click TOOLS --> MACRO --> MACROS and select the macro from the list and run it. This macro will copy all your data except for the last value in column A because without actually seeing your workbook, I have no way knowing which line to stop at. Therefore, the code will end when it reaches the last value in column A.

Code:

Public Sub CopyData()

Do Until ActiveCell.Row = Cells(Rows.Count, "A").End(xlUp).Row

ActiveCell.Copy
ActiveCell.Offset(1, 0).Select

Do Until ActiveCell.Value <> ""
ActiveSheet.Paste
ActiveCell.Offset(1, 0).Select
Loop

Loop

End Sub


Rollin
 

Read other 2 answers
RELEVANCY SCORE 42.8

Sir, urgent help please is 6 Cell 72 wh double runtime of 6 Cell 47 ( 60 ) which i currently have , and is it safe to buy after makrket good brand on amazon and ebay same lifetime ? or is it better to buy lenovo power bank 14000 mAh ( which is i think equilvent to 72 Wah ) please answer me in details if possible , thank youuu so much model 20HES0MV0P 7300u nvme 500Gb ssd

Read other answers
RELEVANCY SCORE 42.8

I'm running a spreadsheet for yearly budget using EXCEL 2010. Everything has run smoothly until today. If I enter values on one sheet, it shows up on all sheets. I've gone through the settings for EXCEL but cannot find a setting to change this. Anyone have a suggestion on how to correct this?

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows 7 Professional , Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7 CPU 860 @ 2.80GHz, Intel64 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 8183 Mb
Graphics Card: ATI Radeon HD 4600 Series, 512 Mb
Hard Drives: C: Total - 76216 MB, Free - 8485 MB; D: Total - 1907599 MB, Free - 1891982 MB; E: Total - 476809 MB, Free - 409377 MB; G: Total - 2861575 MB, Free - 2680780 MB; J: Total - 238472 MB, Free - 107677 MB;
Motherboard: ASUSTeK Computer INC., P7P55D-E PRO, Rev 1.xx, 103822980000259
Antivirus: ESET NOD32 Antivirus 4.2, Updated and Enabled
 

Read other answers
RELEVANCY SCORE 42.8

Hello,

I cant seem work out a solution for what I'm trying to do. I have an Excel workbook that has multiple sheets. On sheet 1 i want the data from cell "G3" to be copied onto sheet 2. But i want the location on sheet 2 to be based on whatever was entered into cell "D3" on sheet 1.

For example: Sheet 1, cell D3 I have the name John, in cell G3 i have 68. I want "68" to be pasted in sheet 2 in cell B26.

But if the name in Sheet 1 cell D3 is Suzie, then I want G3 to be pasted in Sheet 2 in cell D26. So I would need to identify the paste location for each person.

I want the data to paste to the next cell so that the next entry can be pasted below the last entry for that person (for John the first entry would go into cell B26, then the next entry would go into cell B27 and so on).

But i want it to be a specific range, i dont want data to be pasted past 20 cells (cell B45). If possible a message box could be created to let the user know that the max is reached.

I would appreciate anyone's help with this as i have been struggling for awhile to try to get this. Thank you
 

A:Excel - Copy paste cell into range based on another cell

Read other 12 answers
RELEVANCY SCORE 42.4

would like to write a macro involving cell references, which changes when the number in another cell changes

e.g if cell = 1, uses b2
if cell = 2, uses b3

please help
 

A:macro help - linking cell reference to number in another cell

Read other 8 answers
RELEVANCY SCORE 42.4

Hi All,

I need an help one excel formula ,i have specific range with prices, but when ever there is a change in value in the range then one particular need to be updated with now() formula. Find below the snap shot of desired data....

Product Changes happened Jan'13 Feb'13 Mar'13 Apr'13 May'13 Jun'13 Jul'13 Sep'13
Apple
Orange
Pineapple
Fruits
In the above data i have values for all product in all months. if there is any change happened then in the changes happened column need to be updated with now() formula.

Thanks in advance...

Vinwin
 

A:Automatic date update in a cell when another cell's value changes (as calculated

Read other 9 answers
RELEVANCY SCORE 42.4

I selected a cell, and then recorded a macro when I copied the cell, moved down to the cell below it and pasted it. But when I select another cell, and then run the macro, it goes to the initial cells I did when I recorded the macro.

So is there a macro where I have selected a cell, whatever cell I decide, and then run the macro, and it copies the cell selected and paste it to the cell below the cell that was copied?
 

A:Solved: Macro to Copy and Paste From One Cell to Cell Below

Read other 16 answers
RELEVANCY SCORE 42.4

Very limited experience with Excel...have a multi page workbook but can't figure out how to auto format existing text to fit in cells so there is no space either on top or bottom of the cell.

Only way I can get this so far is to manually move the bottom line of the text box up to the bottom of the actual text in box. But this causes the print out to overlap sometimes of the text lines in print view.

Is there a way to 'auto-format' individual cells to fit the text in the cell without leaving alot of space above or below the lines, or top/bottom lines, of the cell.

A:Having problem setting cell height to fit text in cell

When you are in the cell that you want to align with the top, Right Click & select Format Cells & when that opens Click on the Alignment Tab & then you will see Horizontal & Vertical, click on the Vertical drop down arrow & select Top. That will align the text to the top of the cell & eliminate that space.

When you move to the next cell to insert the Dollar amount it will be lined up with the bottom of the text in the previous cell, which is what you want.

Read other 1 answers
RELEVANCY SCORE 42.4

Hello,

I am attempting to clear 2 cells, based off the value of another. I am pretty sure the code is correct, because it works within another Macro. Thanks.
Code:
Sub REMOVE()


Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row


For i = 1 To p
Range("k2").Select
If InStr(1, Range("k" & p), "None") > 0 Then Range("L" & p) = "" And Range("M" & p) = ""
'If no Issue, Location/Obsevations should be blank
Next i


End Sub


 

A:Solved: Clearing Cell Contents Based off other Cell

hi
try this variation;
Sub REMOVE()

Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row

For i = 1 To p
If InStr(1, Range("k" & i), "None") > 0 Then
Range("L" & i) = ""
Range("M" & i) = ""
End If
'If no Issue, Location/Obsevations should be blank
Next i

End Sub
 

Read other 2 answers
RELEVANCY SCORE 42.4

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

There is more to it then that but I think this is where I am stumped.
 

A:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)
 

Read other 3 answers
RELEVANCY SCORE 41.6

Hi Lenovo experts - I am having a strange issue with my new X270 laptop. I have been using it for over 3 weeks now. The X270 came with an integrated Li-Ion 3-cell battery (23 Wh) and also an external Li-Ion 3-cell battery  (23 Wh). With very light usage (just outlook and office apps) and brightness set to 25%, I can barely get 2h-2.5h of battery life. Is this normal? Per the PSREF, 3+3 cell should give me ~13h of battery life.  Anything else I can check? I did a 'battery report' and I see on average 45 Wh of charging capacity when active. However 'Battery life estimates' show between 2h-3h at full charge. 'Current estimate of battery life based on all observed drains since OS install' is showing 3:50.  Do I have a defective battery? Any advice appreciated!

Read other answers